Search results for query: *

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

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

Hi, I need some urgent help. I have created a database application in VB that opens a password protected access database. I have manage to code the password for the DAO to open it. But I am having major league problems with the connection for the designer for the reports. Each time I want to...

Hi, I have a listbox that enables the users to add items and save it to a file. I also want them to be able to delete selected items. However, the remove option does not remove the selected item, it removes the first available item in the box. How do I tell VB to remove the selected item. Any...

Hi I would like to know if anyone knows how to copy data from the datagrid to the clipboard system object and paste it to another application like Excel. Essentially, I have created a database application. This application has a lookup or search feature that allows the user to input different...