Search results

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...

It may depend on how your date is formatted. For example, I have a query that looks for records depending on the year that is supplied. My date is formatted like this 12/01/2004. To strip out the year, I do this: SELECT DISTINCT right([Orders].[Date ordered],4) FROM Orders; I'm assuming if I...

Here's how I do it, but its probably not the best way: I create a form that will capture and pass the parameters to a query. Included on this form is a button that will launch a form, that will use my query and return the requested information to the user. If this sounds confusing, I'll try...

Found the answer!!! Didn't have all the properties set properly: The combobox must have it's RowSource set to either a table or a query (not value list or file) The combobox must have the RowSource Type set to Table/Query. You must set the Limit To List property to Yes (this is the one I...

I have a data entry form which allows users to add data to table A. On the form is a combo box populated from table B, that creates a list of values the user can pick from during data entry. If the user doesn't find the desired value in the combo box, then the value needs to be added to table...

Hate to sound dumb, but the method you mentioned, would we be able to access this via the internet? The application and its data should not be available to the public, but only to individuals within the organization. I can't believe that this whole app will need to be rewritten!!!