Search results

So after a little thought this code line ended up working MyMail.Body = MyMail.Body + rst!strEquipNum Haven't tried Bob's suggestions yet. That will be the afternoon project. Thanks for all the help on this.

Once again thanks, i never knew about that function in VBA, i'm definitely going to be making good use of that. I'm stepping through the code now and you are right. My code is working as i told it to, couldn't see that before. The loop is working correctly, i added a third record to the table...

Thanks Spike, have that page open and am about to start reading. I like to try and figure stuff out myself but sometimes you just come up blank. I do wish i could get my work to put me through some kind of training but don't see that happening :)

Thanks for replying so quick, i tried this and it got me something :D. It put in the last entry in the table. The table has two entries. So now i'm guessing my loop isn't right.

I totally agree with this. I got kinda pushed into learning VBA. I've had no training at all. Started out helping out with data entry and ended up building forms, queries etc. Now i'm getting into vba. As my boss tells me, don't re-inevent the wheel. If there is some code already written that...

Hi all, still very much a newbie here and i'm trying to learn as i go. Here's my issue, i'm trying to create an email with list of numbers in the email body which come from field strEquipNum in temp table ttblIxReview To begin with i was doing this from a continuous form. I could get the...

Finally had a chance to try these out, they both worked. Ended up going with the ADO version. Thank you for the code. I haven't been doing this type of stuff long and with NO training, so most of the time i either have to look at the existing code and try to edit it to make it do what i want...

KingSassa thanks for the quick reply. I don't have time to play with this today but will give it a try first thing tomorrow morning and let you know how it goes. Access version is 2003, and we are ADO for the most part but do reference DAO.

Hi all, here's my problem. I have a temp table that gets filled with 121 records. Each record has a time field (sngTime), but it when it gets imported into our database this column does not always start at 1 and isn't always sequential. I want to use this data in a graph and use the time field...

Thanks Bob, in fact i think it was one of your replies that helped me stop banging my head against the wall this morning while trying to figure out a "2501" error message. :)

Hi everyone, i finally got around to registering here after lurking and finding fixes to various problems i have had with Access. I have to say i have no formal training in access. I kinda fell into my position here of Assistant Database Manager by being the most computer literate person in...