Search results

Hi, I have been using the GetSystemMetrics API successfully for some time to force the window dimensioning of an application in XP. Now a user is attempting to use the app on a Vista system and it appears that the API is not reading the metrics correctly. Consequently those rotten scroll bars...

Can anyone inform me of a way to action a subroutine AFTER the ESC key has been pressed and the Undo has been actioned? I do not mean a call from the "On Undo" event as this happens prior to the actual Undo action. I have a number of calculations that happen after a field value changes and...

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

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

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

I have a problem launching Access Runtime using Inno scripting. The command... msiexec /i c:\progra~1\dtpvouchers\accessrt.msi /qb Works beautifully when launched via the system run command. When I put the same command into Inno (run on install) it complains that it cannot find the msi...

Hi guys, I am attempting to use the 2003 Package Wizard however I need to have help file shortcuts created and this is something the Package Wizard in not capable of doing. It has been suggested that I use Inno in conjunction with the Package Wizard and that I use the Package wizard to build...

I am playing around with SendMessage. Using the following I can access and run my Help Routines by sending the current hwnd to the function WhatsThisMode(). The cursor changes to a question mark and waits for me to click on a form object. If it has a Help Context ID then it pops up a specific...

If you have split your Access application into a FrontEnd and a BackEnd and then decide to move the application to different folder, all your links will fail. This code will reconnect all the links automatically. It also handles passwords correctly. Note that it is assumed that the FrontEnd...

I have a custom help file which works beautifully from anywhere on my main form however any links to the help file from a subform stop at the home page of the help file. All the necessary Help Context IDs are set correctly - in fact the form calls the correct help pages if run as a stand alone...

I am wanting a way to always get data printed in the right place - say starting exactly 10cm down from the top of the page. I have set up a page on a canon inkjet printer which has a specific non-printable header and I can calculate exactly where to put a line on the page for that printer...

I am using a shortcut menu bar action which appears with a right click (which is working really well). The issue I am having though is how to stop any other action from happening at the same time when a user right clicks. For example, a tabbed control will change tabs on a right click. A...

Hi all, Does anyone know of a way to set the size of the response window targeted by the PostMessage API? ...or better still, route the page it comes up with (in my case a page from my help.chm file) into the HTMLHelp program itself? In other words, I have managed to replicate the "What's...

I nearly have all my ducks in a row with a project I have been working on. Now down to the final dash and have completed all the necessary help files. All I need now is a way to simulate the "what's this" button on a form. My problem is that I am using a form with no border so the standard...

Has anyone done anything with duplicating the "What's This" button by using a call to USER32.DLL? I want to put this on a custom menu bar as I have removed the control boxes from all the forms in my application. I have been playing with it all day and so far nothing works. Any suggestions...

Has anyone played around with setting the height of the active Access application window and taking the height of the Active Title Bar into consideration? I have found that when I set up an application window size using the SetWindowPos function that everything looks great so long as the user...

Hi again guys, I have a simple form linked to a table. The table has 3 fields - ID, Name, Value. The form has two Text Boxes - one for Name and one for Value. It also has a List Box which has 3 columns - Name, Value and ID, bound to column 1. I have set up the List Box using the "Find a record...

I would appreciate any suggestions how to set explicit window position and size for a report preview in the way you can for a form? Regards Brett

I have a little backup utility that works perfectly if run all by itself however when called from within the main program it errors during the restore proceedure. At that time it is trying to delete the existing tables and that is where the error occurs. error 3211. The database engine could...