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!

Register Log in
  • 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: *

  1. MoonMullen

    Convert PDF file to text

    If you're starting from Excel you can control the Word object have VBA open the PDF. Once in Word you can save the document in numerous file formats.
  2. 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...
  3. 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...
  4. 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...
  5. 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]
  6. MoonMullen

    How to call windows explorer from a macro in excel

    cesar_soto - What I have done is as follows; ' Sub RunExplorer() Dim RetVal As Double RetVal = Shell("C:\WINDOWS\EXPLORER.EXE /n,/e,C:\", 1) End Sub I am currently running Excel97. You would have to find out where your EXPLORER.EXE program is on your hard drive and...
  7. 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...
  8. MoonMullen

    Out of string space (Error 14)

    Thanks llocklin, but from my first note I am trying to code in an Access module. The problem is that I need to hold one record that is greater than what a variable length string can hold. Are there any variables that are bigger than a variable length string? (:I
  9. MoonMullen

    Out of string space (Error 14)

    It sounds like a good idea, but I do not want to leave Access and open Excel to parse this file. I guess I could remotely open Excel from within Access, DDE or is it OLE, however that seems to be a complicated process. (:I
  10. 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...
  11. MoonMullen

    Novell Effect On It's Clients

    My Operating System is Windows 4.00.950 B. I am running BarClock, Excel, Internet Explorer, Explorer, a 3270 Emulation program called Extra! and Access. Am I really that weak with RAM? I can run all the above programs at anytime but, not at the beginning of the month. On the first week of a...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. MoonMullen

    Parsing On The Fly

    MichealRed, thank you for your explanation. However I meant to ask, why is there a difference between how one codes varaiables in MS-Excel VBA and MS-Access VBA. My second example is the same as the first when coded in MS-Excel. All varaibles are "known" as string. I did not...
  17. 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...
  18. MoonMullen

    I know nothing about Novell or dll,

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

    Parsing On The Fly

    Does it matter to code variables as, Dim Variable1 As String Dim Variable2 As String Dim Variable3 As String or Dim Variable1, Variable2, Variable3 As String?(:I
  20. MoonMullen

    Parsing On The Fly

    I understand eveything that was said so far, however how do you create a routine that will link a variable to a record within a table? It is the guts of what gwinn7 said as, "Public Function ProcessStringToDatabase(strIn as String) ' Parse your string and update database. End...

Part and Inventory Search

Back
Top