Search results for query: *

Thanks to both of you.

I’m trying to apply javascript Timer I found on the Internet. That script works perfectly, but when I added my script lines to that code I got “Error on page” message on the status bar. What I’m trying to do: compare value from aspx’s textboxes txtEndDay and txtEndHour with system’s current Date...

In access table i need a field that exceeds 9 digit numbers. And the field has to be a number-field, as the percentage will be calculated against this number. When i'm entering an over-9-digit-number i receive an error message: the value you're entering isn't valid for this field. For example...

Thanks much! Encouraged by your answer (which meant to me that both features should work in one datagreed and that i should look up an error in ItemCommand sub). My error was there. thank you jbenson001 :)

I need a few buttons in my DataGreed. One should work to edit record content (EditCommandColumn would be perfect for this functionality with its onEdit, OnUpdate and OnCancel commands features), and other buttons should perform functions different from editing, for which ItemCommand would do the...

And thank you guys, Ian and Brian, for your posts. they work greatly and i believe are more efficient then my SQL Expresion Field. Thanks much!!!

I got it. Thank you all. I have created SQL Expresion Field convert(char,right(10000000000+myNumericField,9)) and then applied this one to a picture function.

Any formulas to get read of comas in numeric field? Right click->Format Field won't help. To be particular, below is what i need in the project: I want to display numeric field in xxx-xx-xxxx format. The formula, lets call it @myFormating used is picture (cstr({myNumericField}), "XXX-XX-XXXX")...

Crystal XI does it too :) Thank you Madawc! :)

Many thanks to you guys! George, a special thank for your explanation in the second post. I appreciate it very much.

The select query consists of number of INNER JOINs and brings several records per CustomerAccount different by 2 fields: Day field and Balance field. What I need is: 1 record per customer. The record should have the lowest balance of the selected Customer and the earliest day. I thought min...

Is there a way to pass reports (Crystal XI) parameter to a stored procedure which is the report’s data source? Thank you all in advance :)

Great! many thanks pwise!

Thanks much guys!!!

Hi guys. How do I get the first row in combobox blank. It's row source is a Select statement of a table: Select ID, Field1 from tblTable order by Field1. The combo box displays the Field1 value, starting from an 'A', but i need it to be a blank unless user specifies otherwise. thank you all in...

I will. and thanks for the help. I have changed SQL Server Bit fields to not allow null. Updates through Access performs perfectly. thanks :)

a timeStamp? what is it? sorry for the ignorrance...

Hi PHV! that would be a "yes" to your second question. As for teh first one: there is NO PK in that SQL Server table. But when i was linking teh table i was prompt to choose the PK, and so i did. thus the linked table in the Access database has a PK.

In teh Access database i have SQL Server Linked table. I'm trying to edit records directly from the table, but get an error message: "This record has been changed by another user since you started editing it". I know no one beside me is using teh database. Any ideas how to fix this? Thank you...

Now i see :) tahnks for teh explanation :)