2007 combos

[ajetrumpet]

Hey folks,

Has anyone had problems setting controls as query criteria in Access 2007??
I have been up late many nights, so I think my brain's defense systems are down, but I'm not seeing any violation of the SQL. I am getting criteria popups for my reference syntax....kinda strange....

Also, I'm not too impressed with the reduced dropdown list in the 2007 macro design window. Any comments on this?? I'm having to include a few more steps into my macros that weren't really necessary in 2002-03.

 

[boblarson]

Hey folks,

Has anyone had problems setting controls as query criteria in Access 2007??

I haven't

I am getting criteria popups for my reference syntax....kinda strange....

Can you post some of the syntax what you are referring to?

Also, I'm not too impressed with the reduced dropdown list in the 2007 macro design window. Any comments on this?? I'm having to include a few more steps into my macros that weren't really necessary in 2002-03.

I don't use macros anymore, other than an autoexec macro at times, so I can't speak to that. I know that there was some talk years ago that Microsoft was going to move towards less macros and more into code but I can't remember the reasoning behind it.

 

[ajetrumpet]

Bob,

the code that is giving me criteria pops are just simple object ref. syntax lines....

Forms![formname]![formcontrol]
Me![formcontrol]

I have checked controls and queries for misspellings and names of objects. Everything is OK in this arena.

Was there any kind of code changes in syntax like this??

I am also running Vista now too....I'm not sure if that plays into it, but I know that the first time I ran Access on this OS I got an annoying popup error on execution of a desktop file.

 

[boblarson]

Any chance you can send me a copy (or post it) so that I can test it on my A2K7/Vista system to see what is up?

 

[AccessJunkie]

Also, I'm not too impressed with the reduced dropdown list in the 2007 macro design window. Any comments on this?? I'm having to include a few more steps into my macros that weren't really necessary in 2002-03.

Can you be a little more specific on what is missing from the macro design window? If you're referring to not seeing as many Macro Actions then click the Show All Actions button in the Show/Hide group on the Macro Design Tools tab. (It's a toggle button.) By default, Access only displays "trusted" macro actions.

--------------------
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[boblarson]

By default, Access only displays "trusted" macro actions.

I keep forgetting about that one Jeff. I must remember that for when someone asks about that "reduced" list again.

 

[AccessJunkie]

I'll put that tip on my site in the near future so people can point to it.


--------------------
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.mspx
----------

 

[ajetrumpet]

Thanks Junkie....that way easy. Feel kind of stupid too...

Bob, I can't give you a copy, but I'm gonna make another test DB and see if the same syntax works there. If it doesn't, I will send you that one so you can test it.