Hello..I have a form that has 2 bound controls, what I need is to be able to input the new totals in a text box and click update and have the table to...

I want to prevent Access from updating fields on a form until I click a SAVE button. I don't want Access to perform updates along the way. How can I turn off...

Hi. I'm trying to create a form in Access 2003 to enter data about the kinds of assistance patients need -- dressing, washing and so on. Patients will...

Hi, I need to create a vehicle repair database for a workshop, does any one have a sample database (except for service management database that comes with...

I am trying to replace a section of numbers with letters. For example, I have a column in a table labeled Store Numbers: 1,2,3,4,5,6,7,8,9,10 ect I want to...

This is my first use of a function. I have copied a function and edited to suit my purposes. If I use F5 from the function it runs as planned. How do I get...

I need to add a field to an existing form and Access will not let me use the column add feature in data sheet view or in design view.

I'm hoping someone can teach me to fish here. Is there any tried and true way to find out what package things are in? I tried searching in the object browser...

We have an Access 97 database on our network, used by 110 members of staff, which has been working smoothly for over five years. Four months ago 2 of our...

Personally I find the table relationships aspect of Access the most difficult to grasp for which brilliant software. Is there a good web link that can...

hello there is a form A (--name--surname---speciality--) and a subform B(--X--Y--Z--) the speciality field is a combo box with some standard values... i want...

Hi I have a text box on a form which has no control source. It is for inputting the date like e.g. 11/08/2006 which is used for further calculations. The Input...

Hello. First timer I have a table that holds 3 different fields and what makes each record unique, is the combination of the 3 fields put together I'm not...

I have a query about the Special Equipment Devices. It contains Serial#, several columns of detail, Date, Pole#, SubName, Phase, and Feeder. There are 15 Subs...

I am a novice at programming in Access. I have all my tables built through Design View, my Forms done with Wizard. I'm trying to input data in a test run. ...

I am trying to have field which is 5 diget zipcode querry between two field the low zip Range High range zip to give a store# in that zip(Low & High &...

Hello I read so many messages on this website about the double data entry. But I would really appreciate if somebody tell me if there is an easy way...

I have two tables on parts inspections. One table is for parts and second table is for the testing. I made a form to put this information in, from the help...

hi i would like to ask if a validation rules works into calculated fileds. i have a calculated textbox into a form "=180- " and i want the validation rule "...

I have 2 Excel files that I use to import to 2 tables in Access. When I go to my form, I only see the information in one of the tables. I've double-checked...