Turn on command button wizard Access 2003...

[Dököll]

Jumped for joy last night after learning, indeed, the command button wizard can be switched on or off. Well this occured here, with my Access 2000...an attempt to redo at work failed.

Here's the scenario, quite amusing, and I'll try to sum this up quickly:-)

At home, when the command button wizard (Access 2000) loads and give me some wonderful options/selection tips, the result, code is pre-written for the button when completed.

I found out it is not so at work, so I went to the source. Office 2003 page templates and samples confirmed magic wand like button available in Access turns it on or off, thus reason for jumping into action:-)

my jaw dropped like a stone when I attempted this morning and button was not magic, wand button would not stay pushed in, it came back, rather smoothly by the way, making room for the code screen to pop up instead...

I am smiling now, just as I did just now 5ish. I have a feeling ti's logically possible to fire a nice wizard through Access 2003...loads of information seem to point to it

Side Note: the form/database that I am building seems to have an option to "Convert the Access database from 2000 to 2000 - 2003 Version of Access. I found out today. By then I was drained, I'll look into that later on. We are running 2003, no doubt, says the boss.

This was not as brief as I'd hoped, sorry about that. But what are your thoughts? What do you see happening?

[NeoPa]

I'm registered in here now, but a little confused as to what you're asking.
The wizard works on 2003 at home but not on 2000 at work?
I have to admit I don't use the wizards much myself, although I know a number of the experts are experienced with them. I'll try to help though, if you let me know what you need.

[Dököll]

I'm registered in here now, but a little confused as to what you're asking.
The wizard works on 2003 at home but not on 2000 at work?
I have to admit I don't use the wizards much myself, although I know a number of the experts are experienced with them. I'll try to help though, if you let me know what you need.

Excuse the confusion..

It's the other way around, work loads 2003, wizard does not work there (magic wand fires code screen when pushed, with button selected as suggested by Office 2003 site), I disabled wizard here, on my machine with 2000, it interacts correctly to my demands...

Thanks for looking into this, I am on a brief brake form the site actually:

http://office.microsoft.com/en-us/access/HP051888401033.aspx

Choose "Create a new data access page and a command button that's a hyperlink to that page"

The information suggests wizard can be turned on, but what happens by me is a window pops up and give me a set of options:

(1) Whether to use a the button for open a report, form, run a query, make telephone call, send email, etc...

(2) After all is set, when the form load and button is pressed, the button ges to work.

What this means is the options available to me in 2000, are seemingly scarce in 2003, Or not, I'm still looking...

[Dököll]

Excuse the confusion..

It's the other way around, work loads 2003, wizard does not work there (magic wand fires code screen when pushed, with button selected as suggested by Office 2003 site), I disabled wizard here, on my machine with 2000, it interacts correctly to my demands...

Thanks for looking into this, I am on a brief brake form the site actually:

http://office.microsoft.com/en-us/access/HP051888401033.aspx

Choose "Create a new data access page and a command button that's a hyperlink to that page"

The information suggests wizard can be turned on, but what happens by me is a window pops up and give me a set of options:

(1) Whether to use a the button for open a report, form, run a query, make telephone call, send email, etc...

(2) After all is set, when the form load and button is pressed, the button ges to work.

What this means is the options available to me in 2000, are seemingly scarce in 2003, Or not, I'm still looking...

Here is a saple code created through Access 2000, command button wizard:

Private Sub AddRecord_Click() 
On Error GoTo Err_AddRecord_Click 
 
    DoCmd.GoToRecord , , acNewRec 
 
Exit_AddRecord_Click: 
    Exit Sub 
Err_AddRecord_Click: 
    MsgBox Err.Description 
    Resume Exit_AddRecord_Click 
End Sub

See an example through this link:


http://www.microsoft.c om/mspress/books/sampchap/2533/f02--07.gif

Once a button is placed on a form such as the above the wizard asks what the next step is. After everything is created, code similar to the above is added...

It looks like Access 2003, wants me to type up the code from scratch

[NeoPa]

So it seems that 2003 doesn't have that wizard. Maybe it's just not been installed. When installing Office there are options for which wizards to install. I'll see if I can try it out on my PC at home tonight (2003 @home).
Otherwise, just copy and paste the code in. It's not too variable. Just change all occurrences of "AddRecord" to the name you're using for your command button.
I'm not sure there's much more I can tell you about this I'm afraid.

