Search results for query: *

I have textbox that is going to capture account numbers of varying length based upon the Institution they belong to. If for example an account has 9 digits I would like the text box to stop accepting the user input once the 9 digits have been entered?

I have a text box in which users are to enter numbers, I would like a function I have created to be triggered after each number has been entered not only after the text box has lost focus or by using the After_Update event. Please help, have wasted alot of time to no avail with this

I am getting the following runtime error message when I try to use the following code: Error message: Method 'Item' of object 'Forms' failed Offending line of code: Forms!frm_main!txt_user = cbo_user_id The Form "frm_main" is open and cbo_user_id contains a value as well. This code runs fine...

I have a comments field in my database, I have set the datatype of this field to "Memo" to allow more than 255 characters, this displays fine on the form but when I try to display it on a report it cuts off the characters after 255 characters. Please help

I have copied the MSCOMCT2.OCX file to my machine and registered it successfully but I am still coming up with the following error when I try to place it on my form: "You don't have the license required to use this ActiveX control" Please could someone lend a hand

I am trying to use ODBC to link to a Sybase table and am getting the following error. Reserved error (-7778); there is no message for this message. Any suggestions

I have successfully connected to a Sybase database but it does not give me write access to this database only read, I am using OLE DB to connect, I get the following error when I try to add a new record to the recordset. Please help. Run time error '3251' The operation requested by the...

I am trying to get stock quotes directly into my spreadsheet in Excel 97, can anyone offer any advice on how to do this

I am trying to get Stock prices for the companies that I have invested in directly into my Excel 97 spreadsheet. Can anyone help me with this?

I have got a deals sheet in my workbook, this sheet contains all Foreign currency deals for all my clients. It contains column headings like Buy Ccy, Buy Amt, Sell Ccy, Sell Amt, Ref No. The Buy Ccy column contains the Currency type bought eg. GBP, Buy Amt is the amount of this currency, this...

Can anyone give me an example of a how the Dsum function is used in excel? Thanks

I am trying to sum rows of data based on certain criteria, this criteria is contained in each row, I will illustrate my problem with a simplified example: 2400 IF1 2500 IF2 2600 IF1 The result I would like to achieve is for the rows containing IF1 to summed giving 5000 and for IF2 to give...

Does anyone know where I can download a Microsoft Timer Control from, I need to use it in an Excel spreadsheet

I am getting this error when I my Excel app tries to link to an Access database to retrieve data. does anyone have a tried and tested solution for this error?

I am looping through a recordset, I am comparing the values in one of the fields of this recordset with parts of a string from a bookmark in a Word 97 document. Once there is a match eg. "Mr" in the recordset is matched with the "Mr" part of someones name in the bookmarked...

I am trying to sort the elements of an array but am not having much success. I am trying to sort a list of numbers from smallest to largest. Please help.

Scenario: Allow a user to enter a list of numbers delimetered by commas eg. 234, 456, 2, 45, 87 and output these numbers to a text box but arrange them in order from smallest to largest. The user inputs the numbers into a text box. I have been using an array but I cannot separate the numbers...