Search results

Apologies - this didn't make much sense to me. I just want to clarify then when I said that the code value is the table - it is in another query [CPARTY2] and not in the BU Table that I want my BU Form to post information to. That's why I thought DLOOKUP would be best. Does your solution...

I think I may be over complicating this so thanks for sticking with me. The Form I was using (called BU) was to post data to a table also called BU. I want the the Code field that exists in the table to automatically populate once the BU name is selected. So I think I may actually need the...

I have created a query called CPARTY2 with the relevant details in it and referenced this in the form - so the formula now looks like this: =DLookUp("CODE","[CPARTY2]","[CPARTY2].[NAME]=Forms![BU]![Business Unit]") The #error message on the form has gone - but the form is not automatically...

I put this in the control source section of the "Short Code" text box on the form. =DLookUp("[CODE]","[QTLIVE]![CPARTY]","[QTLIVE]![CPARTY].[NAME]=Forms![BU]![Business Unit]") CODE is the code I want the form to show. This is in a linked table that appears as QTLIVE_CPARTY. The link...

Do I enter this formula in the control source part of the text box properties on the form? thanks for your help

I have a table in my database called CPARTY that lists all the business units in my company. This table also has a field called short code. I have a form that I want to use to enter data into a table called BU. The form has a field called BU that pulls in the complete list of business Units...

thanks for your help. I would have spent ages on this!

Worked a treat - you are a star :)

I've put the following in: GtesValue: CCur([Bank Gtes].[ORIG_VALUE]) BGAPValue: CCur([BG Last AP].[ORIG_VALUE]) EXCHANGE: IIf([GtesValue]<>[BGAPValue],([Bank Gtes]![GBP_VALUE]-([GtesValue]/([BGAPValue]/[BG Last AP]![GBP_VALUE]))),0) It pops up with a prompt box for a value for GtesValue...

How do I do that? - within excel or access? thanks

I have two tables that are linked by a common field called 'reference'. i am running a query and want the query to post a text of "EXCHANGE OV CHANGE" against each record where a field called "ORIG Value", present in both tables, differs by reference number Expr2: IIf([Bank...

Thanks Gemma - We solved the problem - I just needed to compact and repair the database. The query worked fine!

It's obviously been a long time since any housekeeping was done! Thanks David:)

Thanks for your help - I compacted and repaired the database and now it is working fine - it recognises the correct number of records that it should be deleting. Perfect! I am however a little confused as to how the problem arose in the first place and how to prevent it again! At least I...

Yes - I was planning on running the delete query on the master table before running the append queries the following month. Only I use the data - so I can either delete after doing the analysis or before I run the append queries. The problem is not the timing more that the delete query...

To summarise I am running a number of different append queries on a monthly basis that post data into a table. I then run a report on this table which summarises the data. I then want to be able to clear this table so that the following month the table is blank before I run the append queries...

Yes - I am appending data into the table - and later on when I've reviewed the results in the table I want to be able to clear the table so that new records can be appended later on. Hope this makes sense!

I am using an append query to write records to a master table that I have created. I then want to create a query to clear out all the records from this master table. I have created the usual delete query - but when I run it it is saying that it going to delete considerably more records than...

Combo Box passing value to Query Thanks - The full Table command works - when I remove all the link criteria - but I now have another problem I am trying to pass the result of a combo box(combo13) to a query(Business Unti Select2. This query has [Forms]![Business Unit Selector2]![Combo13] in...

Fixed! Ignore me - I've sussed it -I didn't need the link criteria bit - so I deleted all that and it worked fine