Search results for query: *

An old mainframe programmer, I'm used to the concept of records and record layouts when processing sequential files. Why can't I define a record type in VB like: Type MyRecordLayout RecordID as String * 6 FirstName as String * 20 etc, etc End Type Dim InputRcd as MyRecordLayout Line...

I'm writing a little snippet of code to print all Excel sheets in a folder - could be something like 30 sheets at a time. I've got a printer that's duplex capable - the problem is I can't figure out how to get that mother to actually print on both sides from within the code. I've seen...

I have a large SQL Server database that I access via MS Access. What I'd like to do is execute a stored procedure, passing parameters from a user form. Kinda like: PARAMETERS Forms!Main!fromdate DateTime, forms!main!todate DateTime; EXEC sp_Total_Time_For_Period...

I'm trying to retrieve a field of the type 'TEXT' from an SQL server database and can't figure out how to do it. I've written a syntactically correct stored procedure that I can execute and get the text in Query Analyzer, but it won't return any records in VB, and if I try to open a recordset...

Hi! I tried setting different return codes in my VB app (so I can take appropriate actions when/if it fails), and I tried using the SetLastError function, but the app still seems to return 0, regardless of what happens... Clues, anyone? /Cy

We just installed a Batch job queue system which among other things can act one way or the other based on an app's return code. Return codes are common in the mainframe world, but how do I issue a return code from inside a VB app? Cy

I too need to run reports from VB, but I've got another twist to the... challenge. The app in question WAS running as an Access application, checking a database table every ten minutes for new records. Upon existence of such records, the app either a: ran a report which it faxed to the...

Hi! I'd like to know if anybody's tried to code a VB app that prints documents automatically - but not to a printer (heck, I could do that!;-)), but to a file. Either to a .prn, but better yet - to PDFWriter. The problem I have is getting to the file name dialog... /Cy

Hi! How do I distribute a VB app that uses an Access 97 database? Is it possible to create a 'runtime' version of the database that doesn't require the user to install Access97? The app only needs the DB for some processing parameters. There's another thread on the forum with a similar...

Hi! I'm coding a time-logging system that starts other apps (using 'Shell'), and/or switches to already started apps upon the click of a button. Now, some applications CAN start multiple sessions (like terminal emulators, Word, Excel), and in order to save memory, I'd like my application to...

I'd like to code a PING or something to that extent, in order to check if another machine is alive. Any clues? >(::O> Cy

Hi all ye gurus! I've coded a VB app with a form with an embedded OLE object, which I dynamically turn into an Excel spreadsheet. The only problem is that after I've populated and formatted the sheet, I'd like it to at least fill the entire container window, not just 10 rows. If I...

Hi all ye gurus! I've coded a VB app with a form with an embedded OLE object, which I dynamically turn into an Excel spreadsheet. The only problem is that after I've populated and formatted the sheet, I'd like it to at least fill the entire container window, not just 10 rows. If I...

Hi all! I have a VB app that stores records in an Access97 database. The users add records one by one, and when a counter reaches a preset limit (10), the app committs the transaction and zeroes the counter, in order to reduce network traffic. My problem is that I've distributed the app to a...

Hi all! When trying to load a project (which loads and runs quite nicely on a W9x-machine) I get errors on the OCX's when I load them. Moreover - when I go into 'Project/Components' I get another System error (&H80004002), claiming the interface isn't supported. Clues, anyone?

Hi all!<br> <br> I've got a situation where I have an Access97 macro that should run nightly to produce reports in Excel. It runs the query (against two separate ODBC databases), saves the output in Excel format and kickstarts an Excel macro sheet. The macro save the datasheet under another...

I've almost gotten it:<br> <br> Create the queries/report. - Done!<br> Create a macro for running it: - Done!<br> Create an entry in SysAgent to run it daily. - Done!<br> Install a PostScript printer. - Done!<br> Install Acrobat Distiller and set it up to watch a certain folder. - Done!<br>...

I'm currently running my SQLServer on named pipes, but would like to use the Banyan Vines protocol instead. I've set up the service SQLSrv@MSSQL@org, but there are a few more adjustments to do that I can't find in the manual... Apparently, since it won't work... Hints, anyone?<br> <br> Carl