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

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

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

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

Hello, I'm new to VB.net upgrading from VB6. I use the following code to in VB6 to access a MS access database and fill a comboBox: Dim db1 As DAO.Database Dim rst1 As DAO.Recordset Set db1 = DBEngine.OpenDatabase("c:\program files\acs\acs sales.mdb") 'Open the Recordset Set rst1 =...

I have a project with over 100 stills. All of which are already in my timeline. I want to change the speed and duration to all of them so they run longer. Can this be done globally? Or do I have to do each individually. Thanks.

Maybe this is simple, but I just can't get it. I am using Report designer in VB. I have a group called salesman (sorted by salesman), and a field called DayofWeek. I want to sort the days of the week so Monday is first. Any Help? Thanks. Mike Sayler

I have a report designed using the Report designer in VB. In the Details sec. I have 3 fields; ado.salesman, ado.overRide, ado.mgrName. I also sub total on the ado.overRide amount. What I want to do is when ado.salesman has a manager (ado.mgrName) I want to take the sub total of ado.overRide and...

I have a table named sales that contains names of salesmen and their individual sales totals. What I need to output is the Top seller based on the total sales. I sub-totaled the table.totalsales field and tried to use the MAX function on a it, but that doesn't work. Any help is appreciated. MS

I have a VB6 project where I need to synchronize 2 Access 2000 databases. I have made a replica in access and the names of the databases are; "sales.mdb" and "replica of sales.mdb" What would the code in VB be to synchronize these two databases? I've never done this. Thanks...

Hello, I'm filling a ComboBox with dates from an access database. My problem is I only want a date to appear in the combobox one time. Example: If there are ten "4/25/03" and five "4/20/03" dates in a table, I only want them to show up in the ComboBox one time. Here's an...

Can anyone tell me why this formula gets a "The remaining text does not appear to be a part of the formula." ERROR ? Report.RecordSelectionFormula = "{ado.year} =" + "'" + Form6.Combo1.Text + "'" + "{ado.month} =" + "'" +...

I have a user pick a date in VB6 and try to pass it to a report with the following code: Report.RecordSelectionFormula = "{ado.startWK} = #" & stDate & "#" the variable 'stDate' is a date. I get an error. Any ideas welcome. Thanks...

Using VB6, I add a Crystal Reports 7 report to the project. I insert a chart, attach a data source. When I run the report I get the following error: CRAXDRT.DLL caused an invalid page fault I can can create the same report in Crystal Reports 32-Report Designer and it works fine. I have the...

Using VB6, I add a Crystal Reports 7 report to the project. I insert a chart, attach a data source. When I run the report I get the following error: CRAXDRT.DLL caused an invalid page fault I can can create the same report in Crystal Reports 32-Report Designer and it works fine. I have the...

Can anyone tell me why this statement does not work? SQL = "SELECT * FROM reservations WHERE rsdate = #" & A & "# " & " and name =" & Chr(34) & B & Chr(34) And plane = " & Chr(34) & C & Chr(34)"""

I am using VB 6. I want my end user to select a date from a calendar and a name from a combobox and create a Crystal report. The VB code below does not work. I know it's because I do not know the proper syntax for this formula. Basically, I want the formula to select a name and a date from the...