Search results for query: *

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

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

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

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

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.

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.

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

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

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

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

...gintHotSheetPrinter = 9999 gintKanbanPrinterIndex = 9999 gintRecTktWhitePrinterIndex = 9999 gintRecTktPinkPrinterIndex = 9999 '** Establish printer indexes from Printer's Collection For Each TestPrt In Printers intPrtIndex = intPrtIndex + 1 '**...

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?

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

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

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

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!!

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

...have in the Common module: Global gErrorsPrinter As Printer Global gDefaultPrinter As Printer on start up: '** Capture Default Set gDefaultPrinter = Printer '** Establish Errors printer For Each cIn Printers If TestPrt.DeviceName...

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.

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