Search results

I have a button on my form to open a report with some criteria (combo box, dates) I am trying to build a sql statement so the report will be filtered between two dates and having criteria of my combo box. I know the dates work but the Cost Centre Name does not. Here is what i have. Any help...

I am having a little trouble updating records on a form. When a field on my form has a certain criteria, i want to change values on other records. I am using code to open a recordset (the same recordset i am using in my form) and change records. Everything is fine until i leave the form or...

I have a field on a form that i use to store a string which contains values from a list box. I then reference this field from a query to get multiple parameters ( instr([form]![field Name], [Query Field Name]). It works fine, but when my field on the form contains a string over 120 characters...

I have a form with a subform. My subform contains many instances of the same field (many parts and information). I was wondering if their is a way to reference all instances of a field in a subform without making a query. Any Help would be greatly appreciated. Thanks

Does anyone have any code or modules to resize forms a networked database so forms can shrink/grow for different users. I am stuck on this one Thanks very much Ryan J

I have a combo box that is giving me errors. I would like to change data in the combo box when a user deletes the info in it or when a user backspaces deleting info in the combo box. I have tried using event procedures but it didnt help. The reason for doing this is because i am getting jet...

I have a purchase order form and when i change a value in a combo box fields change accordingly. My problem is that when i delete info in the combo box and exit it i get a jet database "you cannot assign a null value to a variable that is not a variant data type. I have tried to fix it with no...