Search results

Cheers, I just wanted a small bit of code though. I tried the following: Private Sub attach1_AfterUpdate() DoCmd.RunCommand acCmdSaveRecord Me.attach1.Locked = True End Sub I got an error message "The macro or function set to the BeforeUpdate or ValidationRule property for this field is...

Hi I have setup bound objects on a form which I will be linking files from server. After I have inserted the files I want them to be locked so nobody can change them. I have tried various bits of code in "after update" but I keep getting errors. Can anybody help? Thanks

database attached.

Hi, I have a form with a section for notes that I want to keep a diary of. One text box is used to enter the new notes and the other is used to store historical notes. To update the historical notes, I want to use a command button to update with everything in the new notes + a datetime stamp so...

The database is attached. look at the form frmMQC and see what you think. thanks mate

No it is greyed out??

what do you mean by that?

Thanks i managed to sort out the colours. I get an error message with the code you gave me, ive attached the message. any ideas?

Hi I have a 3 queries that I need help with: 1. I would like to be able to insert PDF forms in to a tab on a form as an icon. What I had in mind was a command button which would call up explorer so that I could select a file to insert as an embedded icon in the tab. I would also like to be...

I am trying to export a text file to be imported in to excel but whenever I export as fixed width all by number columns get cut to 2 decimal places, does anybody know how to get around this? Thanks

Rather than start a new thread i would like to do something similar. I would like to display the date modified of a table on a form. Any suggestions?

Maybe but I am beginner so am not capable, could you write it? cheers

I have a simple bit of code below but I need something added. All the code is doing is opening a form and filtering on a combo box value. It opens all cases where the status is open but if there are no open cases it takes me to a new record, how do I get my code to recognise that there are no...

No I am going to have this rolling forward and queries are going to be referenced to the text box so I can run reports. Bascially I just need a formula that can just stay there so that reports can be run without changing anything.

I am trying to pull back the corresponding date 6 months ago i.e 6th March from today or 6th April when its 6th October. I see what you mean though, any ideas?

If I key in to the control source of a text box "=Date()-184" I will get the date 6 months ago but if I tried the same of 06/10/05 I will lose a day because of the 30/31 day months. Does anybody know another way around this?