I am using Access 2003 I created a preventative maintenance (pm) database that requires the operator to enter the date when a pm operation is completed. The...

It has been a while since I have done a database and forgot how to set up each subform to open when I click on a tab. Or maybe I use a command button. Can...

I have a client who goes completely crazy with his requirements. This means that I have a hierarchical data structure that worked well for the original...

I need to make a document (form) to be able to use electronically. I have to make option boxes so a person can put an "x" into it as an option. How do I...

Iam using the customer order database which I downloaded from the microsoft website. I have a order detail subform which has a combo box which retrieves the...

I need to design a form that will let me change existing data on one field. What would be the best way to do that? The field name = customer number and the...

I am really struggling with a problem and I'm sure the tables should have been designed better but the data base is so large I don't look forward to starting...

How can I use a & in a command button's caption without Access treating it as an underline symbol for the character immediately after it? The command button...

I have a database designed to track exchanges of money that contains account numbers, account names, bank numbers, date, transfer date, and dollar amount. The...

Hi! My problem is basically in a search modal window, where the user is allowed to make a selection on which option to take. After selecting an option and...

I moved a database from a computer which was created with Access 97 to a new computer which has Access 2007. When I open the database I get an error...

I have a table where the records are uniquely identified by a combination of two fields ChildAOLTermID and PhotoID. I want to use a combo on a form to look up...

I'm trying to setup a form that has a control called LANDesk Date Control in it, that allows users to use it to input the data into a table. I don't know...

I have a form called sfrm_status_of_lif_notes In this form there are three text boxes in the Form Header. Number, Status, and Status_dt These three fields are...

Hi All, I want to pass a parameter string to a shell script command but the script is not interpreting the passed parameter. This is the command...

Access 2003 Is there any way on a Continuous form to make an entire row clickable? Any help here will be appreciated. Thanks in advance dave

Strange problem, upgraded an Access database from '97 to 2003 and in one of the forms it has a combo box. On clicking the drop down list in shows no source...

Hello, This calculated field: DateSelect: IIf(=True,Date(),"") in my query can not be formatted to Medium date. I appreciate anyone helps on this Thanks a...

Hi I have used Microsoft's help to create a form which runs a parameter query. After setting the parameter values in the form I click OK and the results are...

Hi I wish to change the format on all text boxes from 'Euro' to 'Standard' I have code for looping through each form. What I'm unsure of is how to loop...