Search results

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

I have read the thread concerning hidden toolbars in Access requiring a custom toolbar in reports. But i do not seem to be able to get rid of the windows close button. Obviously when pressed closes the database altogether...Which is baaad Any ideas?

No...Still gives me an error on the second line as before. Though the new code works fine on all other forms Getting weird now Gotta be the form

Still the same result...I dont think the code is wrong because it works fine on about seven other forms..What could be different on another form that would affect it. I have even made a new form with the same code in it and it worked fine....:)

I thank you for your comments and have taken your advice on all instances of the relevant code. Still the problem exists with the one form in particular. Perhaps the problem exists with the form in particular and not the code?

Can anyone tell me why having used the following code on all my forms in a database without any problems: If DateDiff("d", Now, "01/04") <= 0 Then Me.txtYear.SetFocus Me.txtYear.Text = Year(Now) & "/" & (Year(Now) + 1) 'Date is past 1st April Else Me.txtYear.SetFocus...