Hi, I've created a form that utilizes a drop down box with a SELECT DISTINCT statement to pull information from a record that I choose. After the information...

Hi, Just a simple question... I have a main sheet in my DB that I would like to open automatically when the user opens the DB. Can you please tell me how I...

Hi, I am creating a form using Access where the user's input a numeric value in a field, then I created another field to do the calculation based on the...

I'm writting message box prompts and on some of them I'd like to break the line. Access help says If prompt consists of more than one line, you can separate...

I have 2 forms. I would like the second form data to save to the same table and record as the first form. What is the best way to set up this...

Hello, I am working on a database, the most complex I have done so far. Along with functionality I am also working on making it visually attractive with few...

Hi there I have created a form which links two feild from other form, and then i have a memeo feild. The issue is that when i scroll the mouse those linked...

I have a database that is shared over a network. I have split the database into FE and BE so that users can view information simultaneously. However, just...

Hello All, Please can someone help me in this?? I am trying to create a subform in a form to show a list of items. What do I have to do to be able to click on...

i need to create on a form with MANY checkbox controls. they're to be laid out in a crosstab layout. i need to have the controls named in a...

How can i define the position where an acces form has to appear when the same is opened? thanks.

Hello, by default with a continuous form the data scrolls vertically in a downwards direction with the empty field for data entry at the very bottom of the...

How do I write SELECT statements in VBA. I keep getting "Need Case" Error. I want to pull fields from a record based in entries from another field on the...

I would like to do some editing on PivotTable Forms. I've tried to follow the Microsoft Access Help on this issue. I'm pasting the article: xxxxxxx Edit a...

Hello, How do I create or customize the find option to first ask for a first name and then a last name and locate the desired record? Thanks Marguerita

HELP

Hi, Probably a simple question ... In a table I have a particular field with datatype set to 'number' (called "Item Number"). It is also the primary key. I...

Hello All, Problem: I need to run append and update queries based on a continuous form. Is it possible? Details: My dbase would benefit if I could make a...

I spun my tables out to another database and then linked my "Application" MDB to the "Table" MDB. I now get an error message with the following line...

I was told that there was a limit of 255 fields per form but I did not see that in the access specifications in the help file. It was suggested to me...