If a data field in a form is limited to a list, is there a way to get Access to drop multiple fields of data in the form for that one record in the table? ...

When a record is opened (i.e. when a particular ref number is chosen from the dropdown and the relevant form opens) we need to have a reminder message if...

I have a a form that's in Datasheet View and I'm looking for a way whenever I click a specific record on the Datasheet view that I would want a Form to open...

Anyone have code that will press a button on a form after it is un-hidden? I basically have a filter button on a form that I would like to execute after the...

Hi All, I need my user to close the database (& Access) using a button on a form, not by any other method (there are long, involved and irrelevant reasons...

I have just added a text box and used the current date expression as its source, but now when I click preview on the form it just shows grey and none of my...

I had 2 tables, called ProdInfor1 n ProdInfo2. Both are linked by Product Code. Info1 contains the Product Item and Info2 contains the Size. So I have this...

anybody know how to use MS Access to convert anything (from) such as, MS. Excel, etc to produce .txt?? i've no idea about this. if there is somebody could...

I have a form with a subform, and for some reason I am prevented from entering more than 10 records on the subform. I get a key violation error. I've...

I guess I cannot close msgbox after predetermined time in code. So I want to use a form to display message and close automatically in 2 seconds. How to do...

years ago when starting my Access Program I allowed my main form the use the default name "Table1". I didn't know then how many other things I would...

I only want a textbox to display if the control source value is not null or not an empty string. I set the text box can shrink property to true and then test...

Thanks so much for your help! We are using Access 2003 and have a form (based on an underlying query) that is used to keep track of 5 vehicles being used by...

My cboFind will show and . I use wizard to create following code. Private Sub cboFind_AfterUpdate() ' Find the record that matches the control. Dim...

I am trying to creat a databse by which I can track the projects my company is doing (mainly to creat estinates and invoices). Currently I have a main form...

Hello Everyone I have 3 number fields, all currency in a form. I have Budget Amount, Estimate Amount and Difference. What I would like to do is to make the...

Hi, everybody, I have created a "Master" form with a "Detail" subform. In the subform, I have an botton that will open the "INPUT" form to add new record...

I have a existing access 2003 database that I wanted to add another button but when I go into design mode my toolbar disappears and I only see the grayed out...

hi, hope somebody can tell me what i did wrong! :( i have a form with 4 pages and each 1 has 3 subforms that get their data from diferent querys, it was...

In a form, I need to indicate the relationships between two people. I have tables for types of relationships (supervisor, team leader, team member) , the...