Search results for query: *

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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.

sorry, i posted this in the wrong forum

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

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

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

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