Search results

I have a database, which I use the code below to hide all the standard menu's and command bars etc Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i This...

Suppresing blank lines Goozer Your code sounds along the line of what i need also, same problems as this thread, below is my SQL query which extracts the appropriate address and contact. I found this in a sample database I downloaded for handling multiple labels, and allowing you to set the...

I have written a procedure in my database(access97) which enables me to select specific contacts and produce a mailing label. Placing the label anywhere I require on a sheet, allowing for used label fields. This works find. The label document is a report, what I need to do is emulate the...

Installer Links as promised Inno Setup - , download the QuickPack, comes with compiler and a handy app called IssTools www.jrsoftware.org RunTime Tester App (access97) - Installs the runtime files and a tester app http://www.openaccess.co.za/BlackAndWhiteInc/Runtime.htm Script for the above...

Installer Have been playing around which must the same idea's. I have found InnoSet from Jordan Russel Software, best thing its free! You can download the Install file compiler on its own, but you can also download a quick start pack which contains a third party program called ISSTest, handy...

I have a an access97 database, with two toolbar forms. In order to ensure the toolbar forms stay in the correct place, even when the main form is moved, I have used a timer event on each which checks the toolbar positions against the main form every 1second. Everythin works ok, unless I move to...

I stumbled across some Micrsoft code which is able determine a selected Forms position on screen, works with Access97. I have tried the code and everything works ok, except the position it reposts back is not the same as the position i set of for the form, eg if I set the form left and top...

Hi Not sure if this has been covered elsewhere, I have a functuion which generates a query to filter a table down to a specific record. Works fine. However when I test the code in the debug window, including the two arguements to the function I get a message saying "Compile Error, Expected...

Hi Thanks for the response, struggling with something else at the moment, but will try this out. Thanx

Email Essentially I have the following structure in the database 1) main form - holds company name etc 2) subform for each site address for each company 3) subform on 2) for each contact name at that site. subform 3) is displayed as a continuous form, and holds a field called "EmailAddress"...

Automatic Emailing from Access to Outlook I too have used this code with success. However I am now trying to allow for the addition of using the CC and BCC fields. I understand the syntax for creating the objects for both of these fields, and can run the code successfully. However I cannot...