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've been appropriately slapped on the hand. I did a cut / paste without thinking. Sorry about that. Thanks for the response. Skip - I don't have any control over the tables in this app. This is a package from another company - so I'm working with what I've got. Appreciate your opinion...

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

dhookom - Good thought. I checked. I did use UNION ALL. I think Andrzejek is onto something when he states to check the Select part of my statement. I now know that the UNION query is not the issue. I tried appending one of the 2 queries that comprise the UNION and still have the same issue. The...

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

Duane - I was trying to change the columns heading property. What I did not realize is that you do it through the SQL code. That looks like the solution to me. Thanks so much for your help. Mark

Thanks Duane. But if I understand you correctly ... I am not trying to alias the PeriodRpt values but ensure that all required values exist. For example, assume the entire tblTemp_Rpt_Consolidate contained periods: 2015-2020 This particular selection (using the Where clause) only contains...

Here is the sql TRANSFORM Sum(tblTemp_Rpt_Consolidate.ConvertedAmount_a) AS SumOfConvertedAmount_a SELECT tblTemp_Rpt_Consolidate.Account, tblTemp_Rpt_Consolidate.AccountName AS [Account Name] FROM tblTemp_Rpt_Consolidate WHERE...

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

Thanks everyone for your help. I finally worked out a solution to preventing the deletion of worksheets in a non-protected workbook. You would use this when the workbook has some “required” worksheets (cannot be deleted) but other worksheets can be added or deleted. After I developed this...

Let me provide a more comprehensive explanation of my application. My client has asked me to build a standardized goal setting system for marketing and sales personnel. It sets out goals and then measures performance against the goals. The simplest workbook is comprised of an Administrative...

Zelgar - Thanks. I hope you can prove me wrong. But with my application, I wish to protect certain worksheets from deletion but want users to be able to add other worksheets. Without getting into a lot of extra programming (like removing menus and adding customized buttons to do all this), I...

Thanks. Sounds promising.

Nah - this approach does not work because the Copy itself creates a SheetDeactivate event which causes an endless loop. i.e. Move to new sheet starts SheetDeactivate. The idea was to have sheetDeactivate event create a copy of the worksheet. But the act of copying the worksheet causes focus...

Thanks for checking this out. So my idea to handle this is to use the SheetDeactivate and SheetActivate events. On a SheetDeactivate, I can create a temp copy of the worksheet and count the number of worksheets. On SheetActivate, take another count. If the count has decreased, I know that...

Maybe I'm blind but I do not see it (I attached an image of my screen). I see: SheetBeforeDoubleClick SheetBeforeRightClick and those are the only SheetBefore... events I see. I tried it anyway but it did not fire...

Thanks. Are you running Excel 2013? I don't see this in Excel 2010.

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

Strongm - Thanks for your response (sorry for the my delayed response -- but it is summer). Anyway - given your comment that I am not mixing early and late binding, do you have any thoughts why my code is not closing the hidden instance of excel? Thanks. Mark