Search results

I an hoping to get a similiar problem to this fixed. I'm trying to search records based on an afterupdate event on a text box. I need a msg box to open giving the user the choice to view this record or to return to the form to input a nre invoice. Can anyone halp please. Thanks

Hey Paul. Just to say thanks for helping me with that form earlier. I've just sent you a private message looking for more guidance. Thanks, Neil

Hey Sharkiness. I'm not very good at VBA code. The only fifference i can see between you code and the code that Paul sent me is: Your cose seems to be missing an amber sign & at line stLinkCriteria Try this stLinkCriteria = "[FI REF]= '" & Me![Reference] & "' AND Suffix = " &...

Can somebody please help me with some coding. I have designed a DB to hold all the invoices that my company recieves. What i want to do is: Have the user input a new invoice number into an unbound textbox. Have the DB search for any matching records. If matching records are found have a...

Thanks Paul. It worked great. Thanks for your help. I have a funny feeling that you'll see my name popping up here more often. Thanks again Neil

Sorry. My first day looking for help. I see about the names. I've changed the field names on the invoice Table to InvoiceMonth and InvoiceYear. I've also changed the form text boxes to criteriaMonth and criteriaYear. This is the code i have. Bear in mind this is just the code behind the...

The two fields are Month and Year so a text field and a numerical field. Using the access button wizard i can match up the year but not the month. Also tried using a combo box but not experienced in usng them. I want the user to type in the Month in one text box and the year in the next...

Can someone please give some advise on a problem i have. I have a form that is based on a table and i use this form to display search results. I need to open the search results form based on two data fields on my criteria form. I can open the form based on one of these fields but not the...

Thank you very much namliam. It worked perfectly. And thanks for the welcome:)

There is probably an easy and obvious answer to this but i can't work it out. I have an invoice Table that directly refers to an employee table twice. I.e. In the Invoive Table i know who opened the invoice and also who closed it. However this info is shown as emploee ID which is a no and i...