Search results for query: *

I just upgraded for VB6. Using Crystal Reports in my project I need the end user to select a managers name from a list and display the report records for that manager. In VB6 I used the Report.RecordSelectionFormula = to acomplish this. How is it done with VB.net? My data source table is called...

Check this out. I've used them for years. http://www.softwarekey.com/swk_products/plus/default.asp

I have tried all logical options that I know of! Maybe someone has an illogical one! [ponder] I've used CR since VB3 never had problems.

Yes. It lists this:Crystal Reports 9 for Visual Studio .NET

I tried that the only thing there is: Application Config file, Text file, Jscript file, vbscript file, Windows script host. NO Crystal Reports.

If I go to Project-add windows form; the same dialog comes up as 'add new item' with all the same choices. Any other ideas??

I just recently started using VB.net 2003. I haven't been able to locate CR9 in the 'add item' dialog. So I just re-installed CR9 it still does not appear. Even with all references added it does not show up. Any ideas? Thanks.

I'm trying to populate a textbox with the current time. The format I want is ie. 5:30 PM. The following code: TextBox1.Text = Strings.Format(Now, "hh:mm AM/PM") Produces this output: 5:30 A54/P54 Any Help would be appreciated! Msay

Golom, Thank you so much! That worked. I was going nuts!! MS

Microsoft DAO 3.6 Object Library has been checked from the start. I typically always have that checked when doing SQL's like this. I think this is one of those times it's so simple I'm missing it!

With Microsoft ActiveX Data Objects 2.x Library selected, code progresses to rst.open and produces the same error. ???

Skip, I cut and pasted your code (correcting typo)and I get a "User-defined type not defined" compile error on this part: New ADODB.Recordset Just as a check what References need to be set to execute this? Sorry, I haven't used VB for some time and I'm a bit rusty! Thanks.

Skip, I tried that, but that still returns the SQL string itself. That's why I'm stumped!

The following is the code: Dim db As DAO.Database Dim rst As DAO.Recordset Set db = DBEngine.OpenDatabase("c:\program files\Client Time\clienttimer.mdb") 'Open the Recordset Set rst = db.OpenRecordset("TimeData") Dim SQL As String A = Combo1.Text SQL = "SELECT SUM(totalTime) FROM...

I have developed a VB6 app that has several 7.0 crystal reports. It works fine on my development pc (win XP) and another clients pc(win XP). I recently tried installing it on two other pc's (win XP pro) and have the following problem; The reports works correctly (all the proper data appears)...

I have developed a VB6 app that has several crystal reports. It works fine on my development pc (win XP) and another clients pc(win XP). I recently tried installing it on two other pc's (win XP pro) and have the following problem; The reports work correctly (all the proper data appears), but an...

Thank you. I used mulitple statements.

I'm using VB6. Trying to fill 3 comboboxes with distinct values from a database. I'm using the following code: '\\\\\\\\\\\\\ Dim db1 As DAO.Database Dim rst1 As DAO.Recordset SQL = "SELECT DISTINCT invoicenum, boat, workdate FROM timesheet" Set db1 =...

Thanks! [thumbsup]

Thanks! One more question. If I want to add data to my database from a textbox or combobox what would that look like? Here's an example from vb6: Dim Data1 As DAO.Database Dim tbl1 As DAO.Recordset Set Data1 = DBEngine.OpenDatabase("c:\program files\acs\acs sales.mdb") 'Open the Recordset...