Recent content by james_IT

thank you both for your responses. I will try runtime on their PC's - looks like it might do the trick. Might have to do some more error checking! cheers

Hi - I have MS Access on my PC however wish to move the accdb file to a network location to allow other network users to have access to it. Unfortunately a few of the other users do not have MS Access. Is it possible for them to still open the database without any admin or background - I would...

once again...you sir are THE MAN. thank you and have a nice weekend

thanks - trying Between ([Forms]![FilteringForm]![txtStartDate]) And ([Forms]![FilteringForm]![txtEndDate]) Or Between DMin("BookingDate","Bookings") And DMax("bookingdate","bookings") but i've gone wrong...?

hiya - just input some more test data. If date fields are left blank, it only displays records up to today's date?? I.e. it doesn't show ALL records, past and future?

thanks very much - the db will not include historic data - only data from go-live onwards so i dont think ill have an issue. thanks anyway

you're a star!! Thank you so much

Hi - i have a query with the following code which searches the 'BookingDate' field for records between two dates: Between [Forms]![FilteringForm]![txtStartDate] And [Forms]![FilteringForm]![txtEndDate] this works fine however if the user doesnt put any dates in either box how can i return all...

can anyone help? im at a dead end - tried a few things to no avail

please see attached example db. really would appreciate any guidance. thanks

thanks for the response. i've had a look but still struggling... :confused:

My subform filters fine with combo boxes. One of the fields in the subform is a date which I would like to be able to filter from a txtStartDate and txtEndDate. I'm using the following code but I cant get it working (getting an error code 3075) Public Sub SetFilter() On Error GoTo...

Hi, I have a listbox which is filtered by combo boxes which works fine - the list box filters when the content of the combo boxes exactly matches data in a column of the list box. I use the following code to filter the listbox: If Not IsNull(Me.ArtworkSource) Then strFilter = strFilter &...

ok figured it out. just took of reading pane and restarted outlook and turned reading pane back on and now its working again! weird. thanks for your help anyway

ye looked at those settings and cant see anything wrong. any other ideas? it happens when i switch between folders. normally it highlights the top message but it just greys out now...