Search results for query: *

Hello, I have a search form. The search form has a combobox and a subform. When a user selects from the combobox (they select a supplier code), the subform will display the the searched results. In the subform, users are allow to add new records. When the user add a new record, the supplier...

Hello, I am modifying a database that was created by someone else. The database has a form which a user can choose from a combobox and the result is then display in a subform. Combobox1 has a query behind it. when the user clicks on it, it shows in the dropdown the available last,first name...

I have a formula that is counting a field, but it is also factoring the 'details' section when I insert a field. How do I stop the formula from not factoring in the details section and only count and display one the field I need?

I have a report displaying by groups, but I need the total count of records displayed. Example data: Group 1: State Group 2: Last Name NM Smith NM Benson GA Richardson GA Floyd GA...

How can I write a formula that uses the range operator and also a parameter value? For example, I need a crystal syntax formula that checks to see if a database field of 1 - 12 has a parameter value of 11. Something like this if it is possible: if {tablename.field} in (1 to 12) = {Parameter...

I am doing a survey of a group of people for a special demographic research. I need to find what age is missing from this group. I need to display from 2 different tables: Table1 has the "RACE" field and Table2 has the "Age" field. For example, my report current display as follows for year...

This is an example of my database. We keep track of how customers pay for products that are on a monthly basis. Customers are required to pay every month. I need to find which State, Customer(s) have not paid for a certain month. This report will need to run every month, so I will enter...

I have an item array: A600 I need to increase it by 1 (A601). How do I increase it and have it shown in a textbox? Thanks

I have a combobox in a window form and it is populating from a datasource via sql. I need a blank item, "select category". How do I do it? dtCategory = SQLQuery("Select Category Display from Category_Support").Tables[0]; DataColumn[] CategoryKeyColumn = new...

Hello, I am having some issues with killing 2 sessions I have in my application. The application has 2 pages that takes data. Page 1 is session["ABC"] and data is taken from dropdownlist and textboxes. Page 2 is session["EFG"] and this page has a gridview that has dropdownlist and textboxes...

I have a gridview that shows data. Data is called from a web service method.In one column, the values are displayed as abbreviation and I need those values displayed as the actual value. I have a Dictionary Object that I want to use to display the values. Dictionary - where do I put this...

I have this script that calculates numbers input by the user in txtboxPRICE and txtboxTAX and it automatically calculates the TOTAL in txtboxTOTAL. I tested it and it won't calculate pass $1,000? I need it to calculate numbers up to 25 digits. function formatCurrency(usFormat) {...

I have a dataset that calls the values from the webservice. In the datasets are abbreivated values (e.g., AA, BB, CC, DD) and I need to display the values on my dropdownlist as its whole names such as AA = APPLE, BB = BEES. Here's is an example of my method. How can I rename the values in the...

Hi, I have a gridview that users can select data from a dropdown and enter data in a textbox. They can enter how ever many records they have. They can edit/update/remove/cancel after they have saved. When they click EDIT on a record, they modify the record, then they click UPDATE to update...

I have an if statement that says this: if abc.text is greater than or equal to xyz.text, then lblerrormessage.text and lblabc.text shows error messages, else lblerrormessage and lblabc shows nothing. but sometimes abc.text and xyz.text will be 0 and thats fine. How do I write that...

I have a dropdownlist of names that I call from a web service. I need to select distinct, firstname, middlename, lastname, then order by lastname ASC. Can anyone help me on this? I am having some issues getting this to work. Thanks, any help is appreciated!

I have an application in ASP.net that sends an email when an error occurs. In the email, it sends the subject line, then in the body, I have the error that occurred and the ID of the person. In the body, it is sending this: Invalid object name.4 I need something like this: Error is: Invalid...

Hello, I have a web application that users must enter values, which is then saved to a temporary database. Once it successfully saves to the temporary database, I need those data to send to the web service to be saved in the actual database. But the issue is, those data are not saving in the...

Hi There, I have an application in ASP.net. It is an application where users enter their required information, then it saves to our SQL database. I am having some issues when the user is done entering their info and clicks the "submit" button, which is then saved to the database. The...

I have this piece of code that is going to save records in my application. I found that the "create_date" has to be format in this way: "Create_Date": string; required; must validate as a 'DateTime value'. Suggest format: '2012-10-08 02:49:15 AM' How do you make r1["Create_Date"] =...