Search results

How do you reference existing functions in excel? For example, if I try to create a function and use the existing function find() I get "Sub or Function not defined:confused: . Isn't this possible? I can use others like date(), now(), et.,..... Thanks is advance.

Using VBA... How do I test for a particular open form? Then If open, populate a field on that form. Actually, I don't even need to test if it's open. I just need to populate that field on the form. DoCmd.Forms!myform![field1] = 1000 I tried using me, but its outside of the form class and...

Is it possible to programatically change the name displayed before sending. For example, when the recipient receives the e-mail it displays from "XXX" as opposed to "YYY" set in outlook. I guess sort of like e-mail spoofing, but not really. It's just a displayed from change. Does that make...

What is the syntax to join 2 recordsets? Listed below are the recordsets that I am working with and now I would like to join them. Any insight would be appreciated. FYI, I did do a search on joining recordsets in VB, but I didn't come accross anything......Thanks again. Dim rs1 As...

Is there a command line option to run a function() in a database like /x to run a macro? Thanks in advance.

I have some code that updates the sql in an existing pass-thru query, my problem is when I attempt to run the query it prompts me for ODBC parameters. Any help would be appreciated. Dim db As DAO.Database Dim qdf As DAO.Querydef Dim strSQL as String Set db = CurrentDB Set qdf =...

If I automatically load a table daily, is there a way to create or maintain a table of the load statistics? For example: Date-----------File----------------------Records 9/5/2005----No File Found------------------0 9/6/2005----c:\winnt\temp\file1.xls--------100 Thanks in advance :)

I'm sure this has been asked before, so I'm looking for search hints: I would like to select query results displayed in a form, by check box, and add them to a table. The results displayed in the query are random and this poses a problem, at least for me anyway. :rolleyes: Any ideas? Thanks...

Is there a function to pass certificate information to a secure website while trying to fetch data? Not familiar with this topic at all, tried to search the topic and was unsuccessful. I am probably missing some key terms to conduct a successful search. Any help would be appreciated. Thanks...

I have used this code many times to find multiple files in a directory, but how do you look for a single file. My dilema, I have 2 files in a directory: File #1: filename.txt File #2: filename_date.txt If I use the .FileName = "filename.txt" it still returns both files???? Is there another...

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?

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

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

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)

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