If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
input popup only in Access 2003
I have an Access database application that was written in Access 2000. I have
converted the database to Access 2003 format. When I run the applicaion in Access 2003 it is prompting me to enter value for all the "WHERE" clause values in any query. For e.g. when it executes the following line Me.RecordSource = "Select * from qryHierarchy where appID=1" I get a popup box prompting me to enter appID, though I have hardcoded appID=1. It is the same case for all queries in my application. This application works well in Access 2000 and Access 2002 (SP2). It does not work in Access 2003 and Access 2002 (SP3) Does anyone have any idea about whats going on here... Thanks in advace for your help. Regards, Raja |
#2
|
|||
|
|||
On Tue, 11 Jan 2005 11:33:07 -0800, "Raja"
wrote: I have an Access database application that was written in Access 2000. I have converted the database to Access 2003 format. When I run the applicaion in Access 2003 it is prompting me to enter value for all the "WHERE" clause values in any query. For e.g. when it executes the following line Me.RecordSource = "Select * from qryHierarchy where appID=1" I get a popup box prompting me to enter appID, though I have hardcoded appID=1. It is the same case for all queries in my application. This application works well in Access 2000 and Access 2002 (SP2). It does not work in Access 2003 and Access 2002 (SP3) Does anyone have any idea about whats going on here... Thanks in advace for your help. are this linked tables? paste the SQL-String into the Query-Designer does it ask also? --- If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message MW |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2000 -vs- Access 2003? | Mark | General Discussion | 5 | November 30th, 2004 06:36 AM |
how do I make access 97 deafult over access 2003 | Mina | General Discussion | 2 | November 5th, 2004 10:34 PM |
access 2003 can't open an access 2000 mdb | Sean | General Discussion | 7 | August 13th, 2004 06:41 AM |
Help! Access 2003 Stop Error Msg. Pop Up when trying to access Table or Form Wizards | Wayne Morgan | New Users | 0 | July 12th, 2004 01:17 AM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |