Fill Text Caption with Value 5 128 (6/22/2007 11:58:00 PM)
I have a form that is reading the default values of the fields in the Main Form. One of these values is a number refering the the Unique ID of the field represented as a Combo Box. However, I would like to sh...
Utf

DDL-Adding Autonumber limit 4 201 (5/31/2007 7:11:24 PM)
Hi All, I'm trying to add a PK to a newly imported text file. DoCmd.TransferText acImportFixed, strSpec, strFile, strPath & strFile & ".txt", False strSql = "ALTER TABLE " & strFile & " ADD ID COUNTER CONSTRA...
mcescher

I did a dumb thing. 5 124 (6/25/2007 6:27:53 PM)
I set up my start up routine on my mdb before creating an mde. Now I can't get back into my mdb to make modifications. Is there any way to get back into it? Of course I turned of the F11 like a jackass. Any he...
RobUCSD

code to allow edits in form AND subform 2 878 (6/25/2007 6:18:01 PM)
Ok, here goes............. I have a form (frmBOL) which contains a subform (sfrmData). I have this code working to allow the form to be edited, but I can't seem to incorporate the subform into it. Everythin...
Utf

displaying Query results to subform 3 254 (6/25/2007 4:08:50 PM)
First--the disclaimer--I am in no way a programmer, but I am working diligently to support my team in any way possible. With that said, I have painstakingly created a simple build SQL string code in Access Visu...
barefoot_traveler

Import CSV file and add data to records 2 327 (5/23/2007 7:56:03 PM)
I've seperated my three questions to keep this organized. Basically I am importing a CSV file using an open dialog box..... Now, my already existing table has 5 fields, and my CSV file has 4 fields. Before the...
shmoussa

Access 2003 code does not run in Access 2007 1 206 (6/25/2007 2:56:01 PM)
On my form, I have 2 unbound txt boxes, one named Search_Name and One named Search_Town. There is a command button named CmdSearch. On clicking the CmdSearch, the following code runs. In previous versions o...
Utf

Trying to Create a cascading filter system 0 317 (6/25/2007 3:51:16 PM)
Hello, Using MS Acess 2003 I have a set of records that are identified with common and different traits. For example lets say I have 6 records that are related to apples and 2 that are related to oranges. Le...
takeagoodlook911

Subform/Query Criteria 2 416 (6/25/2007 7:12:00 AM)
Hi everyone I have set up a Query in Access. In one of the criteria fields I have something like this which ckecks each returned record's "state" field against a value from a textbox. This is to see if the r...
Utf

Correlated Subforms 9 166 (6/21/2007 8:11:30 PM)
I am using Access 2003 and I need some help with setting up correlated subforms. My main form is called frmHaz and I need to place 2 subforms on it side by side. I have 3 tables Hazard Risk pk=riskid PMC pk=...
djf