Maybe its me, but in the 2003 version of Access and VBA it was possible to load and unload forms programatically i.e. : Load(formName) Unload(FormName) Is...

I have a Database form where the datafield is a combo box. I would like to have the default value of the next record be based on the previous record in the...

Hi I'm using Access 2003 as a front end to SQL server 2000. Yesterday many of the dates I save (but not all) started being stored in American (rather than...

'I have five command buttons on a form. Except for the names, captions and control tip text properties, all the properties for these buttons are...

I have an Access 2000 database that is used by Access 2000 and 2002 users. It also works with access 2007. The database uses the MSWORD Object Library. All...

I have set the Dim string and integer. Then I set up the strQry =......... Then I have code to run the following to count the return of row: modifActCount...

I'm trying to get a total using a text box for one of the fields in a form using =Sum(), but no matter what I try, I get either #Error or just a blank text...

Hi, I have a form that I am using for data entry for a table "Ordered Items". I want to use the form to edit the value in one field of existing records...

I have two fileds on my form..they are both calculated fields, one calulates a dollar amount based on data from another table and the other calculates # of...

How can I set my form to update my fields as soon as a data changed? I tried to do the AFTERUPDATE, BEFOREUPDATE, ONLOAD, but they are all not doing it...

I have a main form with a search by VetSSN. If there isn't a record for the VetSSN it asks if you want to enter a new record. User says yes. It works fine on...

Hello - This problem may be due to the relationship type. I have a property form (frmProperties) with all the general property info, and the record source =...

I am creating a simple form with a combobox that pulls it's store number selection from my store information table. When I try to use the form if I tab out...

Hi I have a form that has 2 subfroms on it. What I am wanting to do is; On click of a date field in subform2 (Datasheet view) Fields a , , , , opens a...

I am currently using form code I obtained from a Doug Steele link, works very well. I would like to use the code to locate files in a specific drive and...

Hi Experts, I have a working treeview but with something missing. When I first build it, it actually has that ControlTip Text that once you point your mouse...

I have a chart that is displayed in an Access form. Each data point on the chart is a person. Is there a way to display the person's name when the mouse...

Access 2003. Need to highlight the current record on a subform setup in continuous forms view. I found a way to do it a long time ago by setting the value...

Hi NG, i'm trying to get my from A97 to A2000 converted applications running under A2007. When trying to attach a table through this ever since...

I created a form using the tab control and when i was designing it everything was fine but now when i go into the Form it is only showing the form header -...