Recent content by AndySuk

Hi Bob I've attached a screen shot. The thinking behind it is that the subform is based on a query which queries the expenses table for all records relating to the emplyee and month which is shown on the header of the main form. As expenses are entered there is some slq attached to the click...

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 Never thought of having a change event used in that way as I always use them with underlying data changes. Just a thought but, rather than having a boolean change on each of the controls (as I assume you have to have the event attached to each control and then test each one to see if the...

Hi It sounds like you could just not allow duplicates in the field in the underlying table (tblBasicData) that picks up the Position ID from your tblMCP. It's a little hard to know as you haven't said how your Combo and list boxes interact. I'm assuming that you pick a soldier from your combo...

Awesome. Thanks you both very much and for the link Bob. A

Ah thanks Ken but I don't think so. By doing that it would restrict the currency field to not being repeated within the table however the table will store the currency (as a currency ID) many times over but for different dates. I suppose I'm looking for restricting a duplicate record but ONLY...

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

Awesome! that works. Thank you very much Trevor.

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

Is it me or are you missing an ampersand??? Stick a "&" (without the quotes) so that rs!Field2 = rs!Field1 & " " rs!Field1 reads rs!Field2 = rs!Field1 & " " &rs!Field1

Hi As long as you have a table (table1) then you should be able to paste the code into a module and run it from there. If you're using Access 2003 then go to the Tools menu from your main database screen. Follow the menu down to "Macro" and click on the item labelled "Visual Basic Editor"...

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

Thanks Jal. I was hoping to pass the parameter direct from the table in order to get the functionality prior to using forms and VBA but I suspect that your way is the way to go. Normally I wouldn't want to input direct into a table but time is pressing hence the reason for the question...