Search results

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...

Jack thanks for that it has given me some inspiration. Do you know if this will work with access 2000 Regards Chris

I have a form in an access database that is currently printed out and faxed over to customers. Is there a way I can email to them instead?

Cheers for that, easy when you know how I guess. It worked a treat:)

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...

Ok so does no one know how to make a form save a record as soon as you start entering the information?????????

Ok thanks for your help, do you now about point number 2 on my original post?

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:

What is DAO

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...

Doesent look like the file attached to last post so I'll try again

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...

The record source is a query that returns the results from all three tables including Company.Address and RMA.Delivery which I why I cant understand it sayiing object required pointing to Company.Address. I wonder if the code is running before the data has been pulled into the report, hence...

Do you mean that delivery address needs to be added to the form before the report gathers its data and is opened? The layout of the report is Invoice address at the top Left hand side and also the right hand side and its the right hand side address that needs to change to the Delivery address...

I have 3 tables RMA, Company and Product which have a replationship to join them. Company.ID = RMA.Company Product.ID = RMA.Product I have a form which populates the RMA table, on which the Company Name is a lookup from the company table and Product is a lookup from the product table. From...