Search results

Hi CEH Thanks for the reply. I have made the field part of the combo box relating to the clients information.... It is called cboclientid and the field name is clientemail. I have tried adding in code into the area where the TO: should be to draw the information from the client information...

Hi Liddlem I am already doing that, from the quote the Email button the command behined it runs the report (see below) stDocName = "Quotedem" DoCmd.SendObject acReport, stDocName etc...... Thanks for your reply

Hi I want to email a quotation report based on a survey type I have this code..... Private Sub Command103_Click() Dim StDocName As String If MsgBox("This will send Quote to your Client. Continue?", _ vbExclamation + vbYesNoCancel) = vbYes Then StDocName = "quotedem"...

Hi Could someone please help. I simply want to set up 1. Group of users with their own passwords and when opening Access it as a login box. 2. User name display when entering a quote for example (current user) 3. Display Username on reports who as creted a quote for example I am using...

Hi I have a mulitple page report. I need to insert into it PDf or Word documents.... I cannot find a way to import these within the report tools. Does anyone have any ideas how I can do this. Basically we are are wanting to put certificates within the document. Thanks

Hi Thanks for the reply. The main problem is to email the actual report with the record on screen presently... So if we have Quote number 1 on screen I only want to send the report with this record to the customer.... I can set the PDF in the formatpdf command within the code.... But...

Hi Yes I am, in two places (I have one on the combo using notinlist) and I also have added a re-query into the combo box relevant to my problem now but this does not work. Thanks

Hi I ahve a form with 2 combo boxes related to each other Client and Site (1 client can have many sites). In the client combo box I have Notinlist working well and if it is not in the list my message box activates the subclientform where I can add in the new details and also sites at the...

Hi Could someone point me in the right direction. I have made an email button from the wizard.... but what i want it to do is send the selected record (a quote) and sendr eport as PDF and to the named address email for that company contact. Coiuld someone advise, this is the code thus far...

Great answers guys, thanks alot, all sorted now.

Hi DCrake I like your suggestion but not sure where I out the bit of code I have my code in the control source =[SiteName] & " , " & [SiteAddr1] & " , " & [SiteAddr2] & " , " & [SiteCounty] & " , " & [SitePostCode] So where would I insert you suggestion. Thanks for the replies

Hi Justin.nc Did you attach something or miss out a link.... I cannot see any document to read.... Thanks for your reply

Hi I have this code that works fine so it brings in address fields =[SiteName] & " , " & [SiteAddr1] & " , " & [SiteAddr2] & " , " & [SiteCounty] & " , " & [SitePostCode] Despite many searches on the internet I cannot find the solution to taking out a , when there is no part of the address...

Hi I want to try and create a Word document from Access. Does anyone know where I can find a simple step by step example of how to do this using Words Bookmarks...... OR give me a simple way to do it. I have my report working in Access but I needed to have a content page which should go to...

Hi I need to create a multiple page document within access and the way forward is to have each part of the report set as a sperate report, then add into the main as sub forms with page breaks... This appears to work ok, however its the hyperlinks that is the problem.... For example on...

Hi I will also open a new post on this.... after some investigation the way forward is to ahve each part of the report set as a sperate report, then add into the main as sub forms with page breaks... This appears to work ok, however its the hyperlinks that is the problem.... For example on...

I need to creat an Access report with about 15 pages....... Is this possible in the access design area, I can only seem to see or get one page at a time........ I have the Front Cover So my questions are 1. how do i create it so I can have multiple pages 2. On the contents page I would...

Hi Ok I tried them all and it ended up being 2????? How do you know which field is which??? Anyhow the really good news is it now works.. Cant thank you enough many many thanks for this..... and of course it as been a good learning curve for myself.... Thank you

Hi Ok I have added in the surveytypes a file that has the name of the report next to the relevant type. I ahve changed the code to the below and now I am getting this error message saying " The action or method requires a report name arguement" I ahve taken out the stdocname and also tried...

In this instance I will add a column into the surveytypes table as you suggest beofre I adjust the coding do I still need the stDocName in the code line or does the new combo command take over this, i will try it anyhow Thanks