Search results

Thank you that works. Believe me, I hate to say this, but I am doing quite a bit of research and due diligence but I still come short. You have literally saved me days in trial and error, I am grateful. If you could look at one more thing: Below is a statement in Blue and Orange. I am...

OK Thank you, the line in red will give me "run time error 3061 : Too few parameters, Expected:1". If I mix letters and numbers. Also just to clarify: I have Three tables and I completely understand if you want to skip this stuff and “cut to the chase”, but I figure that the more is...

Thank you very much! It is all working (barely). I can not mix numbers and letters in the serial number and write it, I get a runtime error. Would be willing to look at this code below and see if it makes good sense to you. If not I totally understand I am simply trying to get this part...

Thank you IsNull() is the answer.

Column (3) is a yes/no lookup. Obviously I am wrong, but I am trying to test if the box is checked . ItemsSelected is probably the answer to retrieve data from selected rows in a list box but I am not quite sure how to test for a checked box.

Would anyone be willing to help me debug my syntax? The below code statement test to see if an item has been marked "yes", Then checks the serial number is blank. If the serial number is blank will prompt for a number and write it to the record. I am getting a compile error and am sure it...

Switch Board "add new materials" not updating records Will someone please help me figure this out? Using the SB, I open a form in "add new items" criteria, Keep in mind, the form calls a VBA module. Upon returning form the module and completing the form, the SB or form does not record and...

Thank you found it.

Can someone tell me what happened to the Switch board in 2010. Has it been replaced by another feature? Thank you, Dale

Wow, Thank you, two days of trial and error, you saved me a third. Amazing how far this program can go.

Thank you, below is the row source: SELECT [materials].[Material_ID], [materials].[Material_name], [materials].[Quantity] FROM materials ORDER BY [Material_name];

Will anyone help with a explanation on how I can set up a expression to filter data in a combo Box? I have a form "frmallocation" which has a combo box used to display data from a table of materials. I do not want to display records in the list if one of the fields "quantity" is equal to...

Hello all, I am a newbie trying to setup a DB using Access 2010. Not a complete dummy when it comes to VBA but certianly not a geniuss. Thank all of you in advance for any support you may give me. Dale