Search results
-
M
requery mainform unbound combobox using subform combobox value afterupdate
Hi Please help! I want to requery form1 from the afterupdate event of form2, but using the combobox value in the form2, as the form1 combobox value. In form2, I enter opportunity name in a text box and country selected in a combobox dropdown. The country selected in the combobox of form2 is... -
M
Openform method to open form & its bound subform on specific record in another form
Openform method to open form & its bound subform on specific record in another form Hi - All went well, I successfully can launch a 1st form from another 2nd form using a macro containing openform method attached the 'on current' event of the 2nd form. So clicking on a record in the 2nd form... -
M
Simultaneous form view & datasheet view
Simultaneous form view & datasheet view Hi, Hope you can help.... My problem revolves largely around ergonomics, where records are displayed in form view, but the user also needs to see a datasheet view or "list" of all the records, not just the selected record. So, form view on the left... -
M
Dlookup issues!
Hi Not being an expert, I have taken Northwind's approach to Dlookup, which works fine for BLPEuPrice, see below. I have tried the same for a different field in another table (Tbl_ProdCat4) but it returns always the last row value for the field InvFactor from Tbl_ProdCat4. I have a few one to... -
M
Relationships of a constants table
I am trying to create a table of constants using Dlookup (VAT, ExchRate etc) My problem is in the query design window, when adding the Constants Table, The query does not allow me then to create any new records in the last row unless I create a some kind of relationships. What relationships are... -
M
Constants table - How?
My issue revolves around the simple requirement to have a table where I can store reusable values, like VAT, exchange rate etc and access these these constants from queries to calculate price, inclusive of VAT, for example. For some reason this seems complicated to me, cannot get this simple... -
M
Splitting a single table into many tables
Hi I have a Products table that I need to divide into multiple tables, eg. Speakers, cameras, amplifiers etc. Dividing the table is easy, but I need to know the basic approach and methods used when a using multiple tables like this. Currently with one table, the database works fine, but do not...