Search results

OK, Slight update I'm pretty sure the way I need to do this is to look up the FIRST new description and update to the FIRST available ID...this I can do... What I need is a looped IF statement that does something similar to the below (please not this is not my attempt at VBA...just a layman's...

Hi All, I have what I'm hoping is a simple update query...just can't get my head round it (might need some coding) Table 1 ID..........Description A...........Tools B........... C........... D........... Table 2 Description Requests Tools Accessories Kits This is an exercise to assign new...

Hi All, I'm sure there is a simple solution to this problem but I just can't find it, and looking on this forum i can find several ways to refresh the subform but not the main I have a Form and a subform (frmMaster and sub_Paid) on the subform, sub_Paid I have a field called dblPaidValue this...

How would I export the query? I know how to do a basic export, but this creates a whole new Excel file, and is quite manual...I need to export the data to an existing excel file, and preferably automatically so I do not need to manually trigger the export? Kind regards Paul

Hi All, Have searched the forums for an answer to this (hopefully simple) question. I have a query out of access that displays the completed actions for a previous month. I take this and paste it into an excel file that contains the monthly scorecards. Now in an ideal world I would link this...

.Attachments.Add = "[txtTM]" should read .Attachments.Add ([txtTM])

Hi folks I have a database that arranges training sessions. It sends out the meeting requests automatically. What I'm trying to do is add ann attachment to the mail...now I know how to do this by manually adding the file location, problem is the attachement is a different file for every...

If you want to send to multiple recipiants you can put the address list together as a string. I've use it on an outlook appointment Item I basically set up a hidden combobox that concatenated the email field with ";" seperators, I then use this to get the .To value from It is basically three...

Ok another revision I now have found some code that looks like it should work, but fails [part the way through. It basically looks up the query with the email addresses in and sends the first one ok but then does not move to the next record. Instead I get the following error: Run-Time Error...

I do something similar where I have a combobow with types of training sessions (cboCourseList) and when I select this I want a second combobox (cboCourseDate) to only show the dates from tbl_Sessions where the selected course is available. I would have thought it would work the same way for a...

Equally if somone knows how to use SendObject to send a voting button that would also be a way round this, although I'm pretty sure this cant be done

Hi Folks I have searched and searched on this forum and the web for a solution, so far to no avail. I basically need to send on the click of a button a mail independently to several people (1 email per person) Now I have a way to do this using a loop function using recordsets and the...

I had a nasty suspicion that might be the case, damn and blast these people that keep changing their requirements! thanks for the info!

I know there is a votingoptions command for mailitems but as this is not a mial item I don't know how to get round it?

hi folks I've had a search on the forum to no avail... I have the following code that sends an email... Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset Dim sToName As String Dim sccname As String Dim sSubject As String Dim sMessageBody As String Set MyDb = CurrentDb() Me.Refresh Set...

Hi I'm having the same issue as above yet my edit message section is already set to false, does anyone know of anything else it could be DoCmd.SendObject acSendNoObject, , , _ sToName, , , sSubject, sMessageBody, False , False

I should have mentioned I've tried differennt combinations of AppointmentItem MailItem MeetingItem to no avail

High folks, Essentially I have a database thatsends out meeting requests as an AppointmentItem. The replys are automatically sent to a certain folder in my inbox. I also found a second bit of code that pulls mail details from a chosen folder through to access. My problem is as follows, the...

Use the Afterupdate function with a refresh as opposed to a requery Private Sub (insert contact combobox name here)_AfterUpdate() Me.Refresh End Sub I use this on my DB and it works fine

Hi Folks, Have dug around in the forum for an answer to this question but to no avail. i have a training database that is used to book training courses. On booking a course it sends out a meeting request in Outlook using the code below... My question is that for each training course I have a...