OK Ive tried this and it works great if they have the Snapshot viewer installed and then they can only see it and not fill it in and send it back to us completed.
Word would be an excellent option if only I could find a way of getting there so as if I had coppied and pasted it from Access.
It...
How can I make my form autosave the record Im entering as soon as I start to type.
I need it to do this because there is a report created from within the form attached to a button that uses the information entered. At the moment the user has to click save record before the report will display...
Wayne
Thanks for showing the link to that but Ive not got much experience with code,
What I want to create is a mirror image of a form in Access into Word so I can attach it to email. What part of that Code will do that for me?????????
This form is blank for customers to write in details...
Access 2000
1) Ive got a form in an access database that needs to be emailed to customers for completing and they inturn email it back to us.
I dont think there is a way of sending an access form by email but can you send the form to word so it can be sent as an attachment to for completion to...
:)
Wow that is brilliant it seems to have worked a treat
Cheers Mate
I will play around with the layout tomorrow and hope it will put this complicated report to bed.
Im off to bed now.
Thanks again to everyone who has given me help
:rolleyes:
Ive tried to specify every change in displaying fields with the following code
If Me.Delivery = "" Then
Me.Address2.Visible = True
Me.Company2.Visible = True
Me.Delivery.Visible = False
Me.Address1.Visible = True
Me.Company1.Visible = True
Else
Me.Delivery.Visible = True
Me.Address2.Visible =...
If Me.Delivery = "" Then
Me.Address2.Visible = True
Me.Company2.Visible = True
Me.Delivery = False
Else
Me.Delivery.Visible = True
Me.Address2.Visible = False
Me.Company2.Visible = False
End If
Hallaluya this code seemed to work at least...
Ok we have got a bit further but now I get a complie error. See Attachment.
Am I right in thinking that you dont need to specify the table in the code i.e.
Me.CompanyAddress.Visible = False
or
Me.Address.Visible = False
Company referes to the table and it seemed to like the code without...