Search results

Hi I have a Form with two controls 1 a combobox called AccNo and 2 a text control called CuName. These two controls get their data from a Table called Customer. Table Customer contains 3 fields 1 CustomerID 2 AccNo 3 CuName. I would like the CuName value associated with the AccNo value...

Thanks ViRi

Hi I have a Subform where I have had to include a calculated field. I have no problem with the calculation, but try as I might I can not change the name of the Label of this new field. Even though I have changed the default name under the Name property of the Label to Description I get Text17...

I Have the solution. Code must be placed on the On Page Event of the Report not the On Open event. ViRi

Hi I have a report and I am trying to reference a text box in the Report called Currency but I always get the Expression has no value error. Here is two codes I've tried by putting them on the Open Event of the Report [CODE] If Reports!rptStatement!Currency = "GBP" Then Me.Debit.Format =...

Hi I have a Report that I would like to send via Email using Outlook Express directly from the Report ie without leaving Acess. Thanks ViRi

Hi I've tried this code on the On Current Event of the subform. It works for the first record once the Form is refreshed, only to change back once the Form is refreshed again by selecting a new record for example. Private Sub Form_Current() If Me.Euro = True Then Me.Total.Format = "€0.00"...

Hi Any idea on how to go about this. ViRi

Hi I have a Query that calculates a value SubTotal using one of two values depending on the state of a check box called Euro. SubTotal: IIf([Euro]=True,[Quantity]*([UnitPrice]*[ExchangeRate])-[Discount],[Quantity]*[UnitPrice]-[Discount]) This works fine. The value is calculated correctly...

Hi I have a Form that includes a subform. The subform contains 4 fields and a check box. ie Quantity Integer PriceA Double PriceB Double Total Double PriceCheck CheckBox On the Open Event of the main form a Message Box appears asking whether PriceCheck is to be checked or not. After the...

Hi Wayne I think I've solved the problem. I had just dropped a check box on the form so it's wasn't stored. It was not a field in the source table. I have included the Euro check box in the Table Invoice as a field and it works perfectly once the form is refreshed. I have have to remove...

Hi I have a form frmCurrency with two buttons one called GBP and the other EURO. On clicking any of the two buttons a second form frmInvoice opens on a new record and a check box called Euro therein is set. The purpose of ths is only to set the sign ie € or £ not convert the value. 'GBP...

Hi I've tried this but it does not seem to work Dim X X = Format([Text65], "$" & ([Text65].Value)) 'At this point nothing happens other than the assignment [Text65].Format = X 'With this line added it works intermitently? but it takes away the .00 ViRi

Hi I have a field on a Form that displays values in Sterling (The Default on the machine) ie with the pound sign before the numbers. I need to change the sign before the numbers to Dollar at a click of a button. I'm not interested in actually converting the values from Sterling to Dollar but...

Thanks but I don't know what to do with the four DB Files. Please Advice. ViRi

Is there any way I can download the Linked Table Manager Utility as I need to install it and I've lost the Office 2000 CD ViRi

Hi I have a form with a button and a text box The control source for the text box is a Number field called FileNo in a Table called File. THe default value of the text box is 0. When the button is clicked a value is calculated using the last value under FileNo in the Table. The problem is...

Hi I have a form with a button and a text box The control source for the text box is a Number field called FileNo in a Table called File. THe default value of the text box is 0. When the button is clicked a value is calculated using the last value under FileNo in the Table. The problem is...

Hi I have a form with a button and a text box The control source for the text box is a Number field called FileNo in a Table called File. THe default value of the text box is 0. When the button is clicked a value is calculated using the last value under FileNo in the Table. The problem is...

Hi I have a Form called Products. Each product is uniquely identified with a primary key called [ProductID]. Products contains a calculated field called [UnitsOnHand]. [UnitsOnHand] gets its values from a subform called ProductTransaction that exists within the Products Form...