Search results

I tried the code, but it's giving me the same error message. On (Me.CbSourceFig) The query in the subform is nothing too complicated. It has the text box and combo box in the criteria (OR) Is there a way to stop the requery?

I have a text box where the user enters part of a number. the subform show all record that have part of that number. The combo box show all source of figures associated with that part number. The problem is when I make a selection with the combo box it disregards the text box and shows me...

The names I used here were for this example. I have proper names in the database.

Thank you!!

I'm writing some code to hide the text box if the value is null. I have twenty text boxes. I'm using the code below, but I was wondering if there is cleaner way of doing this. Private Sub Form_Current() If IsNull(Me.Text0) Then Me.Text0.Visible = False Else Me.Text0.Visible =...

sorry, I've been playing with the code and I changed a part I should not have. It should be is not null or not "isnull". I'm trying to get the AS DIFF to show records that do not equal zero.

Yes, in the DIff Column

The query below returns a number of records that have a value of zero. How do I exclude those records? SELECT Len([MasterList_tbl]![AdditionalFig])-Len(Replace([MasterList_tbl]![AdditionalFig],",","")) AS Fig, MasterList_tbl.MasterNum...

Thank you for you help. I got it working.

I'm trying to create an update query. The update will be based on the QTY, Price, and Unit. In the code below I've done the first part of the formula. Inside the false section of the IIF statement I need to lookup the value of the Unit in another table then divide the (QTY*Price). The...

It work!!! thank you

I get #Error

The [Number of vehicles] is stored as text. I tried = Text66 and I still got #Name?

I have a text box on a form that looks up the number of vehicles in another table. there is only one value in the table. =DLookUp("Number of Vehicles","NumberOfVehicles","[Number of Vehicles]=" & [Me]![Text66]) Number of Vehicles is the column name NumberOfVehicles is the table name Text66 is...

There is not a maximum number of additional fig/items and there can be records with no additional figs/items. Also, sometime there might be an additional item but no additional fig. (those records are erroneous and will be QCed later but they still need to be shown) This might be applied on...

I have an access table that contains data similar to the first table below. (There is more but I don't need it for this part) MasterNum FIG ITEM Additional Fig Additional Item 88 BULK 24 130, 155, 157 22, 6 89 4-2 25, 212 11, 14 I'm trying to come up with a way to copy the...

The problem is somewhat solved... I've added the ms activeX data objects recordset.... library to the reference. And i do not get the error message but I'm not getting the correct info. What the table audit table shows for OldValue is actually the new value and the NewValue field is blank...

The error message does not highlight a particular line. the error message is coming from the auditerr: MsgBox. If I turn off the msgbox, the audit table is still blank. I've have added the space between "* FROM" and made the changes suggested by CJ, but I'm still getting the same error.

I'm trying to track changes made to a subform. Anything added, deleted, or editted will be recorded in a table called Audit_tbl. When I make a add or edit a record i get a 3001:Invalid argument error. I'm calling the function in the form as Before Update event procedure. Attached are the...

I got it to work. the problem was I need to delete the temporary query before I created it. I added the code below before the query was created. On Error Resume Next DoCmd.DeleteObject acQuery, strTempQryDef On Error GoTo 0 Thanks for everyone's help!