Search results for query: *

I have the following stored procedure that does not seem to pass the @customer and @contact variable to the sql stored procedure to update a table. The @estnum is working but I cannot understand why the two other variables are not being used in the sql procedure to update a table. When I run...

I have an existing table that I would like to add a field to that is incremental. Start at 1 and increment by 1. this is a simple solution I know but what is the query to update the field automatically so I don't have to type 1 to ..... Thanks In Advance

I have an application that uses integrated security. How can I retrieve the user name loged in and assign it to a test box

I have a crystal report (quote)that is created based on a range of values used as crystal report parameters. I would like to have code to be able to generate an individual pdf file for each quote generated.

I have a parameter used to select a print range in crystal reports. Is there a way to attach the pulldown list to a database field so the user does not have to remember the exact fields to type in. Note the field range is not static and changes all the time. Thanks

I have a parameter that is used to select a particular field number in order to select records to generate a report so the user is asked to enter the record number prior to printing the document. In this report I have a sub report that asks the user for the same field number. When someone goes...

I have a form with a datanavigator. I will select the button to create a new record and input data but when i save the data it disappears and it is not saved. However if I press the button to go to the next record and then save it saves the first record. What should I do to avoid haveing to...

I have a report that is made of several pages and each page is grouped on a particular field "name". On each page there is a summary of costs for the group field "name". I cannot figure out how to generate a summary page with the name of each group field name and the summary of costs for each...

I cannot figure out the code to have a text box show the input as currency. Any help is appreciated. Im sure this is an easy one.

I have two tables one is the header and one is the detail. I need to be able to copy specific corresponding records from both tables and create new records that have new primary keys. Im not sure how to do this as I have primary keys in both tables and one of the fields in the detail table in a...

I have a form that is used for quoting and I would like to be able to search for a specific quote number using a button but I can't seem to get it to change the records on the form. Here is my code. Thanks in advance. private void searchBN_Click(object sender, EventArgs e) {...

Im using crystal reports on a web application but I get a login error if im not in debugging mode in visual studio. Once I publish the program to a sharepoint website I am no longer able to log in. I have a an OLE DB (ADO) connection using integrated security. When open the crystal report it...

I have a table with a primary key but it is not indexing by one number at a time. I have set up the primary keys identity specification to increment by one but it will sometimes increment by more than one and Im not sure why. Is there another setting I should have where it does not increment...

Im trying to tie into the CRM database with another program. I would like to be able to call up a list box of opportunity id's from the CRM database. Unfortunately when I go into the opportunity table the opportunity id is very cryptic. Our CRM software gives every opportunity a number like...

I have been trying to get crystal reports to print me a new quote for every quote number I have in a parameter range but what is happening is that it is combining all the data for all the parameters on one report. Note the parameter selections are the Quote Numbers. Anyone advice in the right...

Im using crystal reports on a web application but I get a login error if im anyone but the administrator of the network. I know that the permissions on the sql server database is fine. Im executing the program from the server it is not locally setup. Can anyone tell me what directory I might...

Can anyone help me. I have a table with a true/false selection connected to a form as a check box. When I check the box it is not updating my table. Any suggestions?

I have a recordlock field in a table and I would like to know if there is a feature in sql that will allow me to take advantage of this field to lock the record from being altered in any attached applications.

I have a record lock bit on as a field in a table and I use this lock to determine if the field should be enabled on a form or not to allow or disallow editing. This seems to bog the program down considerably. Is there a more efficient way?

I have a form that uses a datatable adapter. There is a field that I would like to set on a record that is not a textbox on the form. I'm having trouble finding the right code to set this value. Can anyone help me please.