Search results

  1. K

    access crashing

    How do I compile just one form? Also, is this just a freak thing or is there something I am doing that I can prevent this from happening again?
  2. K

    forms and subforms

    I have a form with two subforms on it. I would like the user to enter information into the form but once saved, I would like them not to be able to edit the form's information. When I go into properties and select: Allow additions, No edit, on the main form, one of the subforms is blank...
  3. K

    access crashing

    I have a form I have created for searching the database. The form is composed of several Colored text boxes with labels to the side describing the action. Behind the text boxes I have coded an Openform statement as an event procedure - ON CLICK. This is a secured database and another facility...
  4. K

    Query

    Pat, I finally got it to work - thanks for your help!
  5. K

    Query

    Thanks for the code, but I am a bit confused. The filtername is the name of my query? Also you have the below code: DoCmd.OpenReport "reportname",acpreview,,"CROP_Code = " & YourForm!YourControl What is CROP_Code? Is this the name of the field I am using in my query? You also...
  6. K

    Query

    I have created a query which queries another query. The information is then used to generate a report. All the information gets posted on the report and is working great. Here is the problem: I have also created a form which asks the user to choose a CROP (this is the criteria I would like...
  7. K

    query

    I am new to VB: I would like to use a form for the user to select from a list box a location ( I would like for them to be able to multi-select). Once the user has selected their location(s) I would like this to populate another list box - just to show the user the locations that they have...
  8. K

    Determining Length of a string

    I should state before asking this question, that I do not have any VB experience. I have a field called Sequence and another field called length. The user inputs the sequence information, example ATGCATCAT. I would like the length of this string to be determined and have that information...
  9. K

    Automatic fill in

    I have one table called Primers, whose primary key is PrimerName. I have designed to forms, FormA =PrimerF1 and FormB =SUMMARY. The user inputs information into formA creating records for each primer. The SUMMARY form has a list box with a field referred to as Primer 1 Name. Once the user...
Top Bottom