Search results

Hi, i have my form open in design view and it includes quite a few fields on a tab. But when i go to open it in form view, the form is just grey and nothing appears on it. Never seen this before, can anybody help?

Hello, I want to be able to double click on a record in a listbox (lstSubOrder) which uses (qrySubOrder), which in turn will open the orders form with the CustomerID, Title, FirstName and Lastname from the listbox copied into the corresponding fields on the orders form (tblOrders). I can do...

I want to enter a name in a text box and if it can't be found in the list box then it returns a message box saying that. I've tried this code but it doesn't work. Can anyone help? Private Sub txtLetters_AfterUpdate() If lstSubOrder = Null Then myOKBox ("The customer cannot be found") Else...

Problem with message box that stays after i've clicked yes I've got this yes/no message box that deletes an appointment. When i click yes to confirm delete, the box just stays there. I have to click yes again before it works. Clicking no works fine. Its like its going round the else if...

Hi, I'm trying to search for a last name, but if the name can't be found i want it to return a message box saying "There are no customers with that name". I've tried using an if statement but it seems to run past the code for the filter and just display the message box each time even if the...

I'm new to Access, i know this is probably basic, but i just need to select all the records with Start Dates since 14/06/04. Fields are; First Name Surname Start Date Can't i just put in criteria some sort of criteria under the Start Date field? I thought it was something simple like this...