I have the following code in all my forms to check that the user has completed all necessary form fields. It occurs to me that this isn't very efficient, but I...

Does anyone know of an application that would allow me to view the mdb files? Or maybe there is something offered by a third party that would do the trick? I...

Hello! Are there database size limitations in Access 2003? Also, I am considering a small contracting job building a database. I have never set any...

i need to know how to call an event procedure that will take a day in a month and give a number of days of difference to the end of the month.

Hello, My problem is 1. How to update the text field. For example: the value of this field is 014(Text: data type) change to 425 (Text Data type also) 2. This...

Hi everyone, I just finished a mid-level Access 2002 course at a community college and wanted to put some of the ideas into practice. Can anybody recommend a...

hi, i designed a list box which is generated from a table. the table has field 1, 2, and etc. i want to create Add and Delete buttons. when a user click Add...

I'd like to automatically copy tables to another database for archiving purposes, and to rename them on the way to reflect the date created (as in...

I'd like to take the highest field (numeric) and increment by 1. What's the best way to do this? I'm a self-taught VERY NEW user and have checked out some...

I am currently creating a small ms-access data base, about 10 tables each with about 10 records, these have to link to forms, which have command buttons and...

I wish to create a report in Access 2002. For the detail section of a group, I want my data can display like this: Original: 1 2

I have created 3 tables: Customers w/ id, name, address, etc. fields Items w/ id, descriptn, price, category fields Category w/ id, categ. name Now I need to...

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

For the last year I have been trying to do my ordering and Inventory Control with Access. I have a great database but I cannot figure out how to bring the...

I am a new user a access. When i try to create a query and run it, my result always comes up with no records in it at all.

hi, I am opening an Excel Spreadsheet via Access 2000, but because the spreadsheet has links to other files it pops out the familiar message: "The workbook...

My database is too big for my floppy disk, when i'm trying to save and is also taken along time. What should i do!

Hello all, Has anyone here ever used Access as a tool to store and total hours worked on a bi-weekly basis? If so, how'd you do it? Got any examples out...

I have 2 tables of data. This weeks data and last weeks data. Both have the same number of columns. Both will have different number of rows. Fields to focus on...

i am comparing two tables where both table contains values which has duplicates, example Table1 has three 20's and Table2 has five 20's. On my unmatched query...