Search results for query: *

I have an Access application where some users may require integration with QuickBooks and others do not use that feature. QuickBooks has a dll library for some of the vba programming statements. The issue is that if the user does not have QuickBooks installed, the dll does not exist so the...

I need some advice on the best way to solve this issue – whether it makes sense to address it with a query or better to write a vba function. I have a table with orders and requested delivery dates. Assume that all orders are for the same item number. An order can have multiple delivery...

I have a union query that returns about 100,000 records. The query runs in about 20 seconds - I don't have a problem with this performance. But when I create another query that simply reads the records returned by the union query and appends them to an empty temporary table (which will be used...

I have a form that uses an unbound combobox to select the record displayed. The user box selects a ProjectID and the form shows information about the project. This form has a recordsource that uses a query based on a single table. My code here is working fine. When I attempt to open the form...

Hi I am trying to set the Column Headings parameters of a crosstab query via VBA. I cannot seem to find the syntax to do it. I thought it would be something like: CurrentDB.QueryDefs("qryName").Properties("Column Names") = sColumnText But I don't think "Column Names" is the correct way to...

I am running Excel 2010. I have an application that allows the user to add worksheets so I cannot turn on Workbook Structure protection. Yet there are some worksheets in the application that I do not want the user to delete. If there was a Before Delete Worksheet event, I could check the name...

I use the following code to determine if there is a hidden instance of Excel running. I first determine if there is an active Excel instance. If so, I then determine if the instance is hidden. If I identify that there is an active hidden instance of Excel (this function returns a value of 2)...

I have a label control on an Access form. On the Load Event for this form, I add a HyperlinkAddress to the label control which creates a link to the specific word document. I do this using the code: Me.lblHyperlink_AllocRules.HyperlinkAddress = sDocFile where sDocFile is the...

I am adding a worksheet to an existing workbook from Access. But when I run this procedure and close Excel through the vba code, an instance of Excel is still running if I look at the task manager processes. I realize that this probably has something to do with how automation based variables...

I have an application that opens excel, reads some data and then closes excel. For one specific user, when the code opens Excel, Excel crashes with the message "Microsoft Excel has stopped working". Any thoughts on where to look to analyze this issue? Here is the code I use to open / close...

I am attempting to programmatically change the CommandText (sql statement) for a pivot table. My code works if all pivot tables in the workbook have a unique ConnectionName. But if more than one pivot tables use the same ConnectionName, I get an error: Application defined or object defined...

This is an Excel VBA issue. I have a workbook with 5 pivot tables. There are 3 different Connection Names. I need to update the underlying queries which retrieve data from an Access database, using the Pivotcache.commandtext function. The queries I need to assign are different for each...

This is an Excel VBA Issue. I have an excel app that reads data and runs some complex queries in an Access DB and returns the data to Excel. I have a process that opens access. This runs everytime the user initiates a query from Excel. Set objAccess = GetObject(, "Access.Application") If...

I'm working on a database where the previous designer created a series of make table queries that create a table in "Another Database". I need to move the back end databases for development and testing purposes. To do that, I have a process that relinks all tables. But my process does not...

I have a simple function (see code) that reads through an entire table and adds a sequence number to each record. When this function is run on a local table, it works fine. But when it runs against a linked table, I get the error: "File share lock count exceeded. Increase MaxLocks per file...

I am using the Transferspreadsheet function to import excel worksheets into an access table. I am loading all the worksheets in a listbox and then read through the list box to import each worksheet into a temporary table, do some processing, and then move to the next worksheet and repeat. I...

I am developing an app and am the only user of this app. After weeks of development, all of a sudden, when I attempt to open a form in design mode, I get the error message: "You do not have exclusive access to the database at this time." Yesterday, to get around this issue, I took an earier...

I am attempting to use the docmd.transfertext command to export the contents of a table to a text file. I created the Export specification and it can be run successfully manually. But when I create the code for it, I get the following error: "The text file specification does not exist. You...

(I started this thread a few days ago, but now have more info regarding this issue). I create a number of excel workbooks that contain macros(xlsm) using Access vba code. I am running Office 2007. I want to hide excel during all the processing. The approach shown below worked in Office 2003...

I create a number of excel workbooks that contain macros(xlsm) using Access vba code. I am running Office 2007. I want to hide excel during all the processing. The approach shown below worked in Office 2003. I am using the command xlApp.visible = false (where xlApp is defined as...