Search results

I created a new Data Source within Administrative Tools (in the Control Panel) and configured it how I needed, therefore, I'm able to bypass the login screen. However, I'd still be interested to know the code. Thanks.

I have tried the following code and get a compile error: Option Compare Database Option Explicit Public Function ODBCConnection() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim cmd As ADODB.Command Dim sCN As String Set cn = New ADODB.Connection Set cmd =...

I use Access 2007 and have been searching for the steps/procedures in vba code to bypass the login screen for a DSN connection. I've been able to find different parts but can't make sense of it when attempting to piece it together. I have several linked tables to the DSN connection (local)...

Thanks - After more digging, I realized I could do it via a module: Sub RunExcelMacro() Dim xl As Object 'Step 1: Start Excel, then open the target workbook. Set xl = CreateObject("Excel.Application") xl.Workbooks.Open ("C:\Documents and Settings\nel58556\My Documents\Net Improvement...

THANK YOU!!! Had I thought about it as similar to Excel VBA, I probably would have figured it out but, as it was, my head was ready to explode. The revised code is below and works perfectly! Option Compare Database Sub RunExcelMacro() Dim xl As Object 'Step 1: Start Excel, then open the...

I am a newbie when it comes to using VBA code in an Access module. I am attempting to run a macro in Excel 2007 via a module in Access 2007. I found some code but I am getting "Compile error: Expected: line number or label or statement or end of statement". When I close the message box, the...

I'm wondering if it is possible to delete an existing Excel file via a Macro (in Access 2007) Action and, if so, how? Thanks in Advance! Sara

I don't know why the error message and IIF expression are not matching but the same message keeps showing up regardless of how I change the expression. I have the "Total" line selected to "Expression", not "Group By". I've attached the entire SQL statement. SELECT [MASTER LIST...

I am creating a Make Table Query and calculating new fields based on current and prior year-end numbers. If the prior year-end number does not exist (Is Null), I want the use the current rate or calculate the change in rate. I have typed the below in the Field Box: CHG_IN_PGM_RATE...

SOLVED: Re: Type Conversion Failure After working on my issue most of the afternoon, I solved it but wanted to share with whomever might be encountering the same issue. The revised expression is as follows: PTD_CM_PGM_RATE...

I have created a make table query and using expressions for two of the fields. I have set the field properties (format) to "Percent". The expressions are calculating rates based on two other fields. The expressions are currently as such: PTD_CM_PGM_RATE...

My name is Sara and I am from the Midwest part of the US. I've been working with Access but always seem to run into my share of errors. I'll be posting a question shortly and hopefully there's someone out there that will be able to provide me an answer. Thanks in advance.