Recent content by Oyster

I opened each table in Design View. One TableA can have many TableB's. Here's what I see: TableA: LabIndSampleCode (Has a key beside it), datatype is text DateExtraction (Has a key beside it), datatype is text Labbatchcode, datatype is text MethodExtraction, datatype is text TableB...

Can't figure out why I can't create a one to many relationship between two tables: TableA uses a composite key as its primery key (field1, field2). The table has a unique index comprised of these keys. The index even has a name. The table also doesn't contain any duplicate information, so the...

Could you list the fields in each table so that we can get a better idea of your data flow? Sounds like you only have three tables? Addresses, invoices, and a linking table? You really can't have a many to many relationship because at some point, there must be something that declares that...

I tried adding a "Add Record" button to my form with the code: DoCmd.RunCommand acCmdRecordsGoToNew behind it. Now the "form" thinks I'm trying to add duplicate records when I press the "Add Record" button. Thanks!!! :D

You'll probaly have to add a "Rank" indicator to your table for each job title: Rank.............JobTitle 5..................Project Manager 4..................Assistant Project Manager and so on SELECT [JobTitle] FROM [JobTitleTable] ORDER BY [Rank] DESC;

Isn't there a way to make it automatically do that once the Save button is pressed? Thanks!!!

My data entry form has a button that allows the record to be saved. However, after saving the record, the form doesn't allow a new record to be added. The new form just sits there with the previously entered information in it. How do I go to a new record?

How I can I suppress the apprearance save record messages? Thanks

It's working now! Only had a slight error: Private Sub CmdSaveSampleArrival_BatchSampleInfo_Click() On Error GoTo Err_CmdSaveSampleArrival_BatchSampleInfo_Click Dim i As Long Dim strSQL As String For i = 1 To Me![#Replicates] strSQL = "Insert Into IndividualSampleInformation (...

Thanks, but I'm afraid its still not working. I plugged in your code and I'm getting an error at "Values('" & Cstr(i),. The comma after (i) is highlighted and the error says, "Expected : end of statement" Private Sub CmdSaveSampleArrival_BatchSampleInfo_Click() On Error GoTo...

I'm new to VB so any help will be appreciated: I'm getting an Expected: list separator or ) error message when I try to run this code. The problem appears to be my RunSQL statement. Thanks in advance for the help!!! Private Sub CmdSaveSampleArrival_BatchSampleInfo_Click() On Error GoTo...

Here's what I'm trying to do: Form A is used for data entry into SampleTable. On this form I have a some fields including these two: ReplicateA, LabBatchCode. The database contains another table, IndividualSampleTable. This table contains two fields: ReplicateB, LabBatchCodeReplicateB...

I have a form with a Combo box, populated from table A. From this list, the user can select a item for data entry into table B. If the desired item is not found in the combo box, the user can launch another form that will allow the item to be added to table A. However, when the user returns to...

This only works if you have the main form open. What happens if you need to enter new records in the other table? Once the records are added and you exit the form, you'll bomb out if the main form isn't open.

I've run into this problem myself. At least where I'm located, it's impossible for anyone to run my Access application without having Access loaded on the user's machine. We are currently in the process of rewriting the application for the web instead. Also, if you have Mac users, unless they...