Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Converting Query from .mdb to .adp
I tried to insert the command in the Input Parameter of the form but for some reason it didn't work. But this works though: Instead of naming the parameter @myParameter, I name the parameter the same name as the form that will use it (@FormName). So my code is Select * From... Where...- yguitana
- Post #6
- Forum: Microsoft: Access Project (ADP)
-
Converting Query from .mdb to .adp
Thanks, When I ran that query, it asks me to enter value for @myParameter. How can I set value for @myParameter in the code? I tried: @myParameter = [Forms]![frm_1]![txtBox].[Value] and SET @myParameter = [Forms]![frm_1]![txtBox].[Value] but both give me error "Incorrect syntax near...- yguitana
- Post #3
- Forum: Microsoft: Access Project (ADP)
-
Converting Query from .mdb to .adp
Hi, I'm trying to convert an Access file to an Access Project (Upsize the tables to SQL Server). Some errors prevent me from upsizing my query so I am trying to copy queries from the old .mdb file to the new .adp file. One of my query in .mdb file has this in the criteria...- yguitana
- Thread
- Replies: 5
- Forum: Microsoft: Access Project (ADP)
