Search results

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

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

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

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

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

Morning I have a report that shows individual records which contains a sub-report showing the individual record in more detail. However, I am not keen on the sub-report formating showing on the main report, i.e. the field headers showing, the gridlines, the table and I want to get rid of it...

Hi there, I'm after a macro that when the user clicks on an item in the first column of a subform, it displays the attached file, if there is one. Any ideas? Thanks for your help Manc

Hi there. My Quotes table has its unique reference number generated each and every time, but our company is currently on 83000. My new Form is on 4. Is there away, without entering 82996 dummy records, for this to 'catch up'? Thanks for your help Manc

Hi there I have a customer table of 5 customers. I have a contact table of 5 contacts for each customer. I have a new table where you choose the customer from a drop down list using the lookup wizard. The next field is then "contacts". How can I limit the contacts displayed via drop down...

Hi there I've been looking at the Northwind 2007 demo and playing about with it and have printed of an invoice from it relating to ONE sales order. When I go into my 'masterpiece', (I have designed a report/invoice), when i go to a specific record and view report, it shows every record, not...

Hi there. We have envelopes set out in Publisher for each of our Clients. All we do is go to the envelope folder, select the envelope we want, the file opens in Publisher, we select print, close the file and the envelope prints out on the dedicated envelope printer(!). Is there a way that...