Recent content by aklein

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?