#include <iostream>
using std::cout;
using std::cin;
using std::endl;
#include <string> // program uses C++ standard string class
using std::string;
using std::getline;
// Class DigitSeparator definition
class DigitSeparator
{
public:
// this...
Create a class called DigitSeparator. This class will only have one function called separator. Function separator will have ONE parameter of type long int which will be used to accept a six-digit number. Function separator will take the number passed to the parameter and separate it into its...
Hi
I want to code a form that will enable the user to change his/her password from with a VB application. I already have the form to allow the user to connect to sql server in the vb application. But now i want to allow the user to change his logon from within the vb application. Is this...
Hi,
I finally got it to work. I basically used the SET DATEFORMAT ymd as suggested by SQL Bill. This will tell SQL what date format to expect. That was half of the solution.
The other half, as rsinj pointed out, the date might not be coming across correctly to SQL Server. Using the CDate()...
Hi,
I tried your suggestion but SQL still had some problems. When I used the Cdate() function to convert my parameter, SQL report a problem with the '/' in the date. However, when I view the data in the actual table (thru Enterprise Manager), the date field date format is dd/mm/yyyy. How can I...
Hi,
I am having major league headache with SQL Server.
I am trying to write a report which will execute a stored procedure based on certain parameters. Two of the parameters in the stored procedure are datetime data types. My main problem is passing the date value from an Access form to the...
Hi,
How can I pass optional parameters to a view when it is called from a stored procedure. Basically I want the recordset from the view to be filtered based on criteria requested by the calling procedure. I do not want the view to return records that are not needed for my report. Furthermore...
Hi,
I need some urgent assistance. I need to create views for a report, but the data that I need resides on different tables on two different databases on SQL Server. Is it possible to reference tables across databases. I know in MS Access its easy to link the tables and write the query, but I...
Hi,
I have a main report in crystal report, which has a formula field showing a running total. However, I also inserted a subreport which provides a brought foward figure that I want to include in the running total of the main report. How do I tell the main report to use the brought foward...
I have a main report with two subreports inserted in it. I am running the report from a vb application. All three reports use the same data file which is an access .mdb. My major problem is that the report will only run locally thru the application. when I try to run it over the network, it...
Thanks ZahidKhan03,
I thought about that possibility, but the database is also password protected therefore its unlikely (but not impossible) that unauthorized users would open the database from outside the application. Is that the only reason a database would become corrupt? As I mentioned, in...
Hi,
I created a multiuser vb application that connects to an access db over a WAN.I am presently doing some testing with end users, and every so often one of the tables gets corrupted and corrupts the Access file. Only users who are logged on can access the tables ( except the table that is...
Hi,
i think I finally resolved my problem. Instead of coding the logon server, I just needed to set the parameters for the username and password for the access database. Here is what the code looks like for the crystal object.
With crptCrystal
'Set Source, Report name and...
Hi,
I have an application that connects to an access 97 database. The database is password protected, therefore I need to code the connection in my application. I have managed to write the code for vb to connect to the database. However I am having a problem with the reports because they are...
Hi,
I am comparing two variables of the same currency data type. The first variable (PayinSumAmountCheck) is taken from a single row returned from an sql statement based on a parameter text box which the user inputs. Then second variable2(curTReceiptAmountCheck), however is derived by adding a...
Hi,
I am writing an application in MS Access 2000 that connects to SQL Server, then runs some queries to produce a report. The application basically uses linked tables, on which the queries execute. I have created a log on screen which authenticates the users to the SQL server. However, when...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.