Search results for query: *

Hello, I need to query a database for records that fall between 23:00 and 06:00 and I used the following in the query field criteria box: Between #11:00:00 PM# And #6:00:00 AM# This returned records between 06:00 and 23:00. In other words I got the records that occurred during the day but I...

Hello, I have a question. How do I remove a category from a group that the value =0? I have a group footer that displays the values in a table (destination) then in a text box in the group footer I have a count function - =DCount("[Destination]","EMS Main","[Destination] ='" & [Destination] &...

Hello, I have searched through the messages here and have tried various things. What I need is the percentage of licenses expiring in 30 days from the total number of database records. I am able to get the total number of expiring (and expired) licenses by doing a query and setting the...

Hello, I am creating a logbook for work that replaces our hand written book. The clerk enters patients into this. My question is that I am using the main form to enter the patient information and I am trying to use a subform to show all the records entered. The subform does not work. It...

Help...I changed the default Service account permission for the RPC service from LocalSystem to a different account (an administrator account) and now the machine won't boot. It hangs on the preparing network connections screen. It will boot into safe mode but the properties window for the...

I can't seem to figure out how to correctly format the DDE commnads for Air Messenger and Access. Basically I want to take a variable (ie: address) and send it to the paramedics (ie: staff1 and staff2) pagers when they have a call by clicking a button. I know who to set up the command button...

Hello. I have set some textboxes up to hold times that can either be manually entered by clicking in the textbox and entering the time or the time can be automatically entered by clicking on a label next to the textbox. Both the form textbox and the table field are set to short time with input...

Hi all, is there a way to have access start at the last record, or optimally, a new record when opening a form? I set the DataEntry value to on but that only shows the records entered from then on and that won't work because sometimes previous records need to be edited.

Hi there, I have tried to follow the various techniques to do what I am trying but have not yet been successful. Let me tell you a little about what I am trying to do. We are a non-profit ambulance service and can't afford the fancy CAD systems for dispatch so I am trying to make a simple one...