I have end-users who download reports from a mainframe that need to be in text format, however the files sometimes come down in binary format. The file is named with the txt extension. My Excel addin, using VBA code, then translates that text file into a workbook. How can I do a quick check on...
I am using Access 2000 on a Win2000 PC. I am loading new data from a text file. I create a temporary table to hold the new data. I append the temp table to a permanent table within the same database. I want to now "clean up" and delete any queries and temporary tables. I can...
I know that when you build an Access database and create and then delete object (like queries or tables) you need to compact the database form time to time. Is there a function out there that will tell me how much disk space is "really" being used by the database versus what is being...
Is Access2000 tranactional? Can it handle numerous, from 3 to 30, users in the database at the same time? They would all be updating a central table with text information. [smarty]
Why does Excel Calculate not complete? I have a workbook that has many worksheets, some graphs and many modules within it. When I set Calculation to manual and back to AutoCalculate the calculation process nevers quite completes entirely. It counts up to about 75% and then stops. What would...
I am trying to read in a record that is very large. Access "sees" the file as one record, while Excel "sees" the file as 57,834 records, or rows. I realize I am exceeding the limit that a string variable can hold. Is there anyway to use a variable greater than a...
Is there a way, through VBA, to access Excel workbook properties without opening the workbook first? If I go into Explorer, I can see the "Author or Title or Subject" information without opening up the file. Can I reproduce this information from within Excel's VBA? I would greatly...
Can a Novell network have an affect on its client running multiple software at the same time? I work in a Novell 4.11 network environment and find that at the beginning of each month, when all clients are pounding the network, that my laptop's performance decreases in a big way. The...
Does anybody know where I can any information on how to use the ODBC add-in file? A working procedure would be great, yet I am willing to get anything I can find. MS Knowledge Base search did not give me any hits back. I want to run some queries against an Access database and have the result...
I have a workbook that when I open it the "macro virus protection" dialog box opens. I have deleted all modules and made sure that there are no procedures on any worksheets within the workbook. There are no procedures on the ThisWorkbook object either. I closed and saved the...
In the Novell 4.11 environment, what would be the DLL for sending a pop-up message to another user within the network? I want to create a little program to replace WinPopUp.exe that we use here. I just need the "behavior" of the DLL and, it's name with all parameters, that is used to...
In MS-Access97, can you parse a text file with VBA code one line at a time? I mean read part of a line, say first 15 characters, then parse that into five fields and create the first record in a table. Then repeat the whole process for as many times as is needed. I currently read the text...
Is there a way to write SQL, to query a database, address through ODBC, without using MS-Query? I know it can be done. I saw it once before however, I lost that chunk of code. Please help me out??(:I
I have a CSV text file, created by javascript query, that Access does not "see" the LF however Excel can "see" the new line fine. Through VBA code I'm having Access read in the file and then write out with CRLF to each line. I then have to bring it back in for parsing and...
Can java script be run from Excel without using the browser? I currently run O/S of Windows95 and Excel97. I want to "bounce" a query off an Internet server using the javascript that I got from their web site. It would make life alot easier have the result "piped" right...
I have written a subprocedure that formats a text file externally and then imports the text file into Access. I run a few queries against this "working table" and then copy the newly format data to another table for permenant storage. The code abends when I try to delete the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.