Recent content by Kim296

Thank you for your time Andy, I tried the suggestion above. It still gives me the .send error. Hum, I will keep looking. Thank you.

Thank you for your response. Yes, I do have the Microsoft CDO library in my reference tools. The line of error is occurring from the "newmail.Send" line. This is what makes me think that I'm missing a step somewhere not relating to this code.

Good Morning, I have been trying to figure out how to send gmail using vba in Microsoft Access. I feel like the below code is correct as it's the same on every tutorial, instructions and research blog that I've found over the past week. I feel like I'm missing something else that I should be...

Thank you all for your responses. Yes, I do like to learn and try different things for myself. I will try what you both suggested. Thank you for your time and examples; I really appreciate your responses. It does help me think of different ways to approach my issue.

Hi everyone, I have tried researching this and watching videos for a week now, but my brain hasn't been able figure this out to save me. Any help is appreciated. I have a simple program that will be designed for keeping up with documentation on employees (tardiness, verbal warnings, recognition...

Two main tables used: tblProjectMain - automatic sys id number (PROJID), this data is the same for each crime series (one project) tblProjectEvent - there are multiple events in each Project Series (linked to main project by sys id PROJID) Each Project may have many events in the series (record...

Good Afternoon Everyone, I'm using a query with a lot of calculated fields. The stumper for me is how to calculate a date difference between the current record date and the previous record date within the same record set. query name: qryProjectionEventsAll record set: PROJID (Linked to Main...

Good Afternoon Everyone, I have a form which includes an image to appear behind lines that I drew for a chart (x and y coordinates). I can manually set the image behind the drawn x and y lines, but I can't figure out a way to automatically send the image to the back after an image is added. The...

Thank you very much for your response.

RE: ACCESS FORM Is it possible to base a chart strictly on unbound form fields? I've created a form template which allows simple calculations, using (2 columns with 12 rows) equating to 24 unbound fields, that I wish to chart. The unbound field calculations work perfectly; however, I'm unable...

Thank you Ian, Your solution worked perfectly. I appreciate your help.

Hi Everyone, How do I calculate the time difference between two date/time timestamps that are in the same field, but use different codes. The fields are linked by the same event number. For example: EMS arrived at the hospital (incilog.transcode= "H") at 02/28/2017 15:00 (incilog.timestamp...

I solved this. I figured out that my "Approve" and "Denied" were referencing the ID number, so I had to substitute 1 and 2. RStatus: IIf([STATUS]=1 And (IsNull([PROVIDEDATE])),"Pending Delivery",IIf([STATUS]=2,"Denied",IIf([PROVIDEDATE]>1,"Delivered",""))) Thank you!

I'm trying to create a formulated field that will display the record delivery status, so that I can filter the status for reporting. This formula appears to be working as I'm creating it in the expression builder; however, when I go to the datasheet view it shows "#error". Can anyone see what I...

Wow. I figure out my own problem. To concatenate group records, this is what I did and it works. //@reset, placed in the main group header stringvar CONCAT :=""; WhilePrintingRecords; CONCAT //@Concate. placed in the secondary group header WHILEPRINTINGRECORDS; STRINGVAR CONCAT; CONCAT:=...