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

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

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

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

Hi I have a query that picks up 2 dates from 2 fields in a form. If I change the values of the fields the Query picks up the old values. I have tried Requery and saving the Form programatically prior to running the Query, but the only way I can get the Query to use the latest field values is by...

Hi I have to output records on a report based on user inputs. I have written the code below that populates a table and then creates a query. I was hoping then to base a report on the query created and run it within the same sub, but I get an error 'expression is too complex...' Private Sub...

I have 2 numeric fields one called Sold the other SoldSum on a form called frmProduct. Sold receives a value from another form when the user clicks on a button. I would like SoldSum to add the values that Sold receives every time the Sold value changes I have tried this code on the...

I have 2 numeric fields one called Sold the other SoldSum on a form called frmProduct. Sold receives a value from another form when the user clicks on a button. I would like SoldSum to add the values that Sold receives every time the Sold value changes I have tried this code on the...

How can I reset my Tables without affecting the Relationships ViRi

Hi I have a simple database where I wish to force only Upper Case text even if user inputs Lower Case text, how can I do this? ViRi

Hi I have a numeric field called FileNo and an autonumber field called FileID in a table called tblFile. I also have a lookup numeric field called FileTypeID (with values 1 or 2 or 3) on another table called tblFileType. I need the value of FileNo which I am showing on a Form frmFile to change...