Search results

fyi - This attachment is Access 2000. Thanks

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

In case anyone comes across this in future searches: Something like this: varNextIP = DLookup("[IP_04]", _ "tblNet", _ "[IP_01] = " & intIP1 _ & " And [IP_02] = " & intIP2 _ & " And [IP_03] = " & intIP3)

I figured it out.

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", _...

ONE LAST QUESTION dcx693 Your code actually inserts the new address in the table. If I just wanted to display the next IP address without inserting it into the table would I just change the INSERT statement to a SELECT statement? Would I also then need a WHERE clause? Do all the IP fields need...

Great! Thanks again, I truly appreciate the assistance!

I am pretty much a rookie with the VBA. Can someone help get me going with the code? I have the form to prompt the user for the subnet they wish to search and I have the entries in the variables. I used: varIP1, varIP2, varIP3 and then our workstations start at address 100 so I start varIP4 at...

Cool, good insight. I didn't think of that. Thanks again

Hey dcx693, Do I need to store the result of the first function in somekind of an array or tmp table? How would you handle that? Thanks again for helping the rookie!

Yes, the IP addresses are reused. Thanks

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

Thanks - that is along the lines I was thinking.

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

I finally got it working. Not sure about the error but it works now.

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

I just figured it out. I was missing the hidden text box with: ="Page " & [Page] & " of " & [Pages] Thanks

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

It just says the save action was cancelled. I do have a bit field. It is on my form as a check box and it is not enabled. I flag it when the "receipt" is printed. So you are thinking I don't have it initialized? Do you think I need to set the variable to false just after I declare it? Here is...