Recent content by goldi

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