Hello- I would like to see how I can add a calcualted field to my forms that would show me when an employee is eligible for benefits. I have employee who...

Hi, I wonder whether someone can help me please. I am currently using the following coding to auto populate a reference number within a form: If Me.NewRecord...

I have a field which I need to enter numbers in for each record on teh databse. each record can have an instance of 1,2,3,4,5,6,7,8 once only. But the table...

I have a imported table from a SQL DB that I need to remove part of the data from a field and leave the rest. The data in the field is SERVICE CONTRACT NUMBER...

I am reporting this as my earlier post may not have been too clear. I have a main form for data entry with too many fields to show on one screen so have...

Hi, I wonder whether someone may be able to help me please. Thanks to John Spencer from this forum I have managed to track changes I make in my database...

I have a form with about 7 tick box controls. What can I do so that once one box is ticked the others become inactive and a message pops up that says "You can...

I have a message pop up when a command button is pressed to run a report. The problem is the cancel button is not cancelling the action. It still runs...

OK I've been playing around with this for a couple of days now and have found a few suggestions as to how to do it. But I still can't get it to...

I am not an Access programmer, only user. I have a project that requires Access 2000 only. I need to have a form with two fields (street, city) trigger...

Hi there, I keep getting this error after I update a record, then try moving to another record. When I debug, the error comes up where I am setting my modifier...

Hi, I'm writing a database to help teachers write Unit Plans, containing several tabs of hierarchical information, both within the tabs and between the...

Hi I am creating a database for a security company. I have a form for "Company" 's , "Employees" , and "Contracts On my Company Form, I have a subform for...

This is a follow on from a recently posted query. I am building the criteria for a query on the fly using a form which has 3 elements: 1. 2 check boxes...

I have a subform on my form for data entry. The main form has employee name, division and department. The subform is for data entry on the computer...

Im having a problem with some vba that checks for duplicate addresses. Im getting a run time error #62506. Data type mismatch in criteria expression. This is...

Hello, I have been having a problem with a form of mine with several layers of sub-forms in Access 2007 SP1. When I delete a record from the lowest level of...

Hi. I have a form with a subform. On the form is the following: Trans ID - Autonumber Date Entered CCP No Check No Check Date Status Source On the subform...

I would like to creat a dropdown list in which i can select more then one option and have the options i selected display in a comment of box or text box. The...

I have two Access files given to me by a client. In the "Old" version all fields work correctly, but in the "New" version, some of the fields have the dredded...