A2003 prompts for query parameter values...

From: Raja (Raja_at_discussions.microsoft.com)
Date: 01/11/05

  • Next message: John Kounis: "Re: Access Form connected to SQL table in Access Data Project (.adp file)" 
    Date: Tue, 11 Jan 2005 11:35:02 -0800

    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 to ask me 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

  • Next message: John Kounis: "Re: Access Form connected to SQL table in Access Data Project (.adp file)"

    Relevant Pages

    • Re: Converting from Access to SQL2k via Excel- HELP!!!!!
      ... the fact that I had to go from an old/reliable access database to a new SQL ... If you modify it to use a tab - ... I have the format of the files that I must create and I have ...
      (microsoft.public.access.conversion)
    • Re: How do i format a text box to only accept numbers?
      ... We then import the records into an access database. ... Is there a way to format the fields either in the csv file or in access to ... >> validation i understand that i can change the input type to text, ...
      (microsoft.public.frontpage.client)
    • Re: How do i format a text box to only accept numbers?
      ... you would have to format the data prior to it being inserted in the database or whenever you display ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ... > a csv file. ... We then import the records into an access database. ...
      (microsoft.public.frontpage.client)
    • Re: Access database to merge with a Word document.
      ... topic of the "Mail merge in Word 2002" section of fellow MVP Cindy ... "Nigel" wrote in message ... > When I merge this data into Word, the days and dates> get 'mixed' up because it converts them back> into US format AND it also reads the days as months, and> vice versa. ... > I have half-solved the problem by inputting the dates> again, in text format on the Access database> so they don't change during the merge process, but this> isn't ideal because the dates now are in the> wrong order, eg: 19th April comes before 6th April and so> on. ...
      (microsoft.public.word.mailmerge.fields)
    • DateTime not being saved in Access DB
      ... I just created a mini-app with a bound data grid whose ... data source is an Access database. ... in a correct format. ... It seems that only the Update method screws up. ...
      (microsoft.public.dotnet.languages.csharp)