I've got a database with five parent tables, three of which you can write to via their relationships, two of which you can't write to via their relationships. Some of the child tables can't be written to either. I've setup the relationships in such a way, so as to maintain data integrity.
Here...
Forms!frmPentaling!txtSyn = DLookup("[fldSpaSyn]", "tblVoc", "[fldVocID] = " & Me!fldVocId)
----------------
This is the code that works perfectly as far as viewing, but I still need to be able to enter new records. This code doesn't give me that.
The text boxes on the main form, in this...
I've got a form with a subform and three text boxes on it.
The subform is a datasheet view of the query that is the form and the subform's record source. This subform works perfectly. My problem is with the three text boxes.
What I want to happen is this: as I tab forward and backward through...
I need to migrate the database I created with Microsoft Access 2002 on Windows XP to NEC Mobilepro 780, with specs as follows: Pocket Internet Explorer (same as IE 3.0). Javascript, JScript, and HTML 3.2 compatible. No support for VbScript, CSS, DHTML, or frames. Screen dimensions are 640 pixels...
I've got a table with a column of text that is sorted alphabetically. On a form I've got 26 one letter labels of "A" through "Z."
I want to click any of the letters to navigate through the alpabetically sorted records. The "on mouse up" event seems to be the most sensible event to program. How...
I've got two combo boxes that work really closely to what I want, but they've still got 2 problems:
(1) When you make a selection with one combo box, the value of the other combo box should be (programatically) set, but as it is now I have to select the right value from each combo box...
I've got a simple database that has 4 tables and a form with 14 controls on it. The controls are all text boxes except for 2 combo boxes. I'm very close to getting the functionality right, but I just can't quite get it. I have found that my first attempts at getting help don't get too far maybe...
I've got a form. This form has 12 text boxes and 2 combo boxes on it. The way it's supposed to work is as follows...
(1) You fill in the first 4 text boxes then
(2) You select a value from either 1 of the 2 combo boxes, which
(3) Sets the values of 6 of the remaining text boxes (leaving the...
As suggested in a response, I've attempted to simplify my issue with this post. The best way I can come up with to simplify is just to assume you have downloaded my database and are looking at it. It's only 95 KB. I skip all the "education" and go right to inputs, desired outputs, logic...
I've got a little database for English, Spanish, and Portuguese verbs, which is comprised of 4 related tables and a form. The form has text boxes and 2 combo boxes. Rather than try to explain all that from the bottom up (as I did on my first try to get help on this), I'm just providing an...
How do I populate a field in one table by selecting from a combo box with a control source of another table?
I've got 4 tables, with fields and relations as follows...
tblInfinitives
fldInfId
fldConId
fldInfEng
fldInfEsp
fldInfPor
tblConjugations
fldConId
fldConEsp
fldEspTenseId
fldConPor...
How do I populate a field in one table by selecting from a combo box with a control source of another table.
I've got 4 tables, with fields and relations as follows...
tblInfinitives
fldInfId
fldConId
fldInfEng
fldInfEsp
fldInfPor
tblConjugations
fldConId
fldConEsp
fldEspTenseId
fldConPor...
Please help with combo box functionality!
I've got a database of English, Spanish, and Portuguese verbs, which is comprised of four tables. I've created a query that includes all of the fields of each table.
Here is my problem:
(1) Enter a new infinitive (enter a new record in fields...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.