Recent content by msuguy71

Ok, that makes sense. How do I get it to read each individual day though? This is for a whole month. I already as them for a start and end date. How do I make it read each individual day between those days.

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

I don't have a problem sending out the database. I am open to all suggestions...I am still learning how to use advanced stuff in Access

I only have two boxes...one that reads the destination from a table and one that counts the number of incidents in the table (the DCount function). I do not have a separate box for each destination. Will the above still work? Thanks.

Ok, it worked if I put the code into the OnFormat event property for the desination group footer. The code removes all the destinations that had zero but there is an unanticipated problem. I did not realize that the fields are still there just not showing. The report now looks like this...

Yeah...that is what it is doing. :)

I have placed [Text7]>0 in the properites for the Report. Right click on the report title bar and use that properties. I get a parameter box that pops up that asks for an entry for Text7. This is the name of the textbox that contains the DCount command. This would make sense as my...

I don't know anything about SQL. Also, not sure if that would work. The problem is that the category names: Destination: Home 0 HGB 2 ERMC 1 BCHS 0 like Home and BCHS all come from a table and I have a lookup box list them. I then use the DCount function to match them up...

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

Ok, I tried your suggestion, and I keep getting a question box asking for CPRQuery!StuID. I am not sure why I keep getting this request as I have a this fieldname under the CPRQuery query. This is why I am getting a div by 0 error as I tried a textbox with =Count([CPRQuery!StuID]) and it is...

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

Ok, I found some more information on this problem and changed my code to the following: Private Sub Form_Click() Dim FormName As String, SyncCriteria As String Dim f As Form, rs As Recordset ' form name to be syncronized FormName = "Test" 'Define the...