Recent content by AthenaBS

Sounds good, but I'm quite new to Access, where do I enter this code? Under the Form properties, Textbox or Command Button. Then what event should I use? My Text box is called: Text0 Button is called: Command0

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.

So you're saying I don't need to bother with converting the Date/Time format. In which case how would I go about finding the % of people Not seen within 20 minutes of arrival between a specific date period. My Table has a column called "Slotdate", "arrived" and "in". Arrived & In are both...

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...