Recent content by etalent

JeanW, Striker, I am heartened! In the earliest posts I was still trying to articulate the thing. Maybe just skip down to the later posts. JeanW, thanks for the relationship graph. I don't see the advantage of what you've done at first look. I'm getting pretty brain dead. I'm doing a bunch...

Thanks again and again for your help. I built this database myself, with no help from anyone else really. I have started over probably 100 or more times. I shudder to think of starting over again, but, of course, I will if necessary. I have all the data I need to create a sample batch of...

JeanW, Thanks for the reply. I am really relieved to get some help. Now that I've thought through the whole system for the 500th time, I think I have a good idea for how to do data entry. Here it is... first some background... The database, as it is now, has a test "batch" of checks that I...

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...

Thanks Ken. More happens than just setting values, however. Fields in tables get filled in too. I'm really close. This is so frustrating.

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...

Eric, did you get it OK? I sent it on Apr 5. Now it's the 7th.

Sending now...

Eric, Thanks... I did reply, but it never got past the fussiness of having to logon to this forum first, combined with the attention-dividing demands here at work, combined with the crappiness of my computer. Your question was as follows... "The Spanish table has the verb mentir in a field...

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...