Search results

Hello, I'm trying to extract data out of Microsoft Project using the MS Project object within MS Access. Can anyone offer some suggestions as to how to do this? Basically I'm trying to take the data and insert into a SQL DB. Thanks in advance for your assistance!!

Within our corporate environment, I've been asked to automate the process of updating the distribution lists that are apart of our Global Address List within MS Exchange. I've written code to display the members of a distribution list within our Global Address List. I can't figure out how to...

I've written code to export data from Access into an Excel spreadsheet. I have everything working except one part. Within 1 of the worksheets, I've created a chart. Using VBA, I've added a text box to the chart. I can't figure out how to place a formula within the text box. Here's the code I...

I've written this code in Access to create a pivot chart in Excel. All the code listed is good except for the last line. The last line creates another instance of Excel. I can't figure out what the correct syntax is. I've tried, charts, worksheets, everything I can think of, and I can't figure...

I can't figure out how to get the subform requeried. With the attached DB, these are the instructions. 1. Open form frm_Menu_Reports_Variance 2. Select the command button Position Management Changes 3. For the Search Option, select Position ID 4. For the Position ID combo box, select any number...

Hello, I'm trying to use DAO to update within the table properties, the description. This is what I have so far. I haven't tried to run any of this code. Function ModifyTablePropertyDescription(strArchiveTable As String, strTableDescription As String) Dim db As DAO.Database Dim tdf As...

This is a weird problem. Attached is an excel spreadsheet that when you use the default import process is Access 2010, it produces an error file which states truncated record. Within the spreadsheet, this error happens with column "CL." If you remove all the columns before "CL" then save the...

Here is my code within the keydown event in a textbox named GUTS If KeyCode = vbKeyReturn Then KeyCode = 0 ElseIf KeyCode = "9" Then If IsNull(Me.GUTS) Then MsgBox "You must enter something within this field" KeyCode = 0 End If End If...

A requirement of my current db is that when the user reaches the last text box on the form, they need to press the enter key. How do I code it so after they've entered some data, if they press any key other than the return key, it stops all the other events within this text box and it resets the...

On a form I have 10 option buttons. Named option1, option2, option3.. If I create a recordset which the contains the option buttons I would like set to true, what is the sytax for setting that option button to true? An example, if my recordset returns the following: option3 option7 option9...

Is their any way to determine if the user pressed the "tab" key or the "enter" key? I'd like to preform different events after determining which keystroke the user performed.

I import information pertaining to a shipment. I have to calculate the driving distance between 2 zip codes. Currently I go to mapquest, enter the two zip codes, then paste the distance within my DB. I've looked at applications that calculate the distance, but they do not calculate driving...

I have Access2010 sending out emails for me. Here is the code I'm using 'Text of Body msg = saluation msg = msg & Chr$(13) & Chr$(13) & "Thank you for giving Safe Car Auto Transport the opportunity to assist you with your shipping needs!!" msg = msg & Chr$(13) & Chr$(13) & "Attached is the...

Dim objAccount As Outlook.Account Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.mailitem 'Determine the correct account For Each objAccount In Outlook.Application.Session.Accounts If objAccount = "Dispatch - Safecarautotransport.com" Then 'Create the Outlook session. Set...

Hello, I'm trying to link emails within Outlook 2010 into an Access 2010 DB. After selecting the Inbox to be linked, I receive the following message, Microsoft Access can't find the wizard. This wizard has not been installed, or there is an incorrect setting in the Windows Registry, or this...

I've recently split a DB. I've attached two db's to show my problem. First use TestDBGood Within tbl Export New IPG Customers, their exists 44 new customers. These customers need to be inserted into individual tables based on the field "Acct Type". Within form frm Import Data, here is what my...

I'm creating a form that contains a combo box using an ODBC connected table that contains purchase orders. The user selects the desired purchase order. Once the purchase order is selected, I need to display the purchase order items that are a part of this purchase order. The purchase order items...

I've installed both the AccessRuntime and the Service Pack 1. They both seemed to install without any errors, but I can't determine how to use it. Searching Google, I read a posting where once the DB is opened, selecting File, Save & Publish, I should see an option named Package & Distribute...

Hello, I have a command button on a form to go to the next record. If the current record is the EOF, the command will create a new record. What's the easiest way to display a message that their are no more records, and prevent a new record from being created.

Are you able to have 2 criterias in a DLookup statement? Here's the vital info: Expr: OnHandQty table name: ICPartWarehouse criteria: FKICPart = me.FKICPart and WarehouseNumber = 3 Here's what I have so far: =DLookUp("OnHandQty","ICPartWarehouse",????) Thanks for your assistance!!