Search results

Simplist example... I want to draw a line on a printed report exactly 7cm from the top of the page. Using Page Setup (File Menu) I see the top margin is set for 4.23mm. I set the line to be 6.577cm from the top of the report. It prints 7cm from the top of the page. Print the same...

Way off base! Am using a prestructured page that requires additional text in a specific place or it looks cheap and unprofessional. The text must line up no matter what the printer is... hence the question. Same principle though. Any ideas?

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

If SetTempVar was an important part of your macro why do you no longer use it in your procedure... or do you now use lngMyEmpID for the same purpose? Brett

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

Thanks David, I have this running already for all my controls however the user must be in the control to use it. Pressing F1 gives the same result. The problem is thought that it only works for active controls. The "What's This" button works on anything. Once I get it right, it will be on my...

After much searching I came up with a variant of a VB NET proceedure. Trouble is, it doesn't work as expected. I have a new module with the following code in it... Private Declare Function PostMessage Lib "user32" Alias "PostMessageA" _ (ByVal hWnd As Integer, _ ByVal wMsg As Integer, _...

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

Thanks for the info fdcusa however, as I said, I have removed the control boxes from all forms (have no borders at all actually) so need to do the equivalent of the basic form "What's This" button on a custom menu bar. Regards Brett

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

I have solved this issue now so if anyone is interested in my fix then let me know and I will forward you the info. Regards Brett

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

Thanks for the reply Pat. The names I used were purely for ease of reference here. The issue seems to be a part of how a list box uses its Control Source in that it cannot be controlled AND BE the control at the same time. I have now removed the Control Source altogether so the List box...

Dave, Like I suggested before, why not try adding a 0 to the old value and checking on that? if TabCtl0.OldValue + 0 <> 2 then do something This forces a nul to be something. Or is my logic to simplistic? Regards Brett

How about a simple calculation to test it... if TabCtl0.OldValue + 0 <> 2 then Hope this helps. Brett

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

After a little experimentation I have a very simple answer. in Report Properties... set Auto Center to Yes. set Auto Resize to No. set Pop Up to Yes. and in the line immediately following your DoCmd.OpenReport statement put... DoCmd.MoveSize , , width, height (I use 13300 and 11000 on an...

This is something that I played with a few years ago to process batch emails with attachments. There is a reference to attachments in it. Perhaps you can use some of it. Regards Brett

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