Search results

I have been using the attached code within an Access 97 database to count different types of tables within the application. On calling the function a variable is passed telling the code what table type to count, i.e. ADD for Address Tables, CON for contacts tables. It has always worked find in...

I have a contacts database whic I created and use at work. The database file resides in a folder on the company network. The file was created using Access97. I have incorporated Stephen Lebans module for changing the MDI client Background. I have imported all the necessary parts. I have made a...

I have a HP Pavillion Laptop runing Vista Home Premium, with SP1. Generally contrary to opinion I have experienced very few issues with the OS. However I have one issue which I cannot seem to resovle. It centres around 4 Important & 1 recommended updates from Microsoft: KB950582 KB951978...

As part of my database i have a number of references set up, "Microsoft Access 8.0 Object Library" etc. Are these references held within the mdb files, such that if I open it on another machine the references are still there, or are they lost? If the answer is the latter, how can I...

I have a process which requires a report is exported to an RTF document, how can I suppress the message saying the report is being exported? Thanks

I have a contacts database I have constructed for my employer. As part of this i have designed and integrated a facility for producing a mailing label, incorporating the facility to place the label any where on the sheet (see attached picture). This all works fine. Essentially the process...

I have a desktop machine running Windows XP Professional, and a Freecom external usb hardrive attached to it. When i create a shared file on the internal drive of the XP machine I can access it with no problems from my HP Vista laptop via a wireless network. However if a create a shared...

I need to be able to simulate the blanking and un-blanking of a text box. The action is executed from another form. I have tried changing the font colour by code, but I get an error that tels me this is not possible. Also tried placing a blank over the text box, but text box comes to the...

I am looking for a way to activate the record next, record previous, record first and record last on a form. However the activation is based on a control on one form, the record next etc is on another form. Any ideas Thanx

I am using the following code, to extract data and display on a report, which then can be printed as a mailing label. Works great. =IIf(IsNull([CompanyName]),"",[CompanyName] & "" & Chr(13) & Chr(10)) & IIf(IsNull([Address1]),"",[Address1] & "" & Chr(13) & Chr(10)) &...

Not sure If i am posting in right place, so apologies. Essentially i have a table which contains company name, contact name and email address. I have a form which I can select those contacts to send an email to. I have all the code to construct and send the email. There maybe multiple contacts...

This maybe a simple issue. I have a form which displays Company Names, persons to contact etc. I have succesfully created a series of filters activated from command buttons to filterthe form display dynamically based on salesman, a single level filter. I now want to have a multi level filter...

I have a database, I am looking for a way to lock the size and position of the form such the user cannot change it. At present I currently have the forms borderstyle set to NONE. This achieves the result I require, but conflicts with another feature of my form. On the form opening I use the...

I have a small program which takes names and address data from my database. It then formats into a label, allowing the label to be position at any cell on the label sheet, works great. As part of this I have the facility to preview the label position before printing. the label is generated in a...

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

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

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