Search results

  1. Bar_NZ

    Form data, create PDF(s) and e-mail

    Hi All, wondering if you could assist me please. I have a table created from a query which contains member names and e-mail addresses and fee they have to pay. There are currently 995 records in this table. Each member has a MemberNumber (Fieldname) which is unique, but not sequential. What...
  2. Bar_NZ

    Table data into BCC for emailing multiple recipients in one email.

    Hi all, I'm trying to get Access to send out one email to multiple recipients using Bcc and pull the email address from a table. I do not want to send any attachments directly from Access, these will be attached, once the e-mail opens and is ready to send. Table Name: Just_Email Column Name...
  3. Bar_NZ

    Change focus and copy if text field is empty.

    Hello, can someone please help me, I have the code shown below and I'm having an issue, could you please help me? What I have is two phone number fields MobileNum and InternalNum. On click I would like to look at the InternalNum if it has a value, then copy it to clipboard and open the...
  4. Bar_NZ

    Send email from access vba using outlook V2

    Hi All, can I please ask where I am supposed to put the MailItem.SentOnBehalfOfName in the code that is mentioned in the thread of the same name without the V2, lol Any help would be greatly appreciated.
  5. Bar_NZ

    Pivot Legend only shows first two letters of the word

    Hey there, can someone help me please, I have a query that pulls information from a combo box in my form, now I've made a pivot form to report the outputs, however my legend will only display the first two letters of word... I need to show the entire word, any ideas??? :banghead:
  6. Bar_NZ

    My new big-ish project - can you help?

    During this project, I will end up having multiple questions over a period of time, I really hope you have patience with me.... The database: is for tracking computer issues (this part is complete), also I need to show the on call roster (mostly complete)... This will also have a time sheet...
  7. Bar_NZ

    Help Please with a tricky Iif statement

    Hi all, please help me... I have a form that calculates time (In Minutes) however i'm having a little trouble with one specific iif statement (Below).. What it should do: Place Time (KPI) 01:00 Place Time (ACT), could be any time from 22:00 - 04:00 Hours It should process the time in...
  8. Bar_NZ

    Counting selections of a combo box

    Hey all, just wondering if there is a way in a query to count what was selected in a combo box from a form, these selections are written back to the main table. I have many codes, however I need to count how many times each is used in a week, month, year... I have a query that can grab and...
  9. Bar_NZ

    I really hope someone can help me please!!

    I was tasked with making a roster, not so bad, threw it together... Now I have been asked to make some changes to it that I'm not so sure I can do... If someone is able to spend some time looking at it and helping me out, I would really appreciate it. :confused: We have 5 staff, our roster...
  10. Bar_NZ

    Hey from NZ

    Hi All, I am from New Zealand, I am a newish Access user and will have plenty of questions, I live in the shaky city of Christchurch and am into RC monster trucks... I'm very pleased to be here and hope to participate as much as possible. :) Cheers B
Back
Top Bottom