Search results

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

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

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

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

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

G'day All, I was wondering whether there is a way to code using VBA to check the connection status of a network drive when opening an access db. Also if the network drive is not connected a way of opening a log in screen to connect to that network drive. cheers in advance