Search results for query: *

The thread you listed went to an issue with exporting from Access. What was the thread dealing with the recordset method of importing text files into Excel on separate sheets?

I'm exporting 10 tab-delimited text files from an Access db and trying to get these 10 files auto imported into one Excel workbook -- each file on a different sheet. I've tried doing this a couple different ways -- using some ADO recordset code online that didn't work and then trying the...

Yes, just looking for the type-ahead functionality. thanks a lot for the help! This will get me where I need to go...just thought it might be simpler to do.

I have a page linked to a database query where users lookup the group number they want. Most of the group numbers begin with "00". When a user types in "00" it's fine but when they type in a "7" as the next number in the group number, like "00779", it takes them to the first number beginning...

I figured it out myself after doing a few searches. Cannot use the Docmd.Transferspreadsheet command only -- have to do this and then insert extra rows for my headers. Code is like this: 'Delete the previous Excel file if it exists Dim KillFile As String KillFile = strPath 'Check that file...

Not sure what you're meaning? I'm trying to export the data from Access to Excel but give the data a header or two. Do you mean to export the data using the menu options instead of code?

If I'm not able to use the TransferSpreadsheet method to output data starting at a specific point in an Excel sheet does anyone know how to dump an Access table into an Excel sheet starting at a specific cell?

I'm trying to output some text into an Excel file from Access and then export table data right below it. When I do this the text is written but it gives this error when trying to export the table data: run-time error 3010 Table 'PATIENT_IND_CLAIM_LEDGER$A3:AZ99' already exists This is my...

I was able to change a couple settings in the IIS manager and take off some of the authentication and I can now access my pages from my own computer on the network by typing in that server's IP address. If I use the IP address of the server (it's running IIS) then my default page comes right...

Sorry but I'm new to this and have tried everything I can think of to get this to work... I'm running IIS 5.0 on a W2K server. I named my default website "INTRANET" and it is started. I put a default.asp file in c:\Inetpub\wwwroot\ folder. I'm trying to first pull that asp file up and I've...

Thanks for the info on using the drive utility software. I was able to dig some up and tried using it but still did not work. I'm just going to buy another drive and start over. This was a Maxtor (have had a lot of trouble with Maxtors) - never buy a Maxtor! Western Digital isn't too bad but...

My hard drive crashed today and now when I try to boot from it it says 'hard disk failed'. I desperately need the data from this drive but I don't know what to do, if anything, to get it back now. I tried putting the drive, as a slave, into another computer and restarting it. When it came up...

Thanks a lot for your help! Your suggestion worked!

I'm asking a user what filename they're wanting to work with then wanting C++ to issue a system command like it was being run from the command prompt. This should be simple enough but can't seem to get it right. Here's some code I have: string FileName; cout<<"What is the file you want to...

Not really any code just this: In Access: Docmd.RunMacro(&quot;reformat file&quot;) (The macro is 'runapp' with the command line of: c:\reformat.bat) Batch file: cd .. copy c:\iecon.txt g:\ie.txt exit Any suggestions?

I don't understand this one at all. I have a program on a person's computer where I do a 'runapp' with a macro to execute a batch file under the person's C drive. It doesn't run the batch file doing this. The batch file does work because I manually clicked it and it runs fine. I've also...

I found out the problem...it was the nic driver. It wasn't already loaded so I loaded it manually and added the server to the domain. thanks for help!

Hello, I'm trying to add a Windows 2000 server just as a member server (not making it a domain controller, etc.) to my NT4 Domain. When I installed the 2000 server CD I formatted a partition and loaded the OS on it. When it restarted, it ran through its 'Regional Settings', setting up my...

I'm not doing an application.quit or running any macros..I'm not quitting the app in any way. Here's some of the code: Dim db As Database Dim rst1 As Recordset Set db = CurrentDb Set rst1 = db.OpenRecordset(&quot;RATES1 - Monthly Costs Summary&quot;) Dim dc As Database Dim rst2 As Recordset...

I have a form where I press a button with code behind it. The code simply imports data from an excel sheet into some different tables using DAO. I do an openrecordset on a table and at the end of the code I close the recordset and set both equal to nothing. When I press this button usually it...