I have two subforms on the same tab. Both of them use the same table. They are supposed to be linked to each idividual contact in the database. Each time a...

Hi, I have a form setup with a subform within it. The subform is currently in a Datasheet view. I would like to stop a column from being viewed. Is...

Hello, I have two tables RFI Log and Event Req. Both tables have the field 'Event No'. A RFI field is under both tables. Under RFI Log the field is named...

I'm trying to use the down/up arrow navigation keys on a standard combo box (ie. open combo box, scroll to correct selection and press enter to select and...

Using Access2000 for development (end users using Access2003) I have a table of clients, T_CLIENTS and companies, T_COMPANIES. There's a 1:M relationship...

I have two forms and I want the user to be able to switch back and forth between them. The forms use data from the same table and from only one table. I...

Hi, Is it possible to create dynamic controls (text boxes and labels) on an Access form. The Access help only mentions ControlBars, although VB allows for...

Hello, I am using a Tab Control and moving a set of fields/labels into the Page section of each tab. I am finding that each Page is 'forced' to be the...

Hello I am developing a new database and created a form that contains 2 subforms. I created code behind the main form that was connected to one of the...

Dear newsgroup, For a fairly simple MS Access application I need to create a form to enter a few fixed fields of customerdata and answer a unknown number...

Hi. This is a curious one. My Users say that this used to work but now does not and I can't see why. I have a form with a subform. Previously, the users...

I have one main form with two subforms. I can enter data through the form and all info is logged into the corrosponding tables except for the ID numbers that...

Using MS Access 2003. I would like to set up my forms such that I am the only person who can get into the design mode of these forms. Thus far I've set the...

Is there a way to sum a specific column in a query? What I have is a query that pulls several line based on a id field. I want to total just 1 column in the...

I am building a database to store data for biological sampling of fish. I have a trip form with all the data for individual trips (includes a calculated unique...

Hiya I am having a big of a bad time trying to get an upload button to work on my site http://www.templates4auctions.co.uk/submit_a_template.htm I have added...

I have created a Main menu and a Print menu. Editing the 8 options in each is not a problem. Editing the appearance on any but the Main is...

Hello- I think I am missing something simple. I have a table (tblItems) that is part of a query (qryInquiries) containing several fields from this table and...

I designed my form and see it in design view but it doesn't appear in Form View. How do I get it?

Each record starts with an Autonum Id Field which is incremented by one; ten fields follow. I need a control button on my data entry form to add the row of...