Search results

  1. N

    delete

    sorry cant delete this
  2. N

    Query date

    So i have the query linked by the "Customer Ref Number" with criteria "is not null" - this bring me a list of all appointment requested not booked and not completed, but if an appointment completed was before the new requested appointment, this query currently does not show the new appointment...
  3. N

    Query date

    brings no results at all :(
  4. N

    Query date

    "Customer Ref Number"
  5. N

    Query date

    Hi, So I currently have a query that looks at a table with appointment requests against a another table Appointment Booked and then another Table Appointments completed. What I need to do is only show appointment requests if the Appointment Booked and Appointment completed dates are greater...
  6. N

    Sending an email with attached report - dont sent if nothing attached?

    Oh ok sounds good how would i go about setting this up
  7. N

    Sending an email with attached report - dont sent if nothing attached?

    Ok so sometimes it falls over afte this point... .Attachments.Add "File name and locatin here" & Format(Now(), "DD-MMM-YYYY hhmm ") & ".xlsx" email is send without attachment so yes you are correct the If rst.RecordCount = 0 Then does stop if not records found, but the issue is that for...
  8. N

    Sending an email with attached report - dont sent if nothing attached?

    Hi Thanks for your reply, so just want to stop sending email without the file attached?
  9. N

    Sending an email with attached report - dont sent if nothing attached?

    Hi, so i have this code which is run from a button i need to stop the email from sending if no attachment has been made.. Dim rst Dim XL As Excel.Application Set XL = CreateObject("excel.application") Dim vFile vFile = "Template File Location Here" Set rst = CurrentDb.OpenRecordset("All") If...
  10. N

    Run only once on a Monday module

    Ok, so i do have a timer event on my main menu that closes the database after 10 mins if no usage, so i need to add some code to turn that off in autoexec macro before running the Module code ? So would it be best to move this code to the same Main form and run this before the timer ect
  11. N

    Run only once on a Monday module

    ok so this is running fine jut its causing runtime error 3734 The database has been placed in a state by user "Admin" .... I can calling the Module code via Autoexec Macro. any better way to run this code?
  12. N

    Solved Delete Duplicated Records - But Keep 1

    You were correct i did, all working now, so now i have the new table set with the Indexing - will this stop in future any duplicates being added? for same customer same appointment date and time, but will allow a different date and time for customers
  13. N

    Solved Delete Duplicated Records - But Keep 1

    ok so just it removed all records using the account number even if the same customer had 3 appointment dates and times Ok sorted it now i made an error in the index thank you so much :)
  14. N

    Solved Delete Duplicated Records - But Keep 1

    OK so its seems to have delete all duplicated records using account number, some of the records are the same customer but with different appointment dates and times, so wanted to keep them - did on test data so no big deal did i do something wrong?
  15. N

    Solved Delete Duplicated Records - But Keep 1

    Ok did thats and got an error message saying Cant append all the records in the append query due to key violations so thats correct right as these ones are the duplicates?
  16. N

    Solved Delete Duplicated Records - But Keep 1

    Customer account number and appointment date and time when all same
  17. N

    Solved Delete Duplicated Records - But Keep 1

    I have my duplication query showing all the records within duplicated thats as fair as i have got, reads that someone says create a table and then use that table to duplicate in master table, but it deletes all records and doesn't leave 1 record?
  18. N

    Solved Delete Duplicated Records - But Keep 1

    sound simple but how?
  19. N

    Solved Delete Duplicated Records - But Keep 1

    So I need to do some data cleansing and need to find the best way to delete duplicated records but keeping just 1 Is this possible to Run from a query ?
  20. N

    Solved Show Records if More than 1

    thank you yes this worked :)
Top Bottom