Search results

Hi i was wondering if it is at all possible to search across multiple tables with one query. I have a database with about 15 tables and my users would like to be able to search for text across all the fields in all the tables. I have a simple find record command on each table, but in case they...

I think i have done it! thanks for tip on CurrentDB.Execute as i didn't want a user message i used this code, it worked but does it look ok to you? thank you so much for all your help, can't thank everyone enough! :-) --------------------------------------------------------- Private Sub...

thanks Paul, the <space> in error message was just a typo. I have updated Dcount line per your suggestion, i have also changed Date to now (see red below). AND it seems to work (yay!), the email is sent but now code not working on inserting the sentdate into the emaillog table. get error...

Hi Paul, i did but i got the error message: run-time error '3075' Syntax error (missing operator) in query expression '[sent date]='. i googled this and it looks like i might just be missing a ' or " somewhere but no idea where. Also would it matter that the date format is probably DD/MM, not...

the sent date field is a Date/time data type

David, think i am getting there! this is now the code: ------------------------------------------------------ Private Sub Form_Load() If weekday(Now) = vbTuesday Then If DCount("*", "tbl_emailLog", "[sentDate]=#" & Date & "#") > 0 Then Exit Sub 'do nothing Else 'send email...

David, thank you so much for your help. My code is now below with the email log table also created. I have it on the "load event" of my front form, but i am getting a "Run-time error 94 Invalid use of Null" with the "If Weekday(Date) = 2 Then" line being highlighted...

i'm having a few problems with the code, this is my current code: Private Sub Form_Open() Dim MyDate As Date Dim MyWeekday As interger MyDate = Date MyWeekday = Weekday(MyDate, vbMonday) If MyWeekday = vbMonday Then DoCmd.SendObject acSendReport, "Actions - outstanding", acFormatPDF...

so far i have managed to raise the email when the database is opened: Docmd.Sendobject acSendReport, "Actions - outstanding", acFormatPDF, Nz(DLookup("[Lead Investigator email]", "[Case Details]")), Nz(DLookup("[case email address]", "[case details]")), "Outstanding Actions", "Please find...

Hi I have a MS Access 2010 database with various forms, reports etc. I would like an email to be sent once a week which attaches an existing report ("Actions - outstanding"). I don't want it to happen on with a command button, but just automatically, although i think the database will have to...

Paul, yes it works when the Case details form is open, but is there a away of doing it when the form is closed? How about it if i link the two tables (supporting the forms) by a query, would that work?

thanks Paul, this is what i have added, .To = Forms!Case Details.Manager Email but now get a "Compile error: Syntax error" message so i changed it to: .To = Forms![Case Details].[Manager Email] now get a message saying "Run time error 2450: cannot find the referenced form 'Case Details'" but...

Hi i have a command button on a form that creates and outlook email with an attachment. I would like to populate the "to" and "cc" fields of that email with email addresses which are completed on a different form in the database. but i just can't seem to work it out. I want the "to" field to...