Search results for query: *

I created a function within Excel VBA called FindNext(). When I enter "=FindNext()" into each individual cell, I get the desired results. However, if I enter "=FindNext()" into one cell and then drag the formula down a column, the column is populated with the first correct result, all the way...

Greetings. I am getting a peculiar error (in my simple mind) sporatically with some code. I am attempting to take an Excel report, via Access VBA and format it according to a customer's specifications. The code seems to work fine when Excel is not open previously, but if the user has an Excel...

Hi all, hopefully this is an easy question, seems like it should be but I don't know the answer! [ponder] I have some Access code which opens an Excel doc (referenced in a text box on a form) and imports the document into a new table. Easy enough. I don't need or want to see the Excel...

Hi all, I am working on an Access database for a customer. There is a main form where the user selects a location of a file, clicks a button and the file is imported into a table in the database. This file has extension .xls. So, I used the following code to import it...

Does anybody know what the file Y!Msgr\merlin.log.old is? How is it created/updated? There is also another file in the same directory simply named "merlin". I do not use Yahoo Messenger so does this mean somebody else was using my PC and installed the program onto it? I do not see any program...

Hi all, I am importing an Excel spreadsheet into Access and need to make basic calculations on some date fields. Seems easy enough, but some of the formatting gets lost when I import from Excel to Access and I'm not sure how to keep it how I'd like. The date fields in Excel are formatted like...

I am attempting to import a series of text files programmically into a single table in Access 2007. The text files are semicolon delimited. The first line contains the field names but does not have any text qualifiers. I receive the error "Field: 'DriverNum;DriverName;CapacityType;' doesn't...

I am attempting to requery all the controls on my form, without having to explicitly name all 193 of them. I have tried the following code: Private Sub cboRegion_AfterUpdate() For a = 0 To (Forms!frmMain.Controls.Count - 1) Forms!frmMain.Controls(a).Requery Next End Sub but get the...

Hi all, I am experiencing a bizarre problem that could be a symptom of my ignorance in using Excel VBA. I recently developed an Excel app that uses different functions and constants that I have saved in the VBA under "Module1". The business users requested some modifications, so I opened the...

Hi all, A colleague posed a question to me regarding macros. I told him what I thought, but I am by no means an expert on macros (I never use them). He has inherited an Access database which is chock full of forms, controls and other cute GUI stuff. There are also a bunch of macros. He asked...

Hi all, I have been given a task to update an Excel form with some new information for the coming year, including adding a few controls based on new requirements. The person who designed this Excel app is no longer with the company. None of the spreadsheets are protected as far as I can tell...

Hi all, I am connecting via ADODB to an Oracle table and need to select records where a particular field is between two dates. This field is of type adDBTimeStamp and I am struggling to find the right syntax to filter on this field. I have tried: "WHERE LD_DIM.SHP_ARV_DTTM> #05/21/2007 0:00:00...

I am trying to convert data from a crosstab type format into columns. I believe I am on the right track and have found a previous Tek-Tips thread that got me about halfway there, but I'm stuck. Here is what I am trying to do: Current format: 1 2 3 4 5 23 b 325 2 56 7 4 x c 46346 5364563 4 4...

Hi all, I have created an import specification in order to import a text file to an Access table. I need to add three additional fields to the specification. I go to File | Get External Data | Import and then select the .txt file with the additional fields. I click on the advanced button to...

I am trying to copy an Excel worksheet from one workbook into another through Access VBA. I have the file name set in a variable called txtReportFile. I am getting a "type mismatch error" in the following line: Sheets("Key-Factors").Copy Before:=Workbooks(txtReportFile).Sheets(1) It works...

Hello - I have run into a situation which is triggering run-time error 2790, stating that I cannot embed an OLE object if the OLETypeAllowed is set to Linked. Here is my code which I am clearly setting the type to "Embedded": oleChart.OLETypeAllowed = OLE_EMBEDDED oleChart.Class = "jpegfile"...

After I run a report, I go to File, Save As: and attempt to save the data as .csv with no success. The status bar increments up to around row 700 and then it hangs indefinitely. I have tried saving as a .txt as well. I know it is not a space issue. This is the only report that causes this...

I've seen postings on how to convert a word .doc file into a .tif file, is there a way to take a .tif and make it viewable in Word? Somebody has received a fax in .tif format and needs to save the file as a Word doc. I've tried renaming the file and opening with Word, but no matter what I...

I apologize as this might not be the best board for this question, but I couldn't find one more appropriate. This afternoon I had an incident with my leader which has left me asking what to do next. I am the manager of a small reporting team for a company which has several reporting teams...

Forgive me for the novice question but this is my first time trying to create a hotfile from an Impromptu report using a macro. I am getting an error "Unknown function: ErrHandler" and then another one "Label 'ErrHandler' is missing" I'm assuming this is an obvious fix so could anyone offer a...