Search results

The only event that works is the "On Mouse Up". Ok... problem solved but I would still like to know what is different with "On Mouse Up" and the "On Click" events as far as a Combo Box goes... especially seeing a text box uses "On Click" to achieve the same result. Any ideas?

I agree Dave however sometimes it is nice to simply stop the user from entering the wrong data type in the first place. That way no error message pops up at all so a more professional looking presentation. REgards Brett

I gather you fixed your own dilemma... Just a thought, why not trap and stop any other keys at the time of input? Use a Function such as... Function OnlyNumKeys(KeyAscii As Integer) As Integer Select Case KeyAscii Case 8, 46, 48 To 57 'allow backspace, period, and numbers Case 13 'do sommit...

Thanks for the suggestion John. I delved deeper and found that Microsoft state that SelStart & SelLength work on the .Text portion of a Combo Box. Same problem though. Here is the modified code. The Pause (2) is simply a 2 second wait that I have created. The whole field is selected for 2...

As far as I am aware, the following code should select the entire field of a Combo Box when used in the On Got Focus event. Me.Controls(Screen.ActiveControl.Name).SelStart = 0 Me.Controls(Screen.ActiveControl.Name).SelLength = Len(Me.Controls(Screen.ActiveControl.Name)) If the code...

What is the simplest way to compare two external databases that hold table data only? Any suggestions would be appreciated. Regards Brett

Thanks Guus, The penny dropped earlier today for that after reading up about it on the Microsoft Technet site. Then decided to cut out 95 percent of my code by simply copying the back end to another file. Hey presto... instant backup. Makes the whole exercise take about 5 seconds instead of...

More feedback guys... Just discovered that the code does seem to work but the problem is accessing the back end to do my table exports with the original backup routine. In a linked DB DoCmd.TransferDatabase acExport, "Microsoft Access", BackupFileName, acTable, TableName, TableName...

I need a quick refresher here... How does one change the current active database? ie. I want to work directly with the back end and not the links in the front end. Do I use Set objAccess = DBEngine.Workspaces(0).OpenDatabase(LinkedDBName, False, False) etc? Does this set the VBA working...

The front end is an MDE but the back end is an MDB. Guus2005, the code does not produce any errors, it simply does not do anything. No transfer of data takes place. One thought I had was to write directly to the back end (instead of via the system link). Still... this seems to be the long...

I use KeyedAccess from Peters Software. It is inexpensive and works beautifully. It even allows for maintenance renewal charges if you want them. http://www.peterssoftware.com/ka.htm Regards Brett

I have some code that works beautifully on a split Access database when run in the original MDB format. When the front end is converted into an MDE the code no longer functions correctly. Has anyone had any experience with this phenomenon before? The code I am using is...

Just found this old thread. Have you got a solution yet? If not then try removing the password first, then do your transfers, then recreate the password. Set dbsNew = DBEngine.OpenDatabase("c:\myfolder\Test.mdb", True, False, ";pwd=yourpassword") dbsNew.NewPassword "yourpassword", ""...

Kelly, My suggestion was not meant to be a literal copy - only a suggestion, and it still stands. If, as you say, you are happy with the way your code works but just want to do away with the system error then... Private Sub delete_Click() On Error GoTo Err_delete_Click ' test for...

Re: Creating External Backup - but getting RunTime Error 429 FOUND IT! It turns out that the Access 2003 Runtime does not allow the use of the CreateObject, the OpenCurrentDatabase, and NewCurrentDatabase functions... even though all the help documentation tells you to use them. I was using...

Creating External Backup - but getting RunTime Error 429 Just discovered that a backup file is actually created but it has no fields in it so it doesn't appear to be the actual "CreateDatabase" command that is causing the issue. Can anyone suggest what else will give that "Error 429" on a...

This might be simplistic but... Private Sub delete_Click() On Error GoTo Err_delete_Click ' test yourself to see if it is associated with a user If test = no Then DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, ...

acViewNormal is already telling the report to print. Isn't PrintOut used after acViewPreview? Allen Brown has a neat printer selection utility at http://www.allenbrowne.com/AppPrintMgt.html Regards Brett

Creating External Backup - but getting RunTime Error 429 I have an issue with creating an external backup file on a machine that has never had a full version of Access installed on it. My app installs a copy of 2003 Runtime and everything works true to plan... except for this backup routine...

The password is pulled from the old connection strings. This routine is not designed to change the password, only to reconnect. As described in my first reply, try uncommenting some of the lines and run the code and see what I mean. Debug.Print "Old Master Connect = " & Source will give the...