In my application, I have a button for adding a new record, and a second button for bringing up an existing record for modification. Can I use a where...

I recently went from win98 & Office 97 to Win XP with Office 2003. All works well apart from Access querries with a date field wont run and give "undefined...

Is there any way to post an Access chart into a Powerpoint presentation? Thanks John

I have done a conversion of a 2002 access database to a 97. How can I view the 97 version if I am running 2002. To make sure everything works in it? Is there...

Hi, Can I get a calculation like a running sunm to work inside of a table. This is what I want to do with these fields. cars - season - races - racesleft I...

How do I protect forms? I need individuals to be able to get into their forms and not see others. Can I password protect individual forms with different...

Hi all, Can I populate a ListBox (or ComboBox) with the rows drawn from a query AND the choice "All" listed as the first row of the ListBox? If so how? This...

Is it possible to sync to a linked table within access? I ask because I have an Access database which has ODBC linked tables to a MySQL database. I want to...

Hello, I just upgraded to Access 2003. I opened an unsecured db, created a simple Access Data Page, and when I tried to view it, first I got some other error...

With a list box having many entries, I can select a row as Selected but is there a way to move that row into the visble portion of the list box. That is if I...

Hello everybody, I'm using trying to search records in Access 2002 for a hospital database, but the following code snippet gives me a type mismatch: Dim...

Users are having a problem opening Excel within Access in that it creates a 'psuedo-database' (they are not importing). Access is creating a database with the...

Error: Microsoft Access can't start because there is no license for it on this machine. I have the Microsoft Office 97 Professional Edition Currently running...

I know that these Data Access Pages are really a sort of webpage to enter or see data. How would I go about posting theses pages online in order to have...

Hi, I am writing some code and wonder, would, say, 75 fields by a few thousand rows be a problem for the software. -- Jim Shores, Red Mountain, Birmingham,...

Do you compact regularly? Any chance this is a monolithic multiuser database, or a split multiuser one, with all users sharing a common copy of the...

I have a delete query to delete a bunch of records from multiple tables that have reletionships with one another. I can do a select query, and the records are...

We have a memo field for each record and what I would like to know if there is a limit to the date we can enter both for the individuel record and also the...

Hi, I used the following line code to add a new field, but if I use NUMBER doesn't work, but if I use VARCHAR works! What am I doing wrong? DoCmd.RunSQL...

I'm upscaling an Access database to SQL, but have to change a few table field names as I foolishly gave them names that are reserved words in SQL. Are changes...