Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mas5
  • Order by date
  1. mas5

    Validation Problem

    Given your code I think you will execute the dataerr no matter what you do. I think your goto exit is in the wrong place. If IsNull(Me!PuDel) Then GoTo DataErr Debug.Print Me!PuDel goto exit_command66_click DataErr: MsgBox "The information required is incompete. Please fill in Pickup...
  2. mas5

    Query two related tables - help!

    The solution is in the type of join you do (Join Properties). If you can see your query in Design View then click on the arrow connecting your two tables. Select the option where you select all the products from the product table but only those records form the sale table where the keys are...
  3. mas5

    Primary Key and Violation

    The error is 3022. If you look in access help you can find all of these types of error messages under the topic Microsoft Jet Error Message Reference. There are several ways to deal with this error. You can: 1) Check for duplicates before you try to insert the record or 2) Check for the...
  4. mas5

    Modify form data but not update it

    1) You can use me.undo. That will undo any changes. I'm not sure exactly where you would put that. The before update event might be a good choice, but you'll be undoing all updates and I'm not sure if you want to do that. 2)Another option is to use unbound controls on the subform and set the...
  5. mas5

    Retrieving a list of interactions between several factors

    Russ - I have some questions for you. For each item in Drug_Class_Class_Interactions, does both Class1 AND Class2 have to be in the list can Class1 OR Class2 be in the list? If you are looking for Class1 AND Class2 then just the first part of the query without the Union should get you...
  6. mas5

    Find,Save,New,Delete Buttons

    Bring up form in design view. Use the wizard to add the command buttons. The wizard will bring up a number of categories: Record Navigation, Record Operations, Form Operations, Report Operations, Application and Miscellaneous. Each of these categories has a list of actions. Just pick what...
  7. mas5

    Dupliate values and counting

    I think this will work. Go to the Properites of the Detail Section of the report. Format Properties and set Can Grow and Can Shrink to Yes.
  8. mas5

    Retrieving a list of interactions between several factors

    Russ - The solution presented isn't calling the same column twice with different names. It is essentially giving you two copies of the DRUG_CLASSES table so you can do independent lookups in each table. I'm still confused about what it is that you are trying to do so I can't answer your...
  9. mas5

    Add a value to null text boxes on a form

    If I am understanding you correctly, in the click event before you run the query add the following code: if isnull(me.text0) then me.text0 = avalue end if if isnull(me.text2) then me.text1 = anothervalue end if
  10. mas5

    Help with code

    Have you declared the X variable at the beginning of your procedure? If you use Option Explicit, then you must declare all of your variables. You need Dim X as Integer (or Long depending on how big the number is.)
  11. mas5

    counting words in a listbox

    I'm not sure if this is what you are looking for, but I'm guessing you are looking for the number of rows in your list box.There is a ListCount property for list boxes. So, if your list box is LST, then LST.ListCount should have the number of rows in your listbox. There is a columncount...
  12. mas5

    Retrieving a list of interactions between several factors

    It would be helpful if you could post the relevant parts of your table structure. From your first note I couldn't tell that you had 2 class ID's in one row of a table. I don't know much about pharmacology, but is that a normalized table? (Will there always be 2 and only 2 class ids?) Also...
  13. mas5

    Trapping Errors In Forms with VBA Code

    That won't work. Perhaps I didn't state my question clearly enough. My issue is with error processing in general, not just this specific problem. I gave this problem as an example. My question is how can I trap ANY VB, ADO, ACCESS or any other error at the field level instead of at the form...
  14. mas5

    Trapping Errors In Forms with VBA Code

    I'm having a heck of a time with error trapping. Here's my situation and what I've done: I have a numeric field. If the user enters a character in the field I try to trap it in the on exist event of the field as follows: Private Sub SortPriority_Exit(Cancel As Integer) On Error GoTo...
  15. mas5

    Error Run-Time Errors in Forms

    I'm not having problems with the isnull part. That works fine. It's trapping other errors that doesn't work as I expected - like entering character data into numeric fields.
  16. mas5

    Trapping Errors in Forms

    sorry, i posted this in the wrong forum
  17. mas5

    Error Run-Time Errors in Forms

    I'm having a heck of a time with error trapping. Here's my situation and what I've done: I have a numeric field. If the user enters a character in the field I try to trap it in the on exist event of the field as follows: Private Sub SortPriority_Exit(Cancel As Integer) On Error GoTo...
  18. mas5

    Trapping Errors in Forms

    I'm having a heck of a time with error trapping. Here's my situation and what I've done: I have a numeric field. If the user enters a character in the field I try to trap it in the on exist event of the field as follows: Private Sub SortPriority_Exit(Cancel As Integer) On Error GoTo...
  19. mas5

    Retrieving a list of interactions between several factors

    If I'm understanding your question then I think what you want is: select drug_class.class_name, class_to_class_interaction.interaction from drug_class, class_to_class_interaction where drug_class.classid = class_to_class_interaction.classid and (drug_class.classid = [first drug classid...
  20. mas5

    Change same values

    I see a flaw in the logic when you reset a to the truncated me.gisname.value. You don't want to reset the a value. I'm assuming that you want each repeated value to be truncated more than the previous. So if you have, let's say the string HELEN three times, you want to get HELEN, HEL, H. Try...

Part and Inventory Search

Back
Top