I have an On Load Event Procedure for a single form to turn the Mouse wheel off as follows: Private Sub Form_Load() 'Turn the Mouse Wheel Off Dim blRet As...

With much help and a lot of head scratching (learning), I have the following code (working and tested) and to get this project completed (crunch time) I need...

Hello, I have created a report where one of the columns is "Status" where the status can be Valid or Cancelled. I want the sum of the Valid and Cancelled...

I have a form sub form one to many, multi-user database. This will be split with the backend on a network server and front ends placed on a couple of...

I manage a large Apartment Community and need a program to do a better job than the Excel databases we have now. Access looks like the way to go. Got a copy...

I hope this is an easy one for someone... I have a text field that so far only has two options (though more may come). I wanted to use option buttons on a...

I have tables Products and Customers. they are related thru pk in Customer and fk in Products. The customer field in products is a lookup field from Customers....

Is there a way to run a cross-tab query between a specific date range?

Hi, quite new to this database thing :) I'm using Access 2000, I'm trying to get a form to display a drop down box that has values from one table, and to...

Ok, I am a newby here. I have a report called MDB Data that is ran from a query called MDB Data Query. What I want to happen is when the report is clicked,...

Thank you, everyone, for your help earlier. I am having one more inexplicable difficulty with my tables now. Again, I have three tables: Courses (with an...

Hi, I am a intermediate user of Access and having great difficulty with my first split database, let me explain my problem. I created a database that uses...

Hi, Please excuses my ignorance - I am currently running a macro in A2000, which comprises 10 make-table queries. The problem is that everytime the macro...

On page 187 of MS Access 2007 Inside Out the author is not very clear in the second paragraph , "Note that once you define a relationship, yo can delete the...

Hello all, I am using access 2007. How can I capture the date/time of the last usage of my database? (either it was last open and closed, or it was last...

Please could someone explain to me command buttons. I wish to include them in my form so as to , find record/save record/delete record/add record. How do I...

Hi - I have a field of type Long, the data that goes in the field are numbers like 027987 and 564982 Every time I enter a number with a 0 in front access...

I tried to use the advice left in my other post of the same nature, but I cannot find datatype in my properties box for the text box whose character length I...

A corporate database has a one-to-many relationship between its branch offices and its employees. The Atlanta branch, which currently has 50 employees, is...

I am currently working on a response log data base for the fire district. In the log I have fields such as RunNumber, Calltype, Date, Address, and others. ...