Search results

I have a form with the following fields Customer House No Customer Post Code (A) Customer Post Code (B) and i want to open a form where the above fields match those same fields in my other form. But i'm not sure how to specify multiple fields in the stlinkcriteria Thanks in advance Geoff

I have 3 buttons on my form 1 shows all records,1 goes to the previous record, and 1 goes to the next record. There is about 200 lines of code behind each button as it works out should certain item be enabled or visible. The code is the same for each button. I want to know if there is a way of...

you need to create a field in the column with the following formula Month: Format([Date Joined or what evver you have called it],"mm/yy") this will now convert the date joined to just month and year and now you can group that column. Just repeat for date cancelled

i think you mean when you click a command button you want to open outlook express if that is co then create a command button and put the following code behind the event on click Call Shell("C:\Program Files\Outlook Express\msimn.exe", 1) that will open up outlook express

On my database a field is not enabled until you enter the data in the previous field this seems to work pretty well

I'm not sure if this is the best way but it's the way i'd do it. 1)Create an append query Where you are appending the Phone number from the CustomerInfo Table to the SoldInfo Table and in the criteria add the following [Forms]![CustomerInfo]![PhoneNumber] This will appended the phone number of...

I've got the following piece of code which selects an input mask based on the customer order type Select Case Me!CustomerOrderType Case 1 ' Set Order / Survey Number Input Mask based on Order Type Me!OrderSurveyNumber.InputMask = "E-0000000;0;_" Case 2 Me!OrderSurveyNumber.InputMask =...

firstly you want an On Click Event Procedure with the following code Me!CheckOut = Now

what i do is keep a blank copy of my database on a floppy. and back up the tables using the transfer text command which you can find in macros or vba, and back them up as csv files

Hi there, I have a Main form which has 10 subforms on tab controls, I want to speed up the database so that the subforms only load when you select the tab. thanks geoff