Search results

Hi All, How can I write this in a query - Criteria : LIKE [Enter Date ?] = BETWEEN [Date_In] AND [Date_Out] Please note that Date_In and Date_Out are fields and I want the query to ask me a date and then if it is within both in and out it will give me the record. I tried this sentence but...

Hi All and thanks in advance for the help. I created a database with the following fields : PatientName which is a text DateIn which is a date DateOut which is also a date If the patient was in on 01/01/2012 and he was out on 10/01/2012 In the format (DD/MM/YYYY) it is so easy to get the...

Hi there, I made a Dlookup textbox to get a value from a table which is my main price list but need upon filling my form which holds a field called "UnitPrice" to store the value in that field but it does not as it is unbound. Is there away to go around this ? If there is an example it will...

Hi everybody. Please please please help. I have a Dlookup statement on an unbound textbox and I need to pass the value to a bound textbox. I have read few replies on the net but seems not to be understanding how to do it. Is there a live example someone can show me or assist me on this ...

Hi there, Is there a way assign a value to a command button and when I click this command button it automatically adds this value to a list on the same page like a combo box or a list box ? Thanks a mill.

Hi there, I am trying to make a restaurant system. my problem is that I want to make buttons like command buttons with sandwich names for example and when I click one it automatically adds its value like "Steak" to a list box or to a list in the same form where I can add another and another...

Hi all, I created an invoicing system on Access and when I need to print I will need to key-in the invoice number. How can I print multiple invoice numbers like do I put a comma in between or what ?. Thanks.

Hi there and thanks for helping. I have a man form and a subform that are connected. Now what I need to do when I am on the main form is to add a combo box or or a list box where If I select a value or a text from that box or double click on it it can be copied to the sub form. I created a...