Search results

  1. M

    Help. db works on one computer and not another

    What would make a computer work fine with this and then just stop? i cannot find reference issues with this, it looks the same on both computers?
  2. M

    Error Sending Email Through Access - Via VBA

    Hi can i ask how you resolved it as i am having the same problem, worked fine on all my computers and then out of blue stopped working on two and only works on one computer now and i cant find solutions
  3. M

    Help. db works on one computer and not another

    IT was working fine on both computers then just stopped working on one for no reason that i can trace?
  4. M

    Help. db works on one computer and not another

    sorry i do not understand, what am i doing wrong please
  5. M

    Help. db works on one computer and not another

    Hi i have a script that creates an email for weekend bookings confirmation for musicians. it works perfectly on my computer and worked fine on my other computer till just recently and now it brings up error "13" when i try and run the object? the code is as follows and seems to be an issue when...
  6. M

    Grouping data to send to email

    Hi again, i have a filter that shows the bookings for the weekend, which i can click on each act and it generates an email for then to confirm. however some acts have more than one booking on that weekend and i want to be able to list the bookings in one email, how would i do this please, the...
  7. M

    Formating a date in Email from Access

    Thankyou thankyou thankyou, that worked perfectly. you are wonderful
  8. M

    Formating a date in Email from Access

    firstly thankyou so much for you help it is greatly appreciated when i use this .Subject = "Week " & Format(Me.gigdate, "ww") & " " & Format(Me.gigdate, "mmmm") & " " & strSubject & " - " & act i get this Week 29 July Weekend Booking Checkoff - Greg McKew i need this Week 3 July Weekend...
  9. M

    Formating a date in Email from Access

    sorry i need the week number in the month not the week number in the year, does that make sense
  10. M

    Formating a date in Email from Access

    i need it to look like this Week 2 July Weekend Checkoff - act name
  11. M

    Formating a date in Email from Access

    thanks for the quick reply, this gives me Week Friday 20 July Weekend Booking Checkoff - Greg McKew but does not list the week number as Week 3 Friday 20 July etc am i doing something wrong .Subject = "Week " & Format(gigdate, "ww") & " " & Format(gigdate, "mmmm") & " " & strSubject & " - "...
  12. M

    Formating a date in Email from Access

    Hi i have a script that creates an email for a booking when i click on the artist name which works great. i want to be able to subject the email with the week number of the month. ie in subject it would be WEEK 1 JULY WEEKEND CHECKOFF. with the date info coming from gigdate field Private Sub...
  13. M

    Send email from filtered data records

    hi i thought i would give some more info as i was very vague sorry. i have a filtered list created with a date range that generates a form view. i want to be able to on the generation of the form view create on the fly grouped emails from the records for each artist. so i they have two shows...
  14. M

    Send email from filtered data records

    hi i need to be able to send an email from a filtered Form the form shows all bookings for the next week, i need to be able to group by a name field and the email lists all the bookings for that name any help please:eek:
  15. M

    Generate Email with multiple records

    Hi again, i have a script that generates an email for a booking html formatted. i need to be able to list more than one booking on the email i want to me able to send out emails for all musicians that are working that weekend to confirm their bookings. i have a form that lists all bookings for...
  16. M

    Generate Email with formatting issue

    thankyou this worked perfectly and thanks for picking up date use error
  17. M

    Generate Email with formatting issue

    Hi i have a script that creates an email for a form with general formatting, but i need to format the date to dddd dd mmmm yyyy and the time i need to be hh.mm am/pm, how do i do this please in this script Private Sub Command208_Click() Dim msgTxt As Variant Dim objOutlook As...
Back
Top Bottom