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!!

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!

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 =...

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!

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...

Hi! I have a Combo Box in a form pulling values from a Lookup Table. If a user enters a new value, what code/macro do I use to add the new value to the Lookup Table? THANKS!!!!

I am building a very complex query for a report and I got this error message: "String returned by Builder is too long. Results will be truncated" Does anyone know what this means???? Is is the criteria or the fields in the query that is too long? Thanks!!!

after updating "Service Provider" in my main form, i need to update "Service Provider" in subform 1 and also update "Service Provider" in subform 2. i thought this code would work: Private Sub Service_Provider_AfterUpdate() Forms![Data Entry Form]![Service...

in the form properties i have allowed additions. when i open the form the new record button is all gray and cannot be pressed. this is a main form with a subform attached. any ideas? i wonder what is causing this! THANK YOU

if i need to do a make table query to a destination table in an outside database that is password protected, how do i tell the query what the password is so the table can be made? this is in microsoft access, by the way. thanks!!!

if i need to do a make table query to a destination table in an outside database that is password protected, how do i tell the query what the password is so the table can be made? thanks!!!

If I have a calculated field in a form, can this value be stored in the source table?? Thanks!

In a subform, the user needs to pick one field, Contract #. After the user picks the Contract # then a few fields related to the Contract # need to be populated. I did a D Look Up after the "after update" event. From what I hear, looking up on a subform is different from doing a D...