Search results for query: *

tsdryden: Thanks for the tip. Works great. I thought I had tried that, but must be I didn't do it quite like that, because today it is working and yesterday it wasn't. I wasn't having a problem on my XP machine but the users have Win 2000 machines and they were the ones having the problem...

I have a VB6 program using a sybase database. I use ADO 2.6 to access the database. When I use the IsNull() on a field from that database (and the field is equal to null) I get an error "-2147024882 (8007000e) Not enough storage to complete this operation". It seems to ignore the fact that...

Worked like a charm! Seems silly to HAVE to do it that way, but at least it works. Thanks

If you are printing these numbers to the printer object (this will work for a picture box also) you could do this: Printer.Currentx = X - Printer.TextWidth(Yournumber) X being the rightmost position where you want your numbers If you want your numbers formatted put the Format function around...

I think I'm missing something.... I have been coding in VB6 for a couple of years, last year I started using Sybase ASA 7 for my database and I'm becoming very frustrated (no training). The latest thing has been removing data from fields - specifically date fields. With character fields I...

I have a VB6 program where I am loading data to the screen and I have If IsNull(fieldname) then do one thing else load data to screen fields end if When the code runs it bypasses the IsNull and tries to load the data to the screen. At that point I get the error: -2147024882(8007000e)...

You mentioned that you would like 2 copies to print, so you need to make your PRINTOUT statement look like this: WordApp.ActiveDocument.PrintOut Copies:=2

I had the same type of problem. Through code I could not see the new records added until I issued a REQUERY command. Hope this is helpful.

I am using VB6 with a sybase database. When I open a table using an SQL statement containing a "Where" clause I seem to lose the End-Of-File marker. I can use MOVEFIRST, MOVENEXT, and MOVEPREVIOUS (if I haven't reached the end of file), but I cannot use MOVELAST (I get a BOF,EOF...

Worked beautifully! I didn't realize that you could put expressions like that into SQL statements. Thank you!!

I don't know if I took more files than I needed, but I packaged all the DLL's in the win32 folder of the Sybase instalation. I was able to then install and run my system on a computer that did not have sybase client installed. Sybase is installed on our network, so if you are trying to do a...

I use VB6.0 to connect to a Sybase database. I have some sql that works with an Access Database, but will not work with the Sybase. The sql looks like this: SELECT HeaderTable.SwisCode, DetailTable.ParcelNumber, Sum(IIf(HeaderTable.SchoolOrVillage =...

I am using the sstab1 control and need to be able to add and remove tabs at run time, but I can't seem to put any controls on the newly created tabs. I select the tab I want: sstab1.tab = x 'x = the number of the newly created tab Then I load the control array that I want: Load...

How do I do this at RUN TIME. I use the sstab1 control and need to be able to add and remove tabs at run time. I have a control array that I need to add to the new tabs. How do I do that? I code I select the tab I want to place the control array onto: sstab1.tab = x then I load the new...

I am having a problem with my data grid. I have an event BeforeUpdate() for my dbgrid. If I test the program within VB everything runs fine. But, if I compile the program and run it and update any information in the dbgrid I get this error: This Program has performed an illegal operation and...

UPDATE! I feel somewhat like an idiot, but here goes.... The command only works BACKWARDS when you are printing to an HP 4000TN printer. When I took my program to another office and tried printing it on an HP 4050TN it did not work correctly. I then changed all my calculations to how I...

OK I FIGURED IT OUT!!!!! The confusion lies in the clipping region. The x1,y1, width1 and height1 work just the way I understood. BUT - x2,y2 are not the left/top coordinates - they are the left/bottom coordinates and you measure bottom to top for the height2 and measure left to right for...

It is a scrolling picturebox. Only part of the report is visible at a time (until either scroll down or over), but the entire report is contained within this picturebox.

also, if I put in the command like this: Printer.PaintPicture picReport.Picture, 0, 0, , , 0, 27.14 (This command tells me that I want x2=0 and y2=27.14 cm, so the top left corner of my clipping region is all the way to the left and 27.14 cm down - right!) That command gives me the top left...

I can't figure out what I am doing wrong!! If I put a simple command like this: Printer.PaintPicture picReport.Picture, 0, 0, , , 0, 0 I get the top, left of my report (like I want), but if I add any width or height after the x2,y2 it prints the bottom of my report (and it's wrong)! I have...