Search results for query: *

Two years later, different programmer, same question. I can get the start and end page numbers from the common dialog box, but how do I tell CRViewer (using VB6 at the moment) what the PageFrom and PageTo are?

Sounds like the wrong, or a bad, printer driver, or the printer isn't capable of printing what you want.

I'm guessing that {TestSession.ID} is a number and Crystal doesn't like your testing a number against a string. Try using ToNumber(@ses).

Either I'm losing my mind or I saw that CR (I'm at 8.5) has a native method to do Code39. I've spent the day in CR and this forum, so it has to be in one of them (assuming I'm not imagining things), but I can't find it in the help file or by searching tek-tips. Anyone know what I'm talking...

Very rough VB code (from a working app): Dim adors As ADODB.Recordset Dim strsql As String Set adors = New ADODB.Recordset strsql = "SELECT [field name] from [table name]" 'use any field in the table adors.Open strsql, conn.cnn, adOpenDynamic, adLockOptimistic ' conn has to be open...

A bit late, but RegClean (from Microsoft) might help.

If you're still looking for something simple - and if your start date is the first day of the current year - save yourself future work and make the start date the first day of the current year, instead of a fixed date.

They may not be self-registering. Try registering them - in one directory or the other, not both.

Why not open the database in VBA, grab the data into an ADO recordset and send that recordset to the report? That way only VBA has to know about the user name and password.

>I did have to use the = "" option. Moving the ISNULL first didn't do anything. That says that your field is blank, not null. The two aren't the same.

I've done the kind of thing you're looking to do. It takes A LOT more than an ActiveX component. In fact it takes a lot more than VB if you want the plate recognized before the owner has to replace it with a new one. I know that's not the kind of answer you're looking for but optical...

The "source code" in the .exe file is assembly (actually machine language). The file can be disassembled and worked on, if you can get a good Windows assembly programmer. (It'll probably cost more that way [lots more] than having someone write the whole thing from scratch in VB.)...

Are you logging it in to the sa account? As some other user? If so, is this user being given access to the database?

Check the code in the listbox click event. It may be selecting item 0 all the time.

Look in Project/References. Do you have: Visual Basic For Applications Visual Basic runtime objects and procedures and Visual Basic objects and procedures all checked?

DBA_Frog said: This will probably throw and error because IsNull requires a TRUE\FALSE answer Your most likely to have success with if IsNull({abc})=True then IsNull requires the name of a field to test for null. IF requires a true/false argument, but IsNull returns one. Testing a function...

Remember that VB6 is an event-controlled environment. Nothing happens until an event fires. If you print the report at the end of a sub, the report will get sent to the viewer, and VB6 will wait for the next event, a click, keypress, etc. Unless you've called that sub from a sub that has more...

The same way you get it to execute any other program. There's nothing special about having compiled it in VB. IOW, if you can write a macro that would execute Notepad.exe, the same macro will execute your program. (with the appropriate change of name].

The standard Windows metaphor is that a 'blank' date-time picker (of any type) is set to 'Today'. That's what people expect to see.

If that's what he meant (I doubt it) he was wtong. You can find the path from the reg key, then you delete all files in that path. But not all files in the temp directory will delete - some may be in use. Deleting the entire directory is also a bad idea - programs that store files in that...