Stored Procedures.. am i being silly?

M

Maurice

No you are not being silly, the article is explaining the ADP projects. So if
you want to use the stored procedures make sure you are creating an ADP
Project.

How to: in 2007 choose create new database but don't click create just yet.
Click on the foldericon to where you want to save your db. In the fileformat
combobox you can now choose ADP. When doing so you will be prompted to which
server you want to connect. When succeeding in connecting to your server you
will see that the ribbon has an additional button under the [other] group
which is Stored Procedures. That's the button the article is referring to.

You won't find this button in a ACCDB database.

hth
 
J

Jonnyphan

Ah yes, that diod help, loads. But, you were wrong. I was being silly! i've
realised that that isnt what i want to do, and im just using the standalone
database! (but thats for your reply)

While i have somebody who knows what their talking about, i mgiht ask
another question!

I worked out how to do a QBF and mangaged to get that working but. When i
submit it, the query works by the critera i put in the form, but it displays
the results in the query window? i want it to display them in a form, not pop
up with a query window.. and then, i can select which of these results i want
to deal with specifically.. then take that to another form to edit or deal
with it.

Does that make sence?

Kind of like the guy is tryiong to explain here
http://bytes.com/forum/thread577985.html

any help would be appreciated =)



Maurice said:
No you are not being silly, the article is explaining the ADP projects. So if
you want to use the stored procedures make sure you are creating an ADP
Project.

How to: in 2007 choose create new database but don't click create just yet.
Click on the foldericon to where you want to save your db. In the fileformat
combobox you can now choose ADP. When doing so you will be prompted to which
server you want to connect. When succeeding in connecting to your server you
will see that the ribbon has an additional button under the [other] group
which is Stored Procedures. That's the button the article is referring to.

You won't find this button in a ACCDB database.

hth
--
Maurice Ausum


Jonnyphan said:
In respect to this KB acticle..
http://support.microsoft.com/kb/286828
i am trying to follow it, but am stuck at the first hurdle.. i cannot see a
button "stored procedures" in the other section of the create ribbion? help
please!

Jonathon
 
L

Larry Linson

Help for the ComboBox Wizard has an option that uses the selected entry to
select the record to populate the form. It could hardly get any easier than
that.

Larry Linson
Microsoft Office Access MVP

Jonnyphan said:
Ah yes, that diod help, loads. But, you were wrong. I was being silly!
i've
realised that that isnt what i want to do, and im just using the
standalone
database! (but thats for your reply)

While i have somebody who knows what their talking about, i mgiht ask
another question!

I worked out how to do a QBF and mangaged to get that working but. When i
submit it, the query works by the critera i put in the form, but it
displays
the results in the query window? i want it to display them in a form, not
pop
up with a query window.. and then, i can select which of these results i
want
to deal with specifically.. then take that to another form to edit or deal
with it.

Does that make sence?

Kind of like the guy is tryiong to explain here
http://bytes.com/forum/thread577985.html

any help would be appreciated =)



Maurice said:
No you are not being silly, the article is explaining the ADP projects.
So if
you want to use the stored procedures make sure you are creating an ADP
Project.

How to: in 2007 choose create new database but don't click create just
yet.
Click on the foldericon to where you want to save your db. In the
fileformat
combobox you can now choose ADP. When doing so you will be prompted to
which
server you want to connect. When succeeding in connecting to your server
you
will see that the ribbon has an additional button under the [other] group
which is Stored Procedures. That's the button the article is referring
to.

You won't find this button in a ACCDB database.

hth
--
Maurice Ausum


Jonnyphan said:
In respect to this KB acticle..
http://support.microsoft.com/kb/286828
i am trying to follow it, but am stuck at the first hurdle.. i cannot
see a
button "stored procedures" in the other section of the create ribbion?
help
please!

Jonathon
 
Top