Search results for query: *

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]

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

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

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

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

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

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

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

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

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

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

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

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