Search results for query: *

I have a working code linking all table.I want to rearrange it so that the table "calls" is not linked.Can you help me? My code is the following: Public Function LinkAllTables(DBName) 'link all user tables in source database Dim FrontDB As DAO.Database, BackDB As DAO.Database Dim Tbl As...

I have got something wrong with my combo box.I have tried to build a combo box to choose the city for each contact but i fail to do that.When i choose the city from the combo box in the form, it is not saved and also all the other contacts get the same city as a default.I see i get the things...

Thank you so much !

I have the following working updating function which is ok: CurrentDb.Execute "UPDATE Products SET office = products.grossprice*0.72" I want to add on a condition depending on the field “code” in the same table products. But I do no know how to do it.I do not want to use a form but otherwise...

n my form I have 2 columns, namely products.office and productsOld.office. They contain prices.They are mostly identical but sometimes they differ.Is it possible, when they are not identical, the row to be red? I know that for forms it is not possible, but maybe I am wrong ? for example: namely...

Visible controls In my form the code for making controls visible and invisible does not work. My code is the following: Private Sub Form_Current() If Me![supplierid] = 1 Then Me.RaufGrade.Visible = False Me.RaufCode.Visible = False Me.AralGrade.Visible = True Me.AralCode.Visible = True ElseIf...

Thank you very much for the helpful advice!

Can I apply a filter on the subform? With my main form, called frmoffers, I choose the customer and then with the subform I choose the products.I want to place a button on my main form to choose the supplier, for example: strFilter = "products.supplierid = 1" Me.Filter = strFilter Me.FilterOn...

want to look up in the table products and find the code but only for those products where the supplier id is 2. My working function is : =DLookUp("grossprice";"products";"Code=" & [Code]) How can i attach this condition?

I have a query consisting of the fields productid and customerid.It shows the products bought by the customers.These products are bought with different orders.Therefore they are repeated many times for one and the same customerid. I want to show however only the clients that have bought this...

excellent! Thank you very much !

On my form i want to build a dlookup control looking for the code in the query "QryProductSales" with the crieria called code.I have the control code in the form and i want to look up for the data with the corresponding code in my query.I have built partly the control but i could not define the...