Search results

I have a report with costs that I want to round up to the nearest .25. I have tried the round function but it will only round to the nearest .25 (rounds down if closer, I don't want that). This will round to the nearest quarter but not always round up. =0.25*Round([num]/0.25,0) I have...

I have two forms in my database. One for equipment and one for the network information. I want to open the frmIP from the frmEquip and be on the coresponding record by matching the NIC Mac address field. Currently, I can do it but it is done by a filter...I don't want a filter...I just want to...

I have a table with Patient names. If the patient is deceased, they put *** after their name. Not sure who the bonehead that thought of that is. Anyway, I want to create a list of those for deletion. I'm having trouble with my query. Three columns: Patient Number, Last Name, First Name Example...

I am trying to do a search in a subform. I am trying to use the Recordset clone method. I have a text box on my subform (txtSearch) and the ProcNumber is the field on the subform that I want to match. I get a type mismatch on the line where I try to set rs=Me.RecordsetClone. Any ideas why...

I have a quick and dirty database (attached) for tracking cath lab procedures. I had to import from an existing spreadsheet so that is why some of the fields aren't as disireable as I would like. Anyway, I need to be able to search by procedure number which is on the subform. The link is...

I need a DLookup with multiple criteria. When I do the IP_01 criteria by itself, it works fine. When I try to add another criteria (IP_02), I get a type mismatch error. Can someone spot the syntax error of my code? TIA code: varNextIP = DLookup("[IP_04]", _ "tblNet", _...

Looking for some assistance to steer me in the right direction. I have an equipment form with the IP address on it. We use static IP's (don't ask). I need to place a button on the form attached to some code to find the next available IP address. We have numerous subnet's. I want to prompt...

I am a network administrator at a Hospital. An EMS guy created a database to track all the Ambulance calls. He made it a multi-user database. The database resides on my network with all the users having the same permissions (Windows 2000 server and workstations). When one specific user is in...

I have created a help desk database. Access 2000 front end and SQL 2000 backend. It has been suggested to me to make the memo field read-only to everyone except the author of the text. I do record the username when the entry is made. Anyone have a suggestion on how to do that? I want the...

Access 2000 When I try to add a subform to a form, I get an error saying: Your Code contains a syntax error, or a MS Access function you need isn't available. I created a new form with no code behind it, still get the error. I wasn't able to locate this on the Knowledge base. I can do this in...

Access 2000. I want to number my pages per group. Like for each site to say 1 of 3 pages instead of the whole report showing 1 of 17 pages. I have searched all the posts on numberering pages per group. I got the code but it is not working for me. My report does the page breaks for the...

rookie needs advice I have recently created an access front end and sql backend help desk app (multi-user environment) for my company. It seems to be working great, except: When you open the app it opens to a new record (requested feature). The app doesn't save until they have completed...

I am creating a help desk database. I am creating a report to pull the tech's work he did within a date range. The user runs the report and I prompt them for the tech's name and a date range with a form. I have 3 global variables - Gl_Tech (string), Gl_BeginDate (date), Gl_EndDate (date). I have...