Recent content by Irish_Griffin

Robert, Thanks for the code, but I had to modify it slightly (at least for Groupwise 7.0 ) It wasn't adding a recipient, thus it throws an error when it tries to send. I modified as shown below and it works GREAT!!! So BIG THANKS For others reference: With objMessage .Subject =...

codes in after update event column(0-4) are strings (5 total) no blank fields [part_subform] is the name of the form and the name of the subform control .............. what should be in the control source of the combo box?

Not following you here...... my combo box does not have an onUpdate Event (2003) after update before update on change I tried the follow code: Dim test As String test = Forms![main_form]![Part_Subform]![Combo119].Column(4).Value MsgBox (test)no worky =-(

cool, I think I can make this work =-)

Here is a clearer way to state the question: How do I pull multiple field values after a selection occurs on a combo box. Example: Qry fields: 1 A # 2 B $ 3 C % Combo box lists 1,2,3 User selects "1" VBA code results: variable1 = "1" variable2 = "A" variable3 = "#"

Hi All, I've got a challenge for you, well at least it's a challenge for me :p now I just need to explain it clearly..... subform pulls from qry#1 -> subform.txtbox value is used to filter qry#2 -> qry#2 is the row source for my combo box When I select from the combo box, I want multiple...

ok I now know the problem...... search_results_qry is a "summing/ group by" query for search_qry search_qry has 6 fields with criteria pulling from a form: Like "*" & [Forms].[Search_Subform].[txt_ecLead] & "*" My goal is to take search_results_qry [ecID] a b c and create a string...

References Checked: VBA M.Access 11.0 Microsoft DAO 3.6 OLE Automation Micrsoft ADO 2.1

I'm getting: Run-time error '3601': Too few parameters. Expected 6. From the following attempt: Thanks, Aaron

Great!! Thanks!

Hi everyone, Hopefully this one is easy, failed on searching because I don't think I know the terminology: I need a query the takes this example table: Field1 | Field2 A | 2 B | X A | 3 A | X C | 1 C | 2...

WOOT!!! :D Sub Change_DataType() Dim dbs As Database Set dbs = CurrentDb dbs.Execute "ALTER TABLE Buyers_Guide_and_Part_Master " _ & "ALTER COLUMN VNDR_CODE number;" dbs.Close End Sub THANK YOU!!! I hate getting blocked with code I can't figure out...

This could do it with an extra step..... but I'm looking for some code that can replace going into the table design and change the field data type from text to number..... There has got to be some simple code to do this.... Everything I found online hasn't worked. Thanks for the response. I...

Function Convert_Text() Dim db As DAO.Database Dim tbldef As DAO.TableDef Dim fld As DAO.Field Set db = CurrentDb() Set tbldef = db.TableDefs("Buyers_Guide_and_Part_Master") Set fld = tbldef.Fields("VNDR_CODE") fld.Type = dbInteger tbldef.Fields.Refresh Set db = Nothing Set fld = Nothing...

Hey Guys, New here and hoping I found a place to stay to help and get help for VBA. Heres my question: I have a table that imports with a column that is a text field. To use the table the data type of this column needs to be "number". What I have found is I can use ALTER TABLE or DOA...