Search results

Does anyone know of code that supresses warnings in excel by way of access. I'm looking for something like setwarnings=false in access. Specifically, I have some code in access that manipulates excel and in the process also deletes a few sheets in a workbook and I would like to supress the...

I found an example in this forum that led me to this example in the MS knowledge base (Article - 176391) and I tried to use it to close Express ClickYes app, but it doesn't work. Seem like the code freezes at line in red. If you manually close the app in the systray the code then resumes and...

Does anyone know of a function or code that will compare several date fields in a table and return the highest or max for each record. This is very easily accomplished in excel by using the Max(Date1,Date2,Date3, etc..) function, but this will not work in Access. I get an error stating that I...

I found this code while doing a search and since I'm not familiar with recordsets I am at a loss. I did some additional searches on recordsets and found lots of useful information,but none that entirely answered my questions. 1. I am trying to include the entire recordset or query in the body...

What happens when your tables start getting too big and your entire database starts approaching 2 Gigs, what's next?

Related Question If I store the module in a particular workbook, the function works. Why can't I store the module in PERSONAL.xls and have it available to all workbooks that I use? Let me clarify, I have already saved the module to PERSONAL.xls, but when I open a brand new workbook the...

Thanks. Thanks for the quick response. :D

I would like to use the following code in Excel, what changes have to be made for it to work? Thanks in advance. Public Function TestCharMatch1(NbrOfChars, StrSearch As String, strFind As String) As String 'Walks through strFind, NbrofChars at at time, and searches strSearch for a match...

I'm trying to figure it out Thanks Tony and Travis. I did view the two links and I am having difficulty determining the lpClassName$ and lpCaption$. I'll keep playing with the code and hopefully it will work, for me anyway. Are programs in the systray just as easy to find the handle? At...

Way over my head.....................Does this also work with programs that run in the system tray? The application that I am running is in the systray when launched. Isn't there a command that can find "anyapp.exe" and simply close it. Something like: to start app Call Shell...

Looking for a way to open an application, do some stuff :D , and then close this particular app. I can open it, do some stuff :D , but I can't close it. Please advise. Am I just way off or what? :rolleyes: ******************************************************** Sub APPTEST() Dim anyapp as...

Still runs very slow! I removed the multiply if statements and the problem seems to be isolated to calculating the work days. I ran it yesterday for 400K records and the query took over 8 hours to run. :confused: Any help would be greatly appreciated :D

Anybody out there??????? :confused: Could it be my PC, if code is OK? This query takes several hours to run. I didn't think that 300 to 400 K records is that big of a deal to analyze. Thanks again.

Need for speed - Aging Query I have a database that calculates the workdays between 2 dates and drops the result in the appropriate aging bucket, but it is very slow. The query is looking at around 300K+ records.......Any ideas to speed up the process would be appreciated. (See attached)

Express ClickYes I have had the same problems with Outlook myself until I found "Express ClickYes." Express ClickYes is a tiny program that sits in the taskbar and clicks the Yes button on behalf of you, when Outlook's Security Guard opens prompt dialog saying that a program is trying to...

Thanks to everyone for all your help. I have attached a copy of all of the coding submitted in a small db, just in case anyone else is interested in this subject and results. It looks like Billy's changes to the original code submitted by Newman did the trick. I have attempted to setup an...

Is there existing coding or functions that will compare two text strings in different fields for a match of a certain # of consecutive characters? For example, Field A 12WE34555 Field B 333FTY7812W If the function was set to find 3 consecutive characters that...