Search results

  1. O

    No unique index found...

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

    Clear a data entry form

    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?
  3. O

    Suppress Save Record messages...

    How I can I suppress the apprearance save record messages? Thanks
  4. O

    Expected: list separator or )

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

    Insert recs based on a given number:

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

    Update Combo box when change made to underlying table

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

    "NOT IN LIST" event not working on combo box

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

    Internet>>Making application available over Internet

    What is the easiest way to make an application available over the internet? My web master says we'll need to rewrite most of it in ColdFusion, but there must be a better way. I'm new to web deploying apps so I have no idea where to begin. Please provide as much info as possible. I thought the...
  9. O

    Form to update a record...

    I have a form that is populated by a query. Once this data is retrieved, I'd like to be able to make changes in order to update the record on the table. Can this be done?
  10. O

    Print a Hard Copy of Form

    Is it possible to easily create a hardcopy of a form so that I can email it, or, print it out and give it to users to fill out?
  11. O

    Split tables>>Front end doesn't recognize backenc

    I split my database. Then got the bright idea to rename them. Now when I launch the front end (which contains the forms, etc.), I get a message saying that it can't find my backed. I've tried renaming the back end back to its original name, but its still not working. What is the best way to...
  12. O

    Switching focus from form to form

    I have a switchboard. From the switchboard, I select a button to run a form (Search_Form). Running Search_Form allows parameters to be passed to a query. The query itself is attached to a form that displays the requested information to the user. However, when this form runs, the Switchboard...
  13. O

    Creation of "subtable" ?

    I don't even know how to ask this question! Is it possible to do something like this (dotted line is not part of the data): DNA Primer Set............Reagents.............Initial...............Final COMBIII.....................Template DNA.........50.....................7...
Back
Top Bottom