Search results

Hello All, I have a form (frmSearch) with one textbox on it from which I would like to do a search with that one criteria. I have a FIND button from which I would click and it would Search for the above criteria. In the OnClick event of the button I am trying to use DoCmd RunSQL. I have set...

So how would the query be set up? I am just being to use Access and am having a hard time uderstanding some of the finer details of it. Thanks

I have a form to keep up with the remaining balance of a purchase order. The PO has a beginning balance of say $25,000. I receive invoices for this PO and I want to subtract the amount of the invoice from the balance of the PO. The first invoice amount I enter will be subtracted from the...

Rich, I figured it out.:D I've got it doing what I want. Guess I asked to soon. Brain Freeze!!!! Thanks again, Securityman

changing label Thanks Rich, I have been trying to use .Caption property but don't know the syntax. I am new to all this. This is what I have, but don't know where to put it. In a sub routine: Dim c as String c="Selected Employee" Forms!InputF.Label35.Caption=c Is this...

I have a form (InputF) where I input employee information. I have a button on this form that gives me a countinuous form (EmployeeF) of all the employees. I have a button on this form that will give me the signle record of a selected employee. When you click this button the single record is...