Search results for query: *

Thanks for your input. I really appreciate it. SarahG, I don't think I can use the code you supplied, but you gave me an idea to work with. I will continue to try to develop this. Again, much appreciated.

I am posting this in a few Access forums to see if anyone has ideas. I need help with printing. I am writing a procedure to read and update records in a table. I want to read a record, print the value of a field, change the value of the field, then print the value of the field again. I want...

I am posting this in a few Access forums to see if anyone has ideas. I need help with printing. I am writing a procedure to read and update records in a table. I want to read a record, print the value of a field, change the value of the field, then print the value of the field again. I want...

I need help with printing. I am writing a procedure to read and update records in a table. I want to read a record, print the value of a field, change the value of the field, then print the value of the field again. I want to also add comments with the values. I want to send each line to...

Thanks DeMann for your assistance. This was very helpful. I borrowed code from several places to put this together. Now, the only adjustment I would like to make is to the following code, within my routine: With rst .MoveFirst Do While Not .EOF If rst![programmer number] =...

Hello, I have coded my issue two different ways. I am trying to send an email for each record in a query. In the first set of code, I am using SendObject. When I use this method, the first email goes out fine, then Access shuts down, saying the program has performed an illegal operation...

Thanks DeMann. This doesn't really help me, as it is not what I am trying to accomplish. Maybe if I put my objective into steps, somebody can help me get those steps into code. I appreciate any assistance greatly. TABLES: PROGRAMMERS - PROGRAMMER NUMBER (1-10), PROGRAMMER NAME ASSIGNMENTS -...

At this point I don't have any code. I am trying to figure out how to put it together. I just have the tables and the form.

I understand the concept, but the problem is getting it into code. I understand running the query to get the last programmer, but then how do I go to the programmer table and get the next programmer's name, then update the PROGRAMMER field on the ASSIGNMENTS form?

Hello, I have a table of programmers (5 total), and a table of problem tickets (ASSIGNMENTS). I would like to automatically assign problem tickets to the next programmer in line when a new problem ticket is created. I know this is probably easy, but I can't put it together. Here is what I...

This helped me out and works perfectly. I have added tons of other stuff to the code to process the recordset. You got me on the right track. Thanks a million!!!

Hey, thanks Richard. I am going to add this code to my database and see how it works. I'll let you know. Thanks again for the assistance!

Thanks Richard, This looks like it will probably work, but I also need the basic code to read and update records. Sorry, I know what I want to do, but just how to do it is the problem. I am a cobol programmer, not much VBA. I know it sounds simple, but how do I declare a recordset, read and...

Hello, I am trying to find some simple code to update all records in a recordset in an access database. In this case, the recordset will be a query. Since the search engine is down, I was wondering if anyone could help. I will pseudo code what I want to do: 'project management database...

I am looking for this exactly, although I am not the original poster.

Well, it seems you are right Kyle. When I tried the first set of code again and used a good email address, it worked fine. Thanks! I still am wondering how to change the sender email address or if this is possible.

The email address comes from a field on the form in my Access database. The code to send the email is behind a button. I used the following code with the same email address and it works: Private Sub SENDEMAIL_Click() '****begin code**** Dim ORIGIN, DESTINATION, SENDTO, SUBJECT, MESSAGE As...

I am trying to use SendObject to send email from Access 2000, using Netscape 7.1. I have the following code: '****begin code**** Private Sub SENDEMAIL_Click() Dim ORIGIN, DESTINATION, SENDTO, SUBJECT, MESSAGE As String ORIGIN = "ebay2628@yahoo.com" DESTINATION = [EMAIL ADDRESS]...

Hello, I posted this in another thread, but no response. I am hoping someone here can help. I am trying to use Outlook to send mail. I am using the following code: '******begin code***** Dim strEmail, strBody As String Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem...

Hello again, I am now trying to use Outlook to send mail. I am using the following code: '******begin code***** Dim strEmail, strBody As String Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem '**creates an instance of Outlook Set objOutlook =...