Search results

Ahh pretty simple -- thank you. This will work for most cases but what if I want to test if the form is in ADD (new record)/ Is there a way to test for ADD, ReadOnly, etc. SKK

I too think this is what I'm looking for. I would like to test if a form is opened in ADD or ReadOnly, then perform select operations accordingly -- something like: If form in EDIT then do this Else do that end if Thanks, SKK

No I think its coming when I attempt to click on a second control. I now set the code in the forms OnDirty. This way it at least updates correctly once the user selects some other control. For now, this should be fine. Thanks again, SKK

I tried that but I was quite sure where to place the code. I tried it on the OnClick property of my button but that bombed. I believe the problem here is my second form is updating data in my current table. I'm gong to try creating a second query. I may be back... Thanks, SKK

Hello, Is there a way to remove the focus from a command button after the button has been clicked? I have a Form-A with a Button-B that only becomes visible is certain conditions exist. Button-B opens a second Form-B for additional input (Form-A is still open). Once Form-B is closed, I want...

Thank you, SKK

Excellent - thank you very much Paul. I've got a few other issues right now but I'm really close. Just one other question. What is the code to test for null date? Like I said, I'm using >0 which is working, but I'm sure there's a more proper way to test for this. Thanks again, SKK

Is there a way to run code against only the current record? I would like to update a date field with the current date only if the field is null. CODE: If RequestDate > 0 Then GoTo GoodBye Else DoCmd.RunSQL "UPDATE tblRequests SET tblRequests.RequestDate = Date()"...

That did it -- I think I'm on to something. Thank you, SKK

Thanks - I like this. I tried all but still am having problems. One thing I did was create an append query using the existing data as a condition. It almost works. What I'm seeing is on my ADD form is in order for the query to update, I must first commit the record by advancing to the next...

I have a query (qryRequests) linking two tables (tblPermits and tblRequests) by the field called Permits_No, with all records from tblRequests and only match records from tblPermits. I have a form (frmPermits) with a command button that opens a second form (frmRequests) in ADD mode. The...

Ahhh, I like my belt and suspenders.... Better yet -- after testing, all I needed was the "locked". Thanks again, SKK

I have a form that opens with all but one field set as disabled (….enabled = false). This works fine for what I want, however, all fields are “grayed out”. I realize this is a function of each being disable, but was just wondering if there is a way to still display everything normal (i.e., not...

Most machines are dynamic but this being a server is static. No biggie here, I was just wondering why the UNC or more particularly the mapped drive letter didn't work. Thanks, SKK

This is in regards to one of my previous posts but this question is a bit more generic. We’ve noticed that when coding a mapped drive or UNC path, the routine fails. However, if we use the IP address it works fine (i.e., \\10.10.30.40\path vs. \\Main_Server\path). Any ideas why? SKK

We have a database creating and tracking work orders for sewer maintenance. Most all is working fine. However, I ran into one snag. Without going to much into detail with all the operations, one portion includes importing data from a couple external DB's stored on a remote network server. Our...

I believe I found my problem. However, this has created two new ones. Hopefully I can resolve this. Sorry, SKK

I have a form on a laptop that opens a second form that imports Work Order data from the server based on what was selected in the first form. All works fine except when I place a condition (CheckLinks) in the routine to check if the laptop is connected to the network. The CheckLinks function...

That may be a bit beyond my capabilities. Could you forward an example so I could play with it a bit? Thanks, SKK

I have a few DB’s that run an “update” query nightly. However, if someone forgets to close their connection, the update fails to run. I’m looking for a procedure or other routine that automatically closes all connections to a database. I’ve tried a couple I found (KickEmOut, LogOff2K) but...