Recent content by Thorny

Apologies for being vague, I have a combo box with the institutions being selected prior to the account numbers being input, each instituion has its own account number format. Does this make it any clearer?

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 tried putting my code in the On_Change event, doesn't work, have also tried the On Key Up, Down and Press events. Add the following code in the: Private Sub Textbox_Change() MsgBox Texbox End Sub If I key in the number 1 into the text box, surely the number 1 should be displayed in the...

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

Thanks alot Jim & Ben for your replies, Jim I think you're right in that I don't not have ODE and so the licensing is not being done properly. Ben I think I will take up your offer of using your datepicker, thanks. Thanks again

Access 97

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