Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MoonMullen
  • Content: Threads
  • Order by date
  1. MoonMullen

    Binary format within a text file

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

    Why can I not delete a temporary table?

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

    Acesss Space Issue

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

    Question about Access2000...

    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]
  5. MoonMullen

    Why does Excel Calculate not complete?

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

    Out of string space (Error 14)

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

    Accessing Workbook Properities Without Opening

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

    Novell Effect On It's Clients

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

    ODBC.XLA Info

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

    Excel Odd Opening

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

    DLL for sending a pop-up message

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

    Parsing On The Fly

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

    Query a database w/o MS-Query

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

    LF vs. CRLF of a CSV

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

    Javascript from within Excel

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

    Table Deleting Through VBA

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

Part and Inventory Search

Back
Top