Search results for query: *

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

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

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

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 :)

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

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

What is more efficient? There are Active Employees and Terminated employees records in the database. Should Active and Terminated Employees records be kept in one table or separated in two tables?

Perhaps somebody can help… In asp.net project (VB.net) I want to populate a dropdownlist, lst1, with a value from SQL Query, using SLQDataReader object. strSQL=”SELECT AppName, EmpNum FROM tblApp WHERE AppID=” & iAppID myConn.Open() Dim objCmd As New SqlCommand(strSQL, myConn) Dim objDR As...

DropdownList and radiobuttonList are populated from sql server, using DataBinding. Somewhat neither of them shows the value of the first record. For example, if SQL query result is <John, Mike, Kim>, the radiobutton list will have just 2 radiobuttons: -Mike -Kim And the same with...

In a Query, field CustName, i need to substitude one value with another, but only if teh value="bla-bla-bla", otherwise teh query should show the real value of field CustName. How can i do that? Does MS Access Queries support something like SQL Server's Select CustName = case when CustName...

In access application i have SQL Server linked tables. A couple of fields, and i can see them in SQL Server EM, does not show up in the linked table in MS Access. But i need those fields in my queries. What do i do? In QA i found that those fields have constrains: [update_type] [int] NOT NULL...

I've declared my 2-dimentional array as Private arr(x, 12) as Variant I need it to be accessible by different Subroutines on a form, so i have to declare it in the Declaration part (prior to all the subroutines) of the code page. This throws an error every time i open the form, press any...

I'm pulling data from .inf file to MS Access table. The application searches through .inf files, finds a key words, indicating, that the data between the key-words needs to be extracted into Access as Date/Time field and extracts this value. Let's say the value is assigned to VBA variable...

I'm transferring Access Table data to a .txt file. I want the Date field to hold only date information (mm/dd/yyyy format), but somewhat it transfers hours, minutes and seconds as well, although in the table dates are displayed in mm/dd/yyyy only. I've tried ShortDate format for the date field...

I'm transferring table to the txt file, but have to have no quotes around each field and have '|' delimiter instead of comma-delimiter. Is there a way to do this programmatically? P.S. I transfer the table using DoCmd.TransferText command. I would appreciate any advice. Thank you all in advance.

In asp.net project (vb.net), in dataGrid I use CheckBox: <asp:TemplateColumn> <ItemTemplate> <asp:CheckBox id=chk Enabled=false runat="server" checked='<%# DataBinder.Eval(Container.DataItem, "Display") %>'> </asp:CheckBox> </ItemTemplate> </asp:TemplateColumn> It is...

How to place cursor on the selected DataGrid’s BoundColumn: <asp:BoundColumn DataField="NewEntry" Visible="false" /> Users clicks on an EditCommandColumn button: <asp:EditCommandColumn EditText="Edit" ButtonType="PushButton" UpdateText="Submit" CancelText="Cancel" /> This makes that...

How can I select employees' last title (a record of the last promotion) from SQL server database? As employee gets promoted new record is added to the database with new EmpNum (the number gets increased). I thought max function should do the trick, but my query brings all records. SELECT...