Search results

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

after a small amoutn of fiddling whilst adding the format statement it included an extra set of #. i have removed these and saved and re opened and tested and this worked great. it returns only values between the 2 dates selected. Thanks for all your help guys. Thats perfect. woudl have taken...

just looking at evanark's code and i think it would be somethign like If Me.dateFrom <> "" Then strwhere = strwhere & "([SampleDate] BETWEEN #" & format(Me.dateFrom.Value, conjetdate) & "# AND #" & format(Me.dateTo.Value, conhetdate) & "#) AND " will try and test this now as putting it in a...

i will try, just not sure where to put the format statement. I have put the const conjetdate =.... in after the declaration of the variables. the line for building the string with the dates is If Me.dateFrom <> "" Then strwhere = strwhere & "([SampleDate] BETWEEN #" & Me.dateFrom.Value & "#...

thats cool. thank you for replying to me. I have the code that sorts all the relevant data i need. the only issue i have now is the dates. the date format in the data base is dd/mm/yyyy. i have got code that will sort the dates fine. but when its read by the query it reads it as mm/dd/yyyy...

starting to tear my hair out now. I have set the comboboxes to choose the distinct values of the date. when converting it to SQL it swaps the date and month around. If i manually enter the date in the format mm/dd/yyyy it runs everything fine. I just cant get it to run correctly in the format...

in using distinct list of dates would you then revert to formating the data type as text and use the input data as a string as opposed to the octothorpe date method? Regards, Alan

i have changed the date field to SampleDate and made all the adjustments across all forms and code as necessary. I still get the same problem. The date format of the laptop is correct as i have checked date format in the bottom corner ( work laptop so dont have admin rights to even adjust my...

thats a great help thank you. I have got the following string now from the following code however it returns results that do not match If Me.dateFrom <> "" Then strwhere = strwhere & "([date] BETWEEN #" & Me.dateFrom.Value & "# AND #" & Me.dateTo.Value & "#) AND " is the code SELECT [QC...

Hi, I have the reporting side of things working with null values and returning the report for 10 criteria. i just need to add a date range. I have 2 textboxes, with date selectors. one is datefrom and the other is dateto. THe default value for dateto is date() to give todays date. I...

Hi, Thanks so much for that. I think i understand how you have gone about building the string with the if statements and such and makes a bit more sense than the other one i was trying to do. I never thought of adding a query to it either. I will be trying the same thing for my database today...

the date thing i was going to handle with a between parameter on the report. so there are 2 textboxes which are the date controls one being datefrom the other being dateto. The parameter would be between Forms!frmFilter.datefrom AND Forms!frmFilter.dateto i thought this should do what i want...

would it help if i attach my database?

Thanks for replying. I got the code from a microsoft site that explains the whole process. I also downloaded a sample database in which someone had used the same code. Theirs works but when i use it in my own it has this box. the set filter subroutine that builds the SQL string is Private...

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