Search results

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

Thanks Bob, Those links talk more about the Inno side of the setup, what I am interested in is the Package Wizard side and the steps needed to create the runtime. On that thread, would it be too difficult to use Orca to modify the Package Wizard installer and add the necessary help file...

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 found an error in the last routine I gave to fix the backend password issue. This one works correctly. Function Reconnect() On Error GoTo ReconError Dim db As DAO.Database, Source As String, pathNew As String, pathOld As String Dim SourceName As String, i As Integer, j As Integer, k As...

That suggests that you have either copied the application into another directory and not relinked the back end to the front end or the author neglected to impliment a reconnection routine. Try relinking yourself using the Tools/Database Utilities/Linked Table Manager. Regards Brett

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

At what point in running the app are you getting this error? Brett

Thanks for that. Like I said however, I am using the PostMessage function to emulate the "What's This" button and it is working perfectly. In such, the following code is called from a toolbar and the cursor changes to an arrowed question. You then click on an object in the current form and...

I am using the PostMessage API function to display my help page. This acts independantly to Access and as such nothing I do to try and obtain the help page's hwnd seems to work. I have tried GetActiveWindow etc however in every case it effects the calling Access window and not the help window...

If both FrontEnd and BackEnd are in the same directory then this will work for you. If not then you will need to supply your own value for "PathNew". The DEBUG.PRINT lines are there simply to show what is happening. If you wish to use them, remove the comments and run the code from within your...

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

Found my problem... and the solution. Microsofts design for the HTML Help VBA routines all use screen.activeform however this does not access subforms. I now use screen.activecontrol and all works well. Case closed. Regards Brett

Thanks Jal, it worked for me too. Regards Brett ps. Your aura has been enhanced for your effort.

I am using 2003. You are right - that fix made no difference.

Hi Jal, Just checked out that MS article. Designed to create custom page sizes. No mention of margin adjustments. I am using plain old A4 size anyway. Nice call though. Thanks for the input. Regards Brett

We seem to be deviating from the thread a little here. The problem as I see it is that whilst the top margin is being changed, it is not actually being saved using the DoCmd.Close. acSaveYes User intervention (by accessing Page Setup) does show it has been changed and will allow it to be...

...just how many makes, models and variants do you think there are Rich?

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 to dynamically resize the margin however it is supposed to stick - not revert. If I don't run the DoCmd.Close and save the report without opening the File/PageSetup to view the margins it does not save either. It only saves if I view the settings. This is not what I want to...

I have come up with a solution... that doesn't work (yet)!!! Here is a Subroutine. Public Sub SetMargins(strRptName As String) DoCmd.OpenReport strRptName, acDesign With Reports(strRptName).Printer .TopMargin = 1134 .Copies = 1 End With DoCmd.Close acReport...