Search results

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

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

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.