Recent content by JeremyM

I have a program which uses some crystal reports. I created a "TextReader" DSN to read in the data for the report. Problem is that I get a "could not logon to server" and the DSN isnt under the new CPUs DSN. Is there a special way to force the DSN to be installed that the...

It gives me an error on the print. If I dont change to landscape, it prints with no errors. If I change it to landscape, I get a run time error. The ONLY difference is the landscape. Thanks, Jeremy

Dilbert (hehe), Try this as an example: Open INI_FILE For Input As filenum 'Set proper source and While Not EOF(filenum) Line Input #filenum, inrec inrec = UCase$(RTrim$(LTrim$(inrec))) If inrec <> &quot;[SYSTEM]&quot; And Mid(inrec, 1, 1) <> &quot;#&quot; And inrec <>...

I have a form that contains only a few images. I need to print the form as landscape or rotate it so that it &quot;seems&quot; to be landscape. Does anyone have a suggestion on how to do this?

I have a stored procedure call to DB2. Sometimes it errors. I want to continue the rest of the code if it does, not crash the system. Does anyone know how to do this using VB 6.0? Or does it need to be done on the DB2 side? Any help would be appreciated. Thanks, Jeremy Gardner Programmer...

Help. I am currently using a txt to populate the report. The problem is sometimes it works, sometimes it gives me error. Last version ran, but the report printed the data that was old. How can I make it use the updated txt document? Here is the code I am currently using.. Public Sub...

Help! (Please!:)) I am trying to create a new report using either an array or a text file. I have set up the new report using the data definition, now I need to get data into it. Any suggestions or places to look would be appreciated... Thanks, Jeremy

Yeah. Hold shift when u open the database.

The fastest way i can think of is to sort both the table (always keep sorted) and write your own insert/search command (ie. quick search). You can write the code in the module part to loop through looking for duplicates. It will be quicker than Access Queries but will still be rather tedious...

The fastest way i can think of is to sort both the table (always keep sorted) and write your own insert/search command (ie. quick search). You can write the code in the module part to loop through looking for duplicates. It will be quicker than Access Queries but will still be rather tedious.

Its long way. But read one into an array. Then as u read in the other array compare to the current array. If not equal write into the new array (yes u need 2). Then array2 will be all that arent on the other one. Its the long way. But hope it helps. Jeremy

Hello, You must call the procedure (with the appropriate IF statements) in the FORMAT section of the code for the reports. That is the key, it MUST be in the format section. It is as easy as : (writing off top of head please confirm code in book but method is correct) If me >85 then...

Yeah u must also close the current form. You probably should call it also NOT in the load by in OnExit or something. Or on UNLOAD. That way the second form wont be called until the 1st one has loaded (and run whatever the load procedure was). Ie. Me.unload form1.show end sub Jeremy

I have a project where everything works. I can load the TDBG and view it. But for some reason i cant select a row. Anyone know why? I dont want it to edit,just select the row. I will pass paramaters by (tdbg.selection). Any ideas would be appreciated. Thank, Jeremy

Or you could crop it in your imaging software so that there was NO background.