Search results

Hi, I have three tables; tbl_Exchange_Rates_CI Currency, RatesCI tbl_Exchange_Rates_MU Currency, RatesMU tbl_Exchange_Rates_PS Currency, RatesPS They all have the same data but each have one different felid, is there any way that they can all be updated at the same time? Thanks

Thanks They worked great....

Thanks vbaInet, I will have a look at that when I come to do the forms, but it might be best to have a separate field for the data to be entered and the expression in the query for my IIf statement. Thanks

Hi, I have the following IIf statement; MarkupCost1: IIf([Markup]='',([Markup]*[GBPCost]),[PSP]) What am trying to do is if the [Markup] is blank then show the [PSP] value, but if the [Markup] is not blank then do the calculation ([Markup]*[GBPCost]). The above IIf shows the [PSP] value when...

Hi, I will be using forms once I have sorted out the Tables and Queries. An example of how this is done in a form with me very helpful. Thanks

Hi, The Database is being built up from an Excel spreadsheet and they have there formula in there which I have done the Access equivalent, but they also over write the formula with there own data in the spreadsheet. This is what am trying to mimic. Thanks

Hi, I have a table with a felid that is called QtyCI, I need this field to be multi purpose. First it needs to perform an IIf statement; IIf([MBSTQT]>99999,"STOCK","003") Then if needed it needs to be typed over and data entered into the field. Can this be done or it best to have them...

Hi, I have a table in Access that I have imported from an AS400 using a Macro, here is the Macro that I used; Transfer Type: Import Database Type: ODBC Database Database Name: ODBC;DSN=mvxr10;TABLE=DATA09 Object Type: Table Source...

Hi, I am trying to create a simple search form, the form has a text box and a button. When a number is typed into the text box and the button is clicked I would like the another form to open on the record that was typed in. The data in only in one field not to complicated but can’t seem to...

Hi, Would this be on the form I enter my data as an After Update Event? Thanks Karl

Hi, I have a form which has a subform, on the form there is a button where a user can open a form to enter data into the database, this data once in the database should be displayed on the subform but to update it I have to close the form down and reopen it. How can this be updated when the...

Hi, Ok after looking closely I have worked out the quote marks and its all working now. But I have tried to apply a calculation though a query then sub form and it does not update the total but when entering data direct it updates the total. Is there any way for the data from the Dlookup to...

Hi SOS, Thanks for the response. I have made the changes, put the DlookUp in the control source for the field and placed the quotes in, I am now getting #Error which is more then I have had. This is the code that I have used, is that correct, also I have a macro for the COMBO BOX is that...

Hi, This is the code that I am using; DLookUp("ItemDetail","Sales_Items","ItemNo = " & [ItemNo]) To make it easy I have uploaded an test database that I am playing with on a small scale. In the Sales_Q form when the Item Number is selected I would like the ItemDetail to be retrieved from...

Hi, Seem to have some of this worked out, I have found an example of what I was looking for and that is using a DlookUp. But when I try and do this with my database it dose not work. Can any one provide simple example databases using this? Many Thanks

Hi, Thanks for the quick response. Could you give some examples of this or some websites? Thanks Karl

Hi, My problem is that I am trying to get a number of fields to update with data by only entering data into one field. Database Test Layout SQ:Table ID SQNo PK Name VTDate SQL:Table ID PK SQNo Item Dec YN Items:Table Item PK Dec YN...