Recent content by Firemansam

Hi, I'm trying to use a form items to search across multiple fields in a table. I have setup my form with all the items I want to search on and made them unbound. Then adjusted my query to look for the information in the particular text box on the form. like so; [Forms]![Search]![Like "*"...

G'day Paul, I have just checked the table that this query references and there is some null values. Is there a way of writing the SQL statement to exclude these? Cheers Andrew

I have attached a screen shot of the table design, I have higlights the field that I am working on. It definitely show as a Date/Time field. I can't work out why it is coming up with this error. http://s291.photobucket.com/albums/ll313/FiremanSam1/Access%20Screen%20Shots/ Cheers Andrew

I have added the closing # now I'm getting an error saying "Data type mismatch in criteria expression." Any ideas? Cheers for all your help Andrew

Cheers for the reply pbaldy, but I am still getting an error this is what I have as the SQL query what am I doing wrong. SELECT ICU_Daily_statistics.[Patient ID], ICU_Daily_statistics.[Admission Datetime, ICU DateTime] FROM ICU_Daily_statistics WHERE TimeValue([Admission Datetime, ICU...

Hi, I have a table that shows when a Patient was admitted using a time and date field, what I am trying to do is create a query that will show me how many patients were admitted over a 12 month period between the hours of 10am and 11am. I have tried the between syntax ie Between #10/01/2010...

Thanks heaps for your help!!! It worked like a charm.

G'day All, I'm trying to fumble my way thru this.... I have managed to get VBA to creat a foler with todays date in aserial number type format as the folder name using this code.... Public Function CreateFolder() Set CF = CreateObject("Scripting.FileSystemObject") Set a =...

Slightly new to using VBA, so do I need to put and End if before I do and Else?

G'day All, I was wondering whether some could help me get this to work. Iam basically trying to get a message only when the "M" drive is connected. It keeps coming up telling me "Block If without End If" that way I see it I have and End If statement after every If statement. Any help would be...

oh well, Thanx anyway Missinglinq

G'day, I was wondering whether anyone could tell me how to make the form move up and down when using the scroll wheel on a mouse. When I use the wheel on the mouse now it scroll thru all the record entries. This is causing hassles for the users as they may accidentally enter the right info...

G'day All, I have a table that allows for data to be automatically imported into it or manually entered. When data is automatically entered into the table the number field shows the number as a decimal, but when I manually entered data into the column it rounds it up or down to the nearest...

Thanks Doc Man that has given me the info that I needed

G'day Jackson, When I checked the filename for the exe file for Adobe 7.0 it shows as being acrord32.exe not sure whether this is your problem or not.... Just a thought. Regards