Search results for query: *

I am having a problem with my recordset starting with a middle record instead of the first record. I'm trying to go through each record in the recordset to get values for a few arrays in my vbscript code. My DB table has the following form: BS_STP_NUM | LAT | LON 1 | -84 | 39 2...

When performing certain macros like 'transfer to spreadsheet', can you use relative paths (like ../spreadsheets/test.xls) to the files involved or do you need to use the full absolute path (like C:/spreadsheets/test.xls)? relative paths don't seem to be working for me.

does anyone know how to compact and repair a DB with either VBA or VBScript?

Does anyone know how to do this? I have an excel spreadsheet with two buttons on it. Each button triggers a macro. I want an external .vbs file to run those macros without me having to go into excel and push the buttons.

Every time I run a macro of mine (which triggers a query) I get this error: "Microsoft Access Can't Append All the Records in the Append Query" It asks if I want to continue, and I click ok. Is there a way to keep this message box from popping up when this occurs? I've tried 'On Error Resume...

I have three tables. Each of these tables have the same structure (same fields). I want to create a new table with the same structure, and I want to put all the records from the other 3 tables into it (kind of like a master table). Does anyone know how to do this with SQL? The SQL doesn't...

Is it possible to call a vbscript file from within another vbscript file without using the DOS shell?

I am building a message board application, using an Access DB. The users can view all the main posts, and by clicking on one, they can view all of the subthreads for that post. On the ASP page displaying the main post, and the sub posts, I want a picture of the person who made the main post...

The asp page I'm working with has a query string fed into it, and the URL is: replyToThread.asp?MainThreadNum=14 On that page, I have a form with this code: <form method="get" action="scriptSubThread.asp"> <table> <tr> <td align="right"> <input type="hidden" name="MainThreadNum"...

How can I do this? I know how to call a .vbs file: Call Shell("wscript.exe " & "myVBS.vbs", vbMaximizedFocus) How can I call a .bat file instead?

I'm trying to count the number of records in an error log table and display the result to the screen. Dim sqlCount, rsCount set rsCount = CreateObject("ADODB.Recordset") rsCount.open "tblErrorLog",objConn1 sqlCount="SELECT COUNT(*) FROM tblErrorLog" set rsCount= objConn1.execute(sqlCount)...

Is there any way to automaticaly put the error description from a vbscript run-time error into a log file(either text file, or MS ACCESS table)?

I have a form in my access db with a number of buttons tied to sub procedures. Right now, any errors are displayed in a message box: Err_Command1_Click: MsgBox Err.Description Resume Exit_Command1_Click End Sub Instead of this, I would like the errors to go to either an external log...

Does anyone know how to run a subprocedure from a macro? The sub I want to use is currently associated with a button (Sub Command0_Click()). This sub does a number of things like running a few macros and opening a few queries. I'm hoping to replace the button with a macro that has all of the...

I have an excel document. The formating in it is not important, so I want to convert it to a .csv file (to make it easier to make changes to it from a .vbs file). I thought that I might be able to just rename it with a .csv extension, but that didn't work. When I opened the file in a text...

Does anyone know how I can run an external .vbs file from within Access (With a button on an Access form triggering a macro)?

I want to make some formatting changes to an excel file by using an external .vbs file. Specifically I need to: 1. select all cells and remove word wrapping 2. change the text in one of the cells 3. reformat the dates in one of the columns Can anyone lead me in the right direction?

Does anyone know how to unzip and extract files to a specific location from the command line, or with some vbscript?

I am using VBScript for a number of windows scripting tasks (i.e. retrieving remote CSV files and reformatting them for entry into an Access DB). The DB I'm working with has a number of macros already set up to import data, sort it, put it in the correct tables, etc. As it stands, I have to...

Can someone help me make some sense of this Access SQL statement? What is it doing in plain terms? UPDATE Order_Info SET Order_Info.ATTRIBUTE_8 = "BACKORDERED" WHERE ((([Order_Info]![ATTRIBUTE8]) Like "BACK*"));