Search results for query: *

I get the following error message when trying to check a check box that will update a sql field type INT. Error converting data type varchar to numeric. web form hours check box hours is set to numeric. chekc box is set to int. it only fails when i try to check a check box and hit submit...

I need to store hours field in sql server 2000. What data type should i use? I need to store values like 4.25 4.50 etc... please advise?

I am using the following code to generate links to files i have. ' output the filename and URL Response.Write "<li><a href=""" & strDocsPath & "/" & strFile & """>" & strName & "</a><br>" How can I make this a popup window (new window) when it is clicked?

I keep getting a lot of time out errors on this connection code that i use to sql server. sub OpenDB() Dim dbDir Set dbConn = Server.CreateObject("ADODB.Connection") DbConn.Open "Provider=SQLOLEDB; Data Source = ***.1111.111; Initial Catalog = ***; User Id = ***; Password = ****" end sub Is...

I have a field san fransisco, CA 19111 I need to create three fields in a view, C S Z The delimiters are always , space, space. Any help on this would be greatly appreciated.

I have a formula that calculates a percentage in the detail section, then in the group section. I need to sort on this percentage but it is not available in the top n expert, sort expert, or anywhere? How can I accomplish this? CR 8.5 Thanks!

I have a field san fransisco, CA 19111 I need to create three formulas, C S Z The delimiters are always , space, space] what is the best way to do this?

I get the subscript must be between 1 and the size of the array using the following formula. stringvar State := split(trim(split({CSZ},",")[2])," ")[1]; CR 8.5 It works for the records it returns how do i solve the error?

I need to suppress a text box in the group footer area based on IDs in the detail section. details ID A D C E GROUP FOOTER TEST BOX The problem is, I need to suppress ONLY IF THEIR IS AN "A" in the details section. I tried IN, LIKE, startwith, etc and they fail because it is not searching...

I have a crystal report that I need to make as an odbc datasource so a 3rd party can connect to it and access the data it returns. I am not aware of a way to do this and wanted to know if it is possible? The data would be dynamic and not stored in the report, i am assuming when someone...

i use the following code that allows users to click reports in a list menu. Dim X As Variant For Each X In ReportList.ItemsSelected DoCmd.OpenReport ReportList.ItemData(X), acViewPreview Next it lets them pick mutiple reports and view them. I have to pop up a form called...

Is it possible to create a form with one text box, and one button that allows a users to type 1 press the button, open a report in which the ID = the parameter 1. I know how to do this with a query [enter id] etc... However, I need to do this via a form. can someone step me through this?

Is it possible to create a prompt in a view? I don't have access to SP or functions at present and need a quick fix. i need to prompt or a id field. enter_id user will enter 1 return view results... possible?

I can access the functions via sql server enterprise manager but I cannot via the adp file. I can see and run them but it says the sp cannot be found and their is a 1 ending all of them... I can run all tables and views via the adp file. access 2000 sql server 2000 security is SA and has...

Hello. I am currently using a batch file to execute a mass update when users open my db. Here is the batch file the click. Update.bat ------------------------------------------------------ rem If the latest version file is on the PC, just start the database if exist "PTS.1.24.txt" goto...

Is their any simple programs that can transfer files from a local server folder (C:\temptransfer) to an ftp server via the Internet. I think I could write some batch command files that would do the trick, but i wanted to use some type of program that could be scheduled easly. It has to have the...

is it possible to highlight the top n value of a set of grouped data. cr 8.5 sql server 2000 jay 15 james 10 john 9 they are at the group 3 level and i am already using the topn all sort feature? i just want to hightlight the first line?

I have a report grouped on id number and username. at the grouping for username, I sumed up a field called totals wins for each username. I need to only display the username with the maximum amount of wins. I tried using the group selection formula editor but I always get a running sum error...

I have the following set of data id num 1 0 2 3 3 4 4 5 How can I determine the max id (4) then show in expression field (5) repeating for every record. Like below: id num expression 1 0 5 2 3 5 3 4 5 4 5 5 sql server 2000

Is it possible to have crystal reports return a customer id from a scanned barcode from a piece of paper. I have a piece of paper with a generic barcode translating into a number 1. I have a crystal report with a customer id 1. could i make it refresh the db and return this customer after a...