Search results

In the AfterUpdate event for the Start Date text box, try this... Me.txtStatus.Value = "Planned" Assuming the Status text box is named txtStatus.

Not a clue since I did not write the code but DBEngine(0)(0) works for me. Instead of using DAO, try running your sql like this... DBEngine(0)(0).QueryTimeout = 0 DoCmd.RunSQL "UPDATE myTable SET blah blah blah... ;" DBEngine(0)(0).QueryTimeout = 60

Clear the filter and/or turn off the filter. Me.Filter = "" Me.FilterOn = False

I had to Cdbl instead of Cint to get mine to work plus the Nz function. Nz(Cdbl(Closed]),0)/(Nz(Cdbl([Closed]),0)+Nz(Cdbl([Open]),0)+Nz(Cdbl([Retired]),0))

Unfortunately I do not have any control over the IP addresses they use for wireless and hardwired.

John, thanks for testing the code. Dang I wish there was a VBA solution to test if a user is connected wirelessly to a network.

Anybody have a chance to see if this code works to detect if your computer is connected wirelessly?

That is correct. I have a group of remote users who connect wirelessly to the network when they are out of the office. I know that some are still accessing the database wirelessly even though I have told them not to do it. I need to be able to identify if the user opens their front end...

Simon_MT, thanks for testing the code. Bummer that it is not working. I just found this bit of code that might do what I want. Could you test this and see if it returns True for you? I get False which should be correct since I am not connected wirelessly if this code really works. Private...

Anyone have a fail proof way to detect if a user has opened a database with a wireless connection? I found this code @ http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23102110.html but I am not able to test it since I do not have access to a wireless...

You can download the Access 2007 Runtime for free.

You can use the TransferSpreadsheet method if you want to automate the process.

How do your users edit a keyed Well Pad if they noticed they misspelled it or want to change it? Or delete it?

How are you defining the values for the sTo and sCC strings? In my sample code I posted I am hard coding them in the example. sTo = "johndoe@widgets.com; marysmith@widgets.com" sCC = "me@widgets.com" Please post your entire code for creating your email so we can try to spot the problem.

Then you want to delete the value of the field that had the focus before you clicked your delete [Clear] button. This should do it... Application.Screen.PreviousControl = ""

Hide or display the default ribbon... DoCmd.ShowToolbar "Ribbon", acToolbarYes DoCmd.ShowToolbar "Ribbon", acToolbarNo

If there are not a lot of fields on the form then perhaps my old duplicatecurrentrecord.zip sample I posted @ make a duplicate of a record will help.

Good luck! Hopefully somebody else can help you.

Not sure, I always avoid using references to specific versions of office apps. Use the code I pointed you to and you will not have to worry about what version of access your users have.

Check out the TransferSpreadsheet method to import your xls files into access tables.