[Dököll]

So it seems that 2003 doesn't have that wizard. Maybe it's just not been installed. When installing Office there are options for which wizards to install. I'll see if I can try it out on my PC at home tonight (2003 @home).
Otherwise, just copy and paste the code in. It's not too variable. Just change all occurrences of "AddRecord" to the name you're using for your command button.
I'm not sure there's much more I can tell you about this I'm afraid.

Truly appreciate your response, I was afraid something's a-miss in 2003. Hopefully all is well near you with your version of Access, if not, oh well. For now, I have resulted to simply bring work home, build buttons here, then send to work via email...get comfortable at least to what the code is saying to us.

Your a gentleman and scholar, Ade.

In a bit!

[NeoPa]

That reminded me...

1. In 2003 go to Access window and open form in design mode.
2. From the View menu select Toolbox.
3. In the Toolbox toolbar there is a Command Button button. Click on this then click on your form where you want it to appear.
4. The wizard then starts up with various options.
5. Play and enjoy.

[NeoPa]

Truly appreciate your response, I was afraid something's a-miss in 2003. Hopefully all is well near you with your version of Access, if not, oh well. For now, I have resulted to simply bring work home, build buttons here, then send to work via email...get comfortable at least to what the code is saying to us.

Your a gentleman and scholar, Ade.

In a bit!

If you find you need to take work home with you (of any size), then a USB memory stick is often a more practical way to handle that. Much quicker and more convenient (generally) than e-mail.

[Dököll]

Hey! You got it to work, nice...Will try it at work, warp speed. Thanks a million...

[Dököll]

If you find you need to take work home with you (of any size), then a USB memory stick is often a more practical way to handle that. Much quicker and more convenient (generally) than e-mail.

Hello again, I think I've confused things again, at least was not specific.

What I've been doing is make it really messy here, adding buttons all over a dummy form, then copy the code then email that to work. But let me tell you something, you have saved our establishment some server space, we;re talking massive code examples, and this will be an ongoing project.

I thought it to be good doing through email alone, it'll work even better if I can further minimize load to the system. We do a lot via email. Sweet deal, thanks again.

[Dököll]

I knew I wanted to ask you something. At the end of the day today, after my boss tried version 1 of the form; while my form have everything disabled from scroll bars to toolbars, certain menus and so on, then added to the LAN, his machine is showing all toolbars I have deemed disabled at my end, visible. It even showed my form bigger in his office pc and legitimately solid and proper at my desk. Any idea why that is happening...Str ange, don't you think!

Admins have regulated all settings same for everyone, truly amazing.

[NeoPa]

I knew I wanted to ask you something. At the end of the day today, after my boss tried version 1 of the form; while my form have everything disabled from scroll bars to toolbars, certain menus and so on, then added to the LAN, his machine is showing all toolbars I have deemed disabled at my end, visible. It even showed my form bigger in his office pc and legitimately solid and proper at my desk. Any idea why that is happening...Str ange, don't you think!

Admins have regulated all settings same for everyone, truly amazing.

It is mainly because the setting up (customise toolbars etc) is relative to the PC and not the database. There are some settings (In Startup etc) which are db relative but I think what you're talking about is mainly PC I'm afraid.
Test it out and see what you find.

[Dököll]

It is mainly because the setting up (customise toolbars etc) is relative to the PC and not the database. There are some settings (In Startup etc) which are db relative but I think what you're talking about is mainly PC I'm afraid.
Test it out and see what you find.

You got a point there, I should probably build everything from the LAN, at least from the folder where the finished product will be housed. I will start there first. I have not done too much in Start up, will read up about it though...Will let you know...

[NeoPa]

The Startup area is quite interesting. Well worth a look.
Have fun :)

[Dököll]

The Startup area is quite interesting. Well worth a look.
Have fun :)

as expected, it works, it works, hee hee...Not Startup though, hadn't tried this, one thing at a time, know what I mean! But my wizard is now in running order at work. Funny thing, can't figure why it did not work before...Anyway , thanks much! Enjoy your week-end:-)