Search results

Thanks for your response. Well it kinda works. I have been able to display the insertion point correctly, but is is very very intermitent. For some reason it doesn't seem to want to set the focus in the text box even though I'm clicking in it. I have tried setting the focus in the text box...

I would like to click in a text box and know the insertion point so I can insert a string at the insertion point. Any suggestions? Thanks for you help

Default values should work on the popup form if it is a new record. Your problem can happen if: 1) You create a new record in the subform and then open it in the popup. THe record in the popup is not a new record and the default values are not activated. However the field values should be...

I'd love to pass the password but I have not found anyway to get it. For obvious reasons MS Access won't let a programmer get access to the password. I think I'm stuck with SendKeys. We have used it for more than 10 years and until MS figures out how to replace it, I will use it.

The problem with creating a new application is that the new database requests the username and password again. Password is an option in the OpenCurrentDatabase method. Is there any way to pass the password?

Do you also have the line End Function at the end?

I have a button on the Menu. I want to click on the button and move to the Utility Database. This capability has been working for 10 years now with SendKeys but I have a new Client with MS Access 2002 and the SendKeys do not work. I assume I can load the necessary Reference Library to get...

Our Applications include 3 databases - User, Data, and Utility. The Utility Database is used for (1) Repairing and Compacting the User and Data Dbs, (2) Backing Up the User and Data DBs. (we have a pretty sophisticated backup routine that provides daily, weekly, or other backups, and (3) User...

You probably want to place the function in a Global Module if you need this in multple forms in your database. The name of the Global Module doesn't affect this but as a general rule, Modules are usually named something like bas_ . So you could name this bas_GlobalFunctions. Make sure the...

Thanks for your reply. I was hoping to hear from you. It looks like your the expert on this based on your previous responses. I have tried using the OpenCurrentDatabase method but I get an error message that a Database is already open. When I try to use the CloseCurrentDatabase first, the...

You can create a function to convert Empties to Zero. Here's the code Public Function EZ(pasValue as variant, pasOnEmpty as variant) as variant If IsEmpty(pasValue) Then EZ = pasOnEmpty Else EZ = pasValue End if End Function ---------------- Let me know if you have any questions or if...

I give up. In earlier versions of Access I used SendKeys "%FO" & strDatbasePathName &"~", False to move to another database. Now we all know that Sendkeys is now a No! No! and that Microsoft has created the RunCommand to replace it, but I cannot figure out how to move to another database...

When you say that the results are not correct, what are you expecting and what did you get? I assumed that the values of the variables were Null. Could you test this assumption by using the NZ function on one of the variables that is known not to exist. If it is not Null, it might be Empty...

In relational databases there is a difference between an empty field and a field with a value of 0. To resolve your problem use the NZ function. The function lets you replace the value of a field or variable if it is null with any value you want. I suggest you replace each field in your...

Try This Criteria = Criteria & "[Machine Name] ='" & Me.Combo18.ItemData(i) & "' Or "

Instead of using IIF, you might use the NZ function. It's simpler and more direct. Code is NZ(Fld1, "Exception") :D

Try this Criteria = Criteria & "[Machine Name]='" & Me.Combo18.ItemData(i) & "'" What do the error messages you are getting say? :D

vbCrLf is a VBA constant for Carriage Return Line Feed and should be available on your system. If not replace it with Chr$(13) & Chr$(10). These are the ASCII Codes for a Carriage Return Line Feed.

That sounds like it would work. However I would really like to know what the bogus Email addresses are so we can flag them and not send them more emails. Any thoughts?

The emails are being returned because the email address is not valid. Thanks for your suggestion. We do ask them to enter their emails twice on the web site. But my Client has several thousand existing emails. I need to be able to handle this problem. Web users will sometimes enter bogus...