Recent content by benjee

Yeah the email address is stored in the combo box. I didnt want to 'hardcode' the email in, because it is subject to change (user could select different customer with a different email address)

Ive implemented your example Pat, but have decided to develop my appraoach. There are now three options in fraprintoption, preview, print and email. The email function works with the specific report as the attachment, but when MS Outlook is loaded up the surname of the customer appears in the...

Hello, in response to Pats post about previewing or printing a report is there a way to email a customer with their specfic invoice report. I have implemented this code, but it only sends an email to an email address that i have inputted in the code and it sends all records in the report (all...

Hello, I was going to provide a scarcastic answer then, but his is nor the time or the place. Yes, i will remember each reference ive made. thanks.

Pat once again thanks for your post -- most helpful. But regarding your 'meaningful name' remark, for the purposes of this example i understand what those control names relate to and i intend to change the questionable control names when i release my product for beta testing. regards

Hello, You could use a unbound text boxs in the reports footer and detail. Then in the footer textbox use the =val() function to write a subtotal from the other text boxes. i.e. =val(TextboxDetail1)-(TextboxDetail2) -> you get the idea HTH

Pat code works on the preview but not the print option. Here is my amended code: - Private Sub Command3_Click() On Error GoTo Err_Command3_Click Dim strDocName As String Dim PrintMode As Integer Dim strWhere As String strWhere = "" If Me.fraprintoption = 2 Then...

Hi, You need to group all the fields you want to display in a query, and then use a report to display your information.

Hello and happy easter! Have a reports menu, and one of the options when clicked displays all invoices for every customer (in a report). When this particular button is clicked is it possible for some kind of list box to appear, displaying customers names, so i don't have to remember them each...

Good evening, writing a query, and i need to retrieve all dates before 12-04-03 for example. How do i do this?

thankyou

Hello, simple question i hope, i have set a form to automatically load up when the db is opened. However, it doesnt maximise, is there a way of doing so?

Hello, I am trying to produce a report displaying a breakdown of details from my subform 'fsubEstimates'. Basically my sub form calculates values from combo/text boxes and stores them in a sub total (that is subject to change). Now i have been reliably informed that you cannot store a...

Pat, as directormac pointed out that was a clear and concise explaination -- thankyou. I can relate it to my example. If you look at my attachment the Id's of the combo boxes appear in the tblEstimate now -- great. The attachment shows my 'real' project that i am developing. I hope you don't...

Hello yeah i understand what your saying, but let me shed some more light on my situation -- i read my first message back and it did sound disconcertingly vague, i apologse -- ok back to it. Using a different example to yours, i have a form -- frmTest, this form comprises of a subform --...