Search results

Hi I have created a form with one unbound textbox and a command button. How do I make sure that the query only runs if text is entered in the textbox? I do not want the command button to run unless the textbox has data to query. At the moment the Query runs and displays all records.

Hi I'm very new to Access, so please be gentle;) I have imported a appointment database that I need to analyse, however the Date & Time data within the table has been written as; Date: 20051220 - which I would like to read dd/mm/yyyy (20/12/2005) Time: 800 - which I would like to read as...

I apologise for my ignorance, but I’m very new to Access. I have a database of dates, that I need to analyse. I have created a Form called "DateRange" with 2 date fields; Text1 = Date From Text2 = Date to Command1 = Preview Report My Query has 2 fields; Slotdate = all the dates (show as...