Search results

Hi Is it possible to select a row from a subform? The subform is not bound to any table; it displays lines of expenses that are entered into the main form. What I wish to do is to be able to select a row or record from the subform and thus identify that record in order for it to be deleted...

Hi I'm using Access 2007 and have a table for currency rates. The currency is picked up from the currency table and the date is entered manually which is then followed by manual entry of the rate. What I have realised is that it would be possible to input the same date with the same currency...

Hi I have one report which prints invoices and is based on a query. The base currency is GBP in which case the totals are in GBP. However sometimes a customer is invoiced in US$ and, in these cases, I need to show a conversion of the totals to GBP. When there is an exchange rate then the...

Folks Is it possible to rename the fields on a query so that the names aren't the same as the table that they're based on? My query is based on a number of linked tables via a read-only ODBC connection to an Oracle database. The fields, because they're very customisable in the original...

Hi I have an invoice-input form which allows a selection of Purchase Orders and Statements of Work from drop-down boxes. When I use the Add new command to add a new invoice I get an error message saying that the PO or SoW numbers are invalid if they haven't been filled in. This maybe because...

Hi Folks I have a form which is based on a query which joins clients, Purchase Orders and Statements of Work. The form is used to input Statements of Work as well as to view them. A ststement of work may or may not have a Purchase Order. When I attempt to input a new Statement of Work...

Folks I have a table for invoices. When populating the table I had hoped to be able to select a list of Purchase Orders limited by the ClientId. This works fine when I set the criteria in the Purchase Order query to equal the ClientId in the table which then limits the Purchase Order lookup...

Hi I'm aware that this has been asked before but I'm obviously doing something wrong as I can't seem to follow the examples. I'm using Access 2003 and have only just started using recordsets. I managed to add a new record by creating a recordset and then transferring values from fields in a...

Hi I have one underlying record set for a particular form. One of the fields automatically updates the underlying table being based on a calculation from another field. ie the field that needs updating is bound to the table. I can use the update event or similar on the calculated field to...

Hi Folks I have a query based on a table which gives a breakdown of sales by month, sale type and by cost centre (department). I also have another query which summarises the sales by sale type and cost centre so that and is based on the first query. the second query is a subform of the first...