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 Rhinorhino 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: *

  • Users: CybOrg
  • Content: Threads
  • Order by date
  1. CybOrg

    What's the purpose of Record Types?

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

    Making printers OBEY!

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

    EXEC sp_whatever @var_1, @var_2 from Access SQL

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

    Retrieving TEXT data type from a VB app

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

    Setting app return codes from VB

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

    How do I issue return codes in a VB App

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

    Return of Running reports from VB

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

    Printing to file - automatically

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

    Distributing an MDB with the VB app

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

    Intercepting changes in other windows

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

    How to code a PING-machine?

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

    Embedded Excel OLE opens with 10 rows

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

    Size of embedded OLE Excel sheet is only 10 rows...

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

    Operation Not Supported in Transactions

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

    OCX-troubles in VB on NT4

    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?
  16. CybOrg

    Excel chews up all available memory, then kills the machine

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

    Automatic report generation in Access 2 - to PDF!!

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

    Configuring SQLServer in a Banyan Vines Network

    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

Part and Inventory Search

Back
Top