Search results

Well I'll be..... You were spot on, as I thought you would be, when I used the format you suggested it worked fine. Microsoft :mad:, it works with the UK format with one date but requires the US format when using two dates with an AND ??? Well I've learnt something new, thanks

So even though the date format in the table and the report is english format I need to set it to US format in the query? I've used dates many times and never had to do that, I not saying you are wrong but if that was the case surely it wouldn't work with one date in the WHERE statement!

Thanks for all your help, I've made a work around to get it working. The problem seems to be that the WHERE doesn't like multiple dates, it works fine with one date but not two with an AND statement. I placed two text boxes on the form and populated these with the start and end dates on form...

Thanks very much for the help, I'll give it a try but the date format from the WHERE statement matches that of the report and it works if I use only one date. Cheers

[dates] >=#28/06/2010# AND [dates] <=#02/07/2010#

Yes I admit I'm doing it a step at a time, I will make it smoother later. getting the date values seems to work OK, I can see this by stepping through the code both start and end date are correct, the problem is the WHERE statement, it doesn't work when I AND both together but works OK if I use...

Yes, Is "dates" not OK?

Hi, This has been driving me mad all day, I have a form with a listbox, the listbox contains a list of records from one date to another date. I have some code in the click event of a button to open a report and pass the start date (row 1 in listbox) and the end date (last row in listbox) to the...

Thanks for taking the time to reply, sometime early this morning I came across a post that suggested using a global variable setup in a module and pass the name of the query to be used as the recordsource for the form and, on opening of the form, set the recordsource using said variable. It...

Hi, I have a database with several nearly identical tables and several identical forms, each form linked to a table via a qry to limit the recordset. I call up each form from a front end form using a seperate button, I would like to use one common form to display the relevant table data from...

Thanks boblarson, Using the date function worked in the end, I'd tried it before without any luck but eventually I found a control on the form called 'date' so this screwed up the Date() function. That's what happens when you try to modify someone elses work. Sorted!

Hi, I'm looking at modifying an existing database with a form that when opened finds the first record with todays date (or should do). Dim rs As Object Set rs = Me.Recordset.Clone rs.MoveLast rs.MoveFirst rs.FindFirst "[dates] >= CDate('" & Now & "')" The problem is that it always shows...

I had the oncurrent event set but then I couldn't close the main form because it kept loading the picture but I tried it again this morning with the oncurrent event of the subform and it seems to work even though when I click the close button on the main form it seems to trigger the image update...

Thanks for the reply, I had a look at the thread. Sorry I was not clear in the first post but my form is a single main form with a single subform, the subform (not continuous) has navigation buttons at the bottom, sometimes when you click next it will change to the next picture but then it will...

Hi, I used some code from the MS website to enable display of images on a form based on the path stored in a text field, all worked OK until I tried to be clever and use a subform to display multiple images linked by EventID. The problem is that, even though the record ID in the subform shows...

In the query place the reference to the control on your form, like this forms!frm_your_form!combo18 Then when you call the query it will use the data from the controls on the form as the criteria for the query. I don't know about the dropdown box though....

Just use the function to return the user ID, see code. Me.Text46 = fOSUserName()

Try this link, it worked great for me. http://www.mvps.org/access/api/api0008.htm

DUH! You have hit the nail on the head, my problem was I forgot that even thought my list box can only ever have one record it will still need to be selected before I can get access to the ID value. I will stick with the workaround as I have 8 single row multi column list boxes to display the...

Rainman89 Thanks for the reply. No I haven't but there isn't anything selected at the time I click the button so I don't think it will work. I think my problem is something to do with referencing the ID value from the listbox, it work if I reference a value in a textbox but not from the list...