Search results for query: *

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:=...

I don't understand your question. There is one extra day in Feb; there isn't a whole extra week. Your report should still work. Please explain a little more detail.

You should be able to add a new table in design view by using the field explorer, right click on database fields, pull over the table that you wish to add and link to your existing tables. Then you should be able to add your invoice description. Hope this helps you.

I found two formula's that allow you to concatenate detail records and I tried using it on group records and it works... Except it doesn't reset for new records; it just continues for ALL records. When using this to concatenate group records, does anyone know how I can reset it to start over on...

Thank you Brian. I will try this.

Can anyone tell me the right way to make the following loop through multiple search words. (Ex. Search1, Search2, Search3, etc.) Right now, it will only search the text using 1 search word. Shared StringVar SearchText := {@SEARCH1} ; StringVar Htm1 := "<font color=#FF0066>"; StringVar Htm2 :=...