I am designing an Access database that will eventually be moved to a SQL server and be web-enabled. I would like to be able to track login times for users who...

error 3001 Invalid Argument running append query I run an append query fine, then out of the blue it wants to give me this error. I noticed when I changed my...

Why, when I try to debug a private sub in Access 2000 do I get the error message "User Defined Type Not Found" on the line Dim dbD as DAO.Database Steve

I am working in MS Access 2002 on Windows 98 SE. I am working on a database about employees. It has a single table with following fields: (1) OfficerID ...

Thanks in advance

Hi Everyone, I am starting a new database. I made one a couple of years ago but it's a nightmare. I thought I would go step by step with you guys. The...

I have built a table that contains monthly sales totals from each our 52 stores. I have stores as rows and months as columns. Ex: ...

I am trying to write a resume.. I just activated my software, but the screen is telling me that my document is locked. How do I create a new document. ...

I have a form that asks for user input. Is there any way that the user can fill out the form with, say, a number (studentID number?) and the name associated...

i have a query based subform listing e-mail adresses of people filtered by a combobox from a main form. I want to add a checkbox to the subform, so that the...

Hi All, I'm a new employee, and my new boss has handed me an enormous mailing list in Excel. I'm hoping I can clean it up using Access, but I'm not...

I don't know SQL and I have searched high and low through Help, but I can't figure this out... I have a table that uses a Notes subform in which the users...

Hello all, What's the best way to login users, then only display data that pertains to them? I'm creating an Access Time Clock of sorts, and would rather not...

when im adding a number eg 5.99 why does it show up as 6.00, i was told when im setting up the table and i put data in as numbers that i have to alter...

Newbie question - sorry. I have an Access 2000 database on an old computer and I want to transfer the database and all the records to a new computer. I don't...

Minimized excel spreadsheet. When I brought it back up the typed data had disappeared. How do I retrieve it?

?s there a way I can relink all tables to a new folder, I seem to always get prompted for one at a time and I have over 50 tables! I never had to do this in...

Here is my dilemma. I have a query from a database containing multiple fields. The initial query searches a total of 8 separate fields for particular text. For...

Hi to all I require help for what maybe a simple problem. I have a form frmPettyCash and on the form are 3 buttons Cmd1, Cmd2 and Cmd3 which open the...

I have two tables: TblCourse CourseID CourseName TblClass ClassID CourseID ClassDate