Search results

pbaldy, Thanks for your reply, i don't see how this code can help me. since I'm not using a form for anything.

Hello all, I am trying to send a report to different recipiants based off of their email address. This report would only show information pertaining to them and no one else. Does anyone have any idea how I can do this? I have tried using SendObject but as you know, it will send the entire...

Pbaldy, thanks for your reply. What about referencing a different recordset. When I am using: Set rst1 = CurrentDb.OpenRecordset(sql, dbOpenDynaset) sql = "select qrytest.[account_number],qrytest.[bi71_admin_officer_email] " sql = sql + "from qrytest " sql = sql + "where...

I'm trying to take this a step further.........by excluding information that does't match the user's email address. I created a new recordset that is being fed by a SQL. When I try to put "rst1!sql" I am getting an error message that is stating that "Item not found in this selection" or "Object...

Pbaldy..........thanks for your help.....your suggestion worked.

I am trying to use the sendobject function to send emails. I am able to send the beginning record through email, but when I tell it to move to the next record, I still get the beginning record. Here is some code that I am working on. I tried writing a SQL statement to reference the "TO" field...

Thanks Ted for the reply, I do have MS outlook 11.0 Object Library referenced. I should have stated that earlier. Thanks

I am trying to send an email reminder to outlook from a command button. I found this code on the forums, but I am getting a "Method or Data member not found" error message. Here is the code that I am using: Dim objOutlook As Application Dim objAppt As Object Set objOutlook =...

I am using a linked Excel sheet that has formulas linked to fields in Access. Some of my cells (formulas) don't have any information that is being auto populated, therefore empty; however, Access is reading the cells and giving an error message "Numeric Overflow". Does anyone have a solution...

I have table "XYZ" that I need to pull random account numbers from. Has anyone done something like this before? Thanks for your help.

I have some data that I am trying to extract. I basically need the following If an Account Number has multiple transactions, I only want those listed. Example Table Account NumberField TransactionField 1234567891 Transaction1 1234567891 Transaction2...

I used the code, but it didn't place the field names into the table. Thanks

Have all variables goto the table after the list refreshes. Thanks for your help.

Thanks for your help; However, I am getting an object variable not set error when adding this code. Here is what I have: Private Sub Combo1_AfterUpdate() Dim db As DAO.Database Dim fld As DAO.Field Dim strTable As String Set db = CurrentDb() strTable = Me!Combo1 For Each fld In...

That makes sense, however, since I am passing the information through vba, when I implement that particular piece of code (table.field=mylistbox; I even tried writing a sql statment) it is telling me "Invalid use of Null--Object Required" where mylistbox is null. It's like it isn't reading the...

No, my form and listbox is unbound.

How can I get my list box values to a table? I am using the list box "Row Source Type" as a "Value List" that is being passed information from code. I need to take the information that is selected from this list box and transfer it to my table1. Any thoughts?

I have some code that tells me the table and the field names of a linked table. However, using debug.print only puts the information in my immediate window. How can I have this go to a different table? Here is the code: Dim db As Database Dim tbl As TableDef Dim Fld As Field Set db =...

I need to capture the field names from a linked table and copy them into an excel spreadsheet. Does anyone have an idea how I can accomplish this? Thanks.

Thanks for all your help.