Search results

OK, I'm having a weird issue with NULL going. I'm exporting some data to a text file. If all of my fields are populated everything works fine, but if one of them is blank(which sometimes it will be) then I get a runtime error '94 Invalid Use of NULL'. As you can see, I tried to put a selection...

OK, I came upon this a few days ago and I thought I had it solved. It was solved as long as my forms weren't using to different values in the primary combo box. I've built a little cascading combo box system and it's acting a little strangely. So I have a combo box that's populated by a table...

I've got a PO form where I'm selecting names from combo boxes populated by other tables. When the selection is made, the ID# associated with that name is stored in the form's table source. The problem is, when I run a report(using the report wizard) the ID# is displayed on the report. How...

Unlock I can get the object to lock or disable, but I'm trying to unlock/enable the control on new records.... I tried If [Forms]![po_req]![po_number] = "" Then [Forms]![po_req]![po_number].Locked = False End If I tried in the in Current_Form, Before_Update, Got_Focus... nothing...

First question, Can you put multiple commands in an event by separating with a semi-colon or something? I'm running an event procedure in my after update of a combo box to update a table, so now I'm trying to lock the combo box after the person makes a selection. Which brings me to my next...

I'm trying to use and updated query in the after_update event of a combo box to mark a PO number as used after the PO number is selected from the drop-down list. I'm trying to generate a query in query builder to facilitate this. This is what I have and it's not doing what i want. This is the...

Situation: I have a table (po_numbers) with 2 columns: po_number, po_used(boolean). On a form I have a combo box which is populated by a short query SELECT po_number FROM po_table WHERE po_used = False After I select the PO number I'm trying to run an after_update event to change the selected...