Recent content by Manc

PaulO, thanks for your reply... We are now entering the realm way above my head... Sounds interesting, but that's as far as it goes! Thanks Manc

Dear Demigods, My form is made up of three columns - 1st column is ten text boxes, 2nd column is ten list boxes, 3rd column is ten text boxes. The first column is where the user can enter up to ten different charges that may apply to record that they are viewing. The second column is where...

Dear Demigods I have three tables Table one: tblCountry CountryID Country (Every country in the world or most of them) CountryZone (The world is split into ten zones) Table two: tblWeight WeightID Weight (Weight range is from 1 to 200) Table three: tblPrice PriceID 1 2 3 4 5....(etc etc...

I am presuming that your control source on the textbox containing the email address is 'email'. If it isn't, then change the =[email], to =[what ever your control source is that stores the email]. You could also name the textbox on your form to txtEmail for example, and reference that...

Good evening demigods, I have the macro below working fine, but is there a way to send it from a different mail account rather than my defualt one? I'm using Outlook and obviously I realise that the "other" mail account would have to be set up on every PC using this code. The reason being...

Hi Iain try =[email] with [email] being the control source of the textbox from your form. Kind regards manc

Good evening Demi-gods I've been reading a lot of articles on this site and others, and this link interested me lots but is way, way, way over my head, but I like the fundamental idea behnd it. http://accessexperts.net/blog/2011/07/07/importing-outlook-emails-into-access/ Here is a brief...

Hi penguino29 Thanks for your response. The problem I had was not the actual restricting of the data to display only the record I was viewing, but a problem with the actual code. There didn't seem to be an expression to restrict the data and I found that the report was converting all the...

Slight change to convert report to pdf and email needed - SOLVED Dear all I found this code on another thread and have modified it very slightly Public Sub SendEmail() Dim appOutLook As Object Dim MailOutLook As Object DoCmd.OutputTo acOutputReport, "rptQuote"...

Thanks again Mr Larson I took the advice from the link and went back and removed the lookup from the original table and lookups now take place on the forms only, seeing this is where all data-entry is made. I added tblPackages to the query, changed QuoteDetailPackages from tblQuoteDetail...

Thanks Mr Larson I have checked my tables and I am only using lookups at table level on one of them, and as far as I can see, I am happy for that to be like that because the information can be overwritten if the client wishes to make a change. I appreciate the link though, what you said...

Hi I have a combobox on a query within a report that I am using the following expression: [CODE]=Trim(

Thanks vbaInet. Did what you suggested. Made the subreport form I was using into a query instead and put that into my report and voila, exactly how I want it to look. I have however wandered into another stumbling block which perhaps you could shed some light on. I have started a new post...

Thanks vbaInet, that is what I will do then. I will let you know the outcome. Thanks for your time Kind regards Manc

I have attached a zip file containing an excel spreadsheet called screenshot which show how the sub-report looks on the report. See what I mean about formating? I don't want the column headers or the alternate row colours - just plain old text. I will then put the column headers on the main...