Recent content by trebor3900

Thanks guys worked a treat.

I have a table imported to a spreadsheet from Access containing a duty and a staff number DUTY STAFFNO Rest Day 123456 Rest Day 234567 Annual Leave 345678 Earlies 456789 Earlies 567891 Lates...

Thankyou Ghudson. I will try it. This forum has never failed me yet. My project would not have been possible without it. Cheers all

Now you can add Windows 2000.....:-(

RuralGuy, trust me, i am as puzzled as you. As i say this does not happen on my machines at home. But happens every time on my networked machine at work. So is not just a blip, just wondered if anyone else had any ideas how it could happen. I might have some idea how to rectify it

I have experienced a problem copying a database from a CDR to the C Drive of a networked machine at work. What happens is that the Database attributes are changed to "Read Only" after being copied. I can change this easily enough but i dont want other users to have the same hassle. This problem...

Success Having tried the same operation again, i experienced no such problem.....Wierd...Thanks for your time anyway. It made me try again. Thanks again

I have a database with front end and a back end databases. I want to share this database with other users on CD. The problem is that when copied to a local hard drive from the CD, the read only properties of the databases are set. Rather than rely on the user having the knowledge to right...

Ok Thanks for your time guys

I know how to protect a worksheet from being changed by the user but this does not seem to prevent it being deleted. Anyone know how to accomplish this Cheers

i thought that, but i tried taking one instance out. This did not affect the previous code sample either. Thanks anyway

Forgot to mention that the program falls over on the following line of code: Set rsItem = qdfItem.OpenRecordset

I have a database that adds the details of orders to a spreadsheet <Order Book>when they are made. This works fine When the orders are recieved the same spreadsheet<Order Book> is opened, the corresponding record is found and updated with receipt number and receipt date. The following code when...

ctrl + P will print the Report

That worked a treat..Thanks for your time