Search results for query: *

Hi, I want to update an Access table from data in an Oracle table using a Pass through query. When I try to run the query in SQL view it errors out. Is "UPDATE" not possible in the Pass Through Query? Thanks!!

thanks all!!

hi, i have a form that needs to be gray if a check box has been checked. i am getting errors with this code: Private Sub Form_Current() If CheckBox = true Then form.backcolor = 12632256 End If End Sub THANKS!!!!!!!!!!!!!!!

Hi, If my check box named "CheckBoxStep3" is checked I do NOT want edits allowed on the form. If the check box "CheckBoxStep3" is not checked then edits are allowed. My code is not working! Please help...thanks! Private Sub Form_Current() If Me.CheckBoxStep3 = True Then Me.AllowEdits...

hi, has anyone tried to extract email addresses from email messages in outlook? i have tried vb code in the vb window in outlook, but all has failed.. thanks!

hi, i am trying to run a query in ms access. i am querying a linked oracle table/view...and i keep getting timed out. does anyone know how to change the settings in access to change the time out time limitation...or are there any other ways around this? thanks!!

can pass through queries only be written in sql?? i am trying to run a pass through query via the docmd. function in an event procedure.. thanks!

hi, i want to find duplicate records in a table. i want to keep one unique record and delete the duplicates... i tried running a delete query, but the query deletes all of the records and does not keep one unique record... and ideas? thanks!

i get on error on the fist line.. Email_Output_Option "Compile error: method or data member not found" thanks!

Does this code look correct? 'Send Auto Response Emails to each Requestor Select Case Me.Email_Output_Option Case 1 Dim mess_body As String Dim rst As DAO.Recordset Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Set appOutLook =...

If I want to send the auto emails to all email addresses in a field in a table, and include a trackingID in the same table in addition to scripted text how do i add that to the code? I want to send unique emails to unique records, grouped by ProviderID, RequestorEmail & DateProcessed Included...

Appending records to a MS Access table named "TBL DAily Import" database from MS Excel using a keyboard shortcut... Fields: ProviderID ClickID CreditRequestReason Comments Can anyone help me with this code?? Thanks!

Hi! Does my code look correct for running Auto EMails from Access? Select Case Me.Email_Output_Option Case 1 Dim mess_body As String Dim rst As DAO.Recordset Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Set appOutLook =...

Ok, here is the code! Option Compare Database '------------------------------------------------------------ ' TEST_AUTO ' '------------------------------------------------------------ Function TEST_AUTO() On Error GoTo TEST_AUTO_Err DoCmd.SendObject acQuery, "Query2", "HTML(*.html)"...

i just wrote that in the macro...haven't done any coding. thanks

hi, i wanted to run the send object function to send an auto response email to multiple email recipients in a field of a table. how can i write this?? i already tried [TBL Daily Import Test]![RequestorEmail] in the "To" part of the macro.... Thanks!

HI! Does anyone know if Date/Time stamps from MS Outlook email meesages can be imported into MS Access? Would it be most efficient to use VB code? Thanks!

Here is what I tried... DoCmd.SendObject , "", "", "[TBL Daily Credit Requests]![F1]", "", "", "Your Credit Request Has Been Received by LowerMyBills.com", "Hi, Please allow 14 days to receive your credit. ", False,

HI, Yes I have checked it out... I jut need to know how to send the emails to all recipients in a field in the table I am importing since the recipients will change daily. Seems as though you can only type in a specific email address or name of a distribution list.... Anyone know how to do...

Hi, I want to import MS Excel spreadsheets to an MS Access db and send auto response emails to recipients listed in the spreadsheet. Any helpful tips? I am assuming: 1. import spreadsheet (with email recipients) 2. open data access page (with email text) 3. send object (to recipient on...