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

  1. Becca999

    Using a dynamic ADO recordset as data source for a crystal report

    Thank you so much zemp!! I have been searching and this is exactly what I needed!!
  2. Becca999

    Using a dynamic ADO recordset as data source for a crystal report

    Hello, I have an ADO recordset that gets built dynamically: Global grstReport as New ADODB.Recordset Public CreateRecordset() With grstReport .Fields.Append "tmpLeftOrder", adSmallInt, , adFldIsNullable + adFldMayBeNull .Fields.Append "tmpLeftSN1", adInteger, ...
  3. Becca999

    ADP Timeout Expired & closes

    Thanks for the response cmmrfrds. We know about the DBA, we just wish mgmt did too!!
  4. Becca999

    ADP Timeout Expired & closes

    In case anyone else has this, the transaction log was full.
  5. Becca999

    ADP Timeout Expired & closes

    Anyone? Our "dba" turned the governor off and everything was fine yesterday. Today, I can't save or change anything without getting the ADO: Timeout Expired.
  6. Becca999

    Defaulting to a value in a listbox

    Can you change it to a combo box? Just setting the combo box equal to whatever it is you want will work. I think you have to set the List Index with a list box.
  7. Becca999

    ADP Timeout Expired & closes

    I have a very simple ADP connected to an SQL Server database via File->Connection. The only objects in the ADP are the SQL Server objects (a couple views, some tables and some store procedures, there is not any vb code). I am the only one using the ADP. If I have a table or stored procedure...
  8. Becca999

    Data Report Menu bar

    Hello, I have a VB Project that is just a data report and a data environment. When you run it, the report comes up in Print Preview and there are three commands across the top - print, export and Zoom. I need to add a button to Close the report (I know there is an X in the corner but it has...
  9. Becca999

    Crystal Report Reference not working w/in VB App- Use to

    We figure it out - we needed to add Crystal Report Object to the application and convert the picture boxes to Crystal Report Objects!!
  10. Becca999

    Crystal Report Reference not working w/in VB App- Use to

    We just opened an old application where the code has not been touched in a while. We are getting a compile error on: CrwPaperWeight.Destination = crptToPrinter where crptToPrinter is erroring with variable not define. Could it be a reference problem? We were getting an error on the...
  11. Becca999

    URGENT -- Printer Object doesn't return correct port?

    The current default printer is the printer in the Printer object before you do anything to the Printer object (Start up) I store the index in a global variable. I have to loop through the printers connection in my app because we have to print different reports, etc to different locations all...
  12. Becca999

    URGENT -- Printer Object doesn't return correct port?

    the ne00 is the network's port name while the HPL3100 is the local port name. Maybe if you explained what you need the port names for?
  13. Becca999

    URGENT -- Printer Object doesn't return correct port?

    I found that just using whatever the Port property said worked. From printing within VB, just change set the Printer object to the selected printer (just remember to change it back to their default). I ended up storing the index number from the printer object as a global and used that (which...
  14. Becca999

    Missing/additional DLLs using P&D on Windows XP Machine

    I had this problem with XP. We (my IT team mates & I) think that XP came with some controls and then you installed VB. The controls with VB didn't overwrite the controls that came with XP because they have that date protection but the dep files did overwrite making the dep files older than the...
  15. Becca999

    Using PDW & getting Dependency Information errors

    Hello, I am using PDW and i am getting missing dependency info on the following files: MSBIND.DLL MSSTDFMT.DLL I am also getting out-of-date dependency info on: MSFLXGRD.ocx MSHFLXGRD.ocx MSRDO20.DLL TABCTL32.ocx Mscomctl.ocx MSBRPTR.DLL MSBRPTR.DLL MSDERUN.DLL I don't have any idea what...
  16. Becca999

    URGENT -- Printer Object doesn't return correct port?

    Hello, I need to get the port for a particular printer. If I loop throughthe printers collection comparing device names to my printer name then try to capture the port, it gives me something like nec1 instead of the real port. Does anyone know why or a way to get the port? Thanks in advance!!
  17. Becca999

    Restoring Default Printer

    I figured this out in case anyone is curious. I need to use the index of the Printers collection. Printers(0) is the default printer. When I loop through the printers looking for the Errors printer, I need to store its index in the global variable. When I need to print to that printer, I set...
  18. Becca999

    Restoring Default Printer

    Hello, I have several network printers that I need to print to based on what is going on in the application. I tried to create printer objects for each of the different printers and just do printerobject.print but that didn't work ... It creates the object with all of the properties of that...
  19. Becca999

    Access database - Multitude of errors

    Thanks for the reply. I tried the copying locally & got the same errors. I tried creating a new MDB and importing the data but when I clicked on the bad MDB, it did not show any tables. We ended up restoring from back up but lost data because we had to go a few days back to find a good copy.
  20. Becca999

    Access database - Multitude of errors

    Hi, I have a back end Access database. We believe it got corrupted in an auto-compact (happened during 2nd-shift). When we try to open the database in 97, we get that "the database is in an unexpected state; MS Acess cannot open it ...." We have gotten this before & converted it to...

Part and Inventory Search

Back
Top