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

Thanks Minkey, sorry got your user name and the link name mixed up! What i should have said was: I tried the solution you outlined for Vista Home, but it did not help. Just to see I tried doing the share on the external drive from the Vista Laptop, I could access this from from the XP...

Thanks clicky, didn't work I'm afraid, any other solutions? Thanks in advance

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

Many thanks, works great!

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

Hi, Thanks for that, so simple, worked a treat

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

Thanks, code works great, many thanks for your help

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

Hi Wazz Thanks for the info, i have looked for the "Movable" property before, I am using VBA in Access 97, I do not think this version includes this. As to the module conflicting, I am doing some further tests Thanx

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