Recent content by Transentient

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