Search results for query: *

I have been using Excel for reporting from MS Access from some time...my "MO" has been as follows: Sub mike() Dim xlApp as New Excel.Application, xlWkb as Excel.Workbook set xlWkb=xlApp.Workbooks.Open(myPath & myFile) etc. etc. End Sub I need to know now, though, how to use an...

Is there a way to do this? So, a user clicks a button, and the command is issued for the computer to go to the designated file, zip it and copy it elsewhere (I can handle the "copy it elsewhere" part). Thanking you in advance, Mike K

This one is tough (for me). I have a batch file that makes registry setting changes. It changes the type of files that Excel changes to when you save a file (95 vs. 2000). For some reason, we cannot make that change manually from within Excel (Tools > Options > Transition). I think our admins...

Is there a way for a user to do this (when the user doesn't have Acrobat, just has Reader)?? Like via MS Word, Excel, etc.? Is it possible to edit a pdf file if you have Adobe Acrobat? If so, is it edit-friendly, or is it kind of like editing an HTML page, kind of ugly and all. Thanking you in...

I have a pop-up form that I want to grow and shrink, based on how many records are being displayed. The form is set to Continuous Forms. The form I am working with keeps wanting to pop up in the same size that it is while in design mode. The thing is, it is working in another application that I...

I am using a batch file in my startup folder to load programs whenever a user logs one. I have: usrmgr winfile Problem is, when it hits the first line, it loads that application, and then the dos command line screen just freezes, and the second application never loads. If I put the second line...

Using the dir function, I can obtain the list of files in a specified folder: sub myproc() dim mypath as string, myfile as string mypath="c:\" myfile=dir(mypath) do until myfile="" msgbox myfile myfile=dir loop end myproc What I am having a tortuous experience with is...

Can anyone tell me how to create, read, write to, etc. files in VB using the UNC, instead of the drive mappings? Currently, I do things like, sub mike() dim fso as new filesystemobject, ts as textstream set ts=fso.createtextfile("q:\temp.txt") ts.writeline "this is a test&quot...

This question is related to another post I just made, "Using batch file to map, unmap drives..." in that, I was have problems mapping and unmapping drives using IWshRunTimeLibrary.IWshNetwork, so I opted to use batch files. Then I hit a roadblock there, too. So we're back to...

I am using: sub mysub() dim fso as new filesystemobject, ts as textstream set ts=fso.createtextfile("c:\temp\temp.bat") ts.writeline "net use q: /delete" ts.close shell("c:\temp\temp.bat",vbhide) end sub The question is, how do you write a batch file so that it...

I have code that writes a batch file and then shells the file in: sub blahblah dim fso as new filesystemobject, ts as textstream set ts=fso.createtextfile("c:\temp\myfile.bat") ts.writeline "net use m: \\myserver\myshare" ts.close shell("c:\temp\myfile.bat",vbhide)...

I am creating an Excel Application object by: Dim xlApp as New Excel.Application, xlWkb as Excel.Workbook In my error handler I have: xlWkb.close false xlApp.quit When I step through the error handler, I watch the NT Task Manager. I notice that the xlApp.Quit code doesn't really do anything...

On my desktop Excel, I have an add-in that adds a command button to the menu bar. So, whenever I launch Excel, that command button is available. However, we have a website where you can load HTML pages on the screen into Excel, and when this option is selected, Excel is launched WITHIN the IE...

Does anyone know of a way to do this?? Thanking you in advance!!! Mike K

Is there a way to map a drive using VBA? Or do you just have to write a batch file and shell in the batch file from VBA? Thanking you in advance. Mike K

I've gone into the shrink database dialog box and adjusted the database size that way, but when I double-click on the database device, it's still the size that it was before. Can you tell me how to shrink the size of the device, not the database? Thanking you in advance. Mike K

Hello, I am getting the following error message when I try to run a command from MS Access using a SQL Server linked table. ODBC-call failed. [Microsoft][ODBC SQL Server Driver][SQL Server] can't allocate space for object 'Syslogs' in database 'mydb' because the 'logsegment' segment is full. If...

I'm using v6.5. I've never created a stored procedure before. When I bring up the Manage Stored Procedures dialog box, it says CREATE PROCEDURE <PROCEDURE NAME> AS. Can you tell me what do I do from here? Do I replace <PROCEDURE NAME> with my own new name (e.g.: MyFirstSP)?? Then what do I type...

I just created an index. What does it mean when it says Index Size: Actual Size(KB): 14628?? Does that mean that the index file is actually 14M?? I mean, I understand that if it's true; it's just hard for me to believe that the index for one field (it's a one-field index) is 14M. Thanks for your...

I have a query that looks like this: asofdt status no_each 1/31/02 All 27040 2/28/02 All 27038 Is there a way to generate a fourth column that has the difference between row 1 and 2, column no_each? Mike K