Search results

Yes, I thought it would be hard to explain. Please allow me to try again: I have a materials table with 11 fields. On a form of another table A Combo Box was setup ( You know this cboMaterial_ID) in which only three of the fields are displayed on the form in the Pull down window. The...

Will someone please tell me where in Access 2010 I can modify the displayed fields of a Combo Box on a form. I need to format the display window and add criteria to one of the fields. Can't remember where I set this up and recently upgrading from Access 2007 isn't helping. Thank you Dale

Ok Thank you, I agree and want to make this statement as fail safe as possible by accounting for Nulls. but when I put a null or blank in Column 4 "Issued_quantity" and use this statement: QTY_Available = Nz(Me![cboMaterial_ID].Column(3), 0) - Nz(Me![cboMaterial_ID].Column(4), 0) I get a...

SH#T! Just realized it. Problem solved.. Dawned on me, the Issued Quantity field is blank.."Null" need to go back and fill in all fields with zero to start. Hence type mis-match.

:banghead::banghead::banghead:!! Agree, Should be 6 and has been changed...still sames error, type mismatch 13 Even still, column count starts with 0. so pointers are still valid correct? Could the problem be this is a open record and the Combox can only pull one field of information...

Column count property is 4. Row Source is as follows: Not sure I understand this. Seems like it should be 6 based on the Row source? In any event, the two columns call (3& 4) are in the right spot. Should I change it to six? Pr2 -eugin & Baldy as always thank you for your help. Your...

Thank you, nice site you have....Expert. By the time I get my answer from Research my application will be obsolete. Would you help me to find out why the below statement will not work? This statement alone works fine QTY_Available = Me![cboMaterial_ID].Column(3) ' Get the quantity available...

Hi its been a while since of written in Basic....15 years. I am doing fairly well...having fun too, but can anyone point to a good source for researching code examples that gives good explanations and examples of statements and proper syntax.?

Yes, Thanks

Understand about the pay and appreciate it. Conex 1...8 and all the stuff in that lookup are locations on the property where the materials are stored. A Conex box is a large steel container typically seen at shipping ports and on trains. I will get rid of the look-ups and replace with...

. cccccccccccccccccccccccccccccccccccccccccccccccccccc

OK, Here it is Mastectest5. Let me know when you get it. I appreciate all your comments

Yes, we are getting close but what are you saying will work? The example I provided above came from the link you forwarded me. Unless the insert command will work, scratch that info. From what I understand this code below works because the record set of the Material Table is closed when the...

Ok, we are talking about the same thing. This helps: and I mis-spoke. The record has been created and is currently open.....I think . I mean the VBA code is called AfterUpdate of the second field of a form of four fields. So I imagine the record is still open. While in the VBA code the user...

Jdraw, Thank you. I agree all of my variables have unconventional names and should be renamed. This is because I have not programmed in quite a while and this started as a proto-type. It has migrated to what I want so it is time to overhaul. Anyhow, you have nailed it. This record has not...

I am reading and researching and testing but it so hard to find the correct syntax to get this to work:banghead:. In the "Where" clause, I want to tell it to Update the field in the current record that is open. I know what I have won't work but what will? 'strSQL = "UPDATE allocation SET...

This is the output of the immediate window: UPDATE allocation SET QTY_Allocated = 2 WHERE Material_ID = 31QTY_Allocated is correct at 2 but Material_ID = 31 is not pointing to the correct table or record ID. I want this QTY_Allocated to write to the current table "allocation", where a new...

Look at the four statements in red below. Does that make sense? Don't I need a new Combo Box or Text Box if I am switching to a different table and writing different information? Private Sub cboMaterial_ID_AfterUpdate() Dim Number As Integer Dim NumResult As Integer Dim result As Integer Dim...

....Thanks. so much! Unfortunately, I am getting a run time error again "3061" too few parameters after this statement: CurrentDb.Execute strSQL, dbFailOnErrorQuestion: Is this statement needed After every statement strSQL = "UPDATE allocation Set.......Because when I comment one out...

Yes, did you write this statement ( Not sure where it came from). In any event, this statement: strSQL = "UPDATE Materials SET Quantity = " & NumResult & ", QTY_Allocated = " & NumVar & " WHERE Material_ID = " & Me.cboMaterial_ID CurrentDb.Execute strSQL, dbFailOnError Attempts to...