Search results

Hi, I have got a form where I have to textboxes for receiving the date. When a butotn is pressed I want the query to run that has the following SQL SELECT [Batches].* FROM [Batches]WHERE (([ProdDate] BETWEEN #01/11/2013# AND #08/11/2013#)); But it returns no results and i know there are...

Hi, I am writing an access database that will receive data from an excel spreadsheet when the user hits a button. THis button may be hit more than once and therefore duplicate records would be entered. What I want to do is write macro that will run when the database is opened that will...

Hi, I have been writing a database which is near completion. I have a sample entry form. In this form a product code needs to be entered. I have a list of products in a table with descriptions. The samples are stored in a different table. What i want to do is when the user enters a product...

Hi, I have written a small databse to handle samples. I want to be able to report on the data in there by several different criteria. I would like a date range taken from 2 textboxes on a form and several values picked from comboboxes. If a combobox is left blank then all values from that are...

Hi, I have not done anythign in access before and have an idea of what i want but no clue in how to go about it. I have a single table of samples that is added to daily. I have another table of product codes in which a specific material for each product code makes that sample. for instance...

Hi, my name is Alan. I work within Fodd manufacturing in Andover, Hampshire, UK. Have done some visual basic .net programming but had to abandon course before final exam ;-( Have done various things with excel and have now started a project to introduce an access database to my work place...