I have a form with date ranges. How do I change the format from tabbing between dates versus using the enter/return key? Some of my forms use tab and some...

I have a subform based on a query of linked tables. When I use a ComboBox in the SubForm Datasheet to select a record all the fields do not display all the...

Hi I'm using an input mask on a field. The mask is Aaaaaaa (so the last 6 characters are optional.) The mask is set up so that the underscore character...

I am trying to use DSum on a form with multiple criteria: DSum("","", " = ______ I need it to look up and sum the records where the Product ID is any of the...

Hi I am using an unbound combo to search records on the main form. When I first open the form from design view, the combo is nicely set to blank until the...

Hi I am using an unbound combo to search for a record on a form. The underlying fields which appear in the combo come from a table whose input mask...

Hi guys i really need a Query to show the top ten entrys in a table :}

I have a form with a number of fields that enters values straight into a table. Suddenly I cannot view the past records on this form all I can do is add a new...

I need urgent help to bind Company field and a City field to a Combo box of Names,all this data comes from the same table, I just want if I select a name,...

Hi, Relatively new to Access and limited knowledge of VBA.... I have a form (frm_Detail_By_Location) that has many fields on it. The forms' source is a...

I have a form with a subform that tracks the different times a student is on our campus. The primary key is an auto number for the attendance since a student...

I have two reports, and both have daily totals from the same dates (they are from the same table). Can I bring in a daily total from a column in one report...

I have a bound main form with one subform. The subform is linked to 3 textboxes on the main form. The textboxes contain the keys to the data in the subform....

I am brand new to Access (which means that any reponses that use programming language as opposed to software uses instructions will, unfortunately, be lost on...

Can I bind a form to a table in another .mdb file? Thanks Paul

Access2003: When naming "Items on this Switchboard" with the '&' character in the middle, e.g., "AT&T", actually displays as ATT with the 2nd T underlined. How...

I'm using this code on a listbox to find records on the same form. It works fine except I need to base this on 2 criteria not...

On a form, we are trying to sum two fields, which are invoice amounts, and have that sum display in the next field, on that same form. We have tried building...

I have been given the task of making this Access db read-only for some users. Some custom menubar options are used for editing and I need to turn them off or...

I have 2 fields - policy number and policy type. I would like the user to enter the policy number and then have the policy type automatically be set to the...