We are doing a handicap register for a golf club and really need some help about how to calculate the handicap. The formula we want touse is for each round...

Hi, I have a Update query that is openned via a form name Updateform I really want to have a message box tell the user that how many records have been updated....

Hello, I hate to post yet another question about duplicate entries but I could use some help with this. I have read hundreds of posts regarding this subject...

¼ìÄê¤ý, ¦ÊÅܬP§g, r102030r, ¥§¶ø·s¤B 4 ±ø¥´¹v¥J.

I have a situation which is like this: we are a social group, and I currently have a database hold members, sponsors, events and various other info on a...

Have a form based on a query to calculate an expiration date. WarrantyMonths is a number field. InvoiceDate is a date field. I’ve written the following...

Hi, I'm using Access 2002 and I have a small problem. I can't assign a Primary Key with an index of YES (Duplicates allowed) I even tried the Nortwinds...

I have a subform in datasheet view and I want to hide one of the fields so that only certain fields display when the main form loads. How can I do this?

Hi, I'm a new Access user and have a question about Form Data and how to send the value of a text box to another, different table. I have a form that takes...

I haven't been able to get the following situation to work: I was able to get a form to use checkboxes and comboboxes to allow the user to select what...

I currently have a database on Excel, the problem is that it is a spreadsheet on a network and that not more than one user can access it at a time. They end up...

In VBA code, I'm using a series of "Print #" commands to write to a text file. Somewhere I remembered that putting a semicolon on the end of a command would...

I am new to access and am teaching myself how to create one. I grasp the idea of fields and control sources, but I have fields that need to contain data that...

I've been studying Access 2007 and I'd like to find a good pre-test before I pay for the actual Certification Test (MCAS). I used the Certiport Tests when I...

I would like to count the numbers in a column that are greater than a certain value, I.e. how many numbers are more that the value 30 for instance

I am trying to view my reports at 150% and have used the following code at On Open DoCmd.OpenReport "rptSubcontractors", acViewPreview DoCmd.RunCommand...

I have a database written in Windows 98 which we wish to move onto another computer and use on Windows ME. The ME machine tells me I need to convert this...

If I have a query such as : PARAMETERS NEWID IEEEDouble; UPDATE AVAILABILITY SET AVAILABILITY. = NewID WHERE (((AVAILABILITY.BookingDate)=Forms!!BookingDate)...

I'm having a problem using a validation rule with a numeric field on a form. Ideally, I'd like to require the value entered in the control to be either null...

i have a query that extracts all users details from a table that are what i call current users - i want to use a form to edit current users details so i base...