Recent content by dmo

I have two tables in Access 2010: Tbl1 - Abbreviations: with fields (1) "Abbreviation" and (2) "Definition" Tbl2 - Piping: with multiple fields one of which is "Unit" In Design View of Tbl2, I'd like to set the "Validation Rule" for the "Unit" field so that it is restricted to values in field...

Dave (Male)! Thanks. That's an even better work-around. And a simple update. - Danielle(/Female) (Ellie and Sadie are mine! -- helping the dog training school I go to put together a client tracking database)

The bound field does contain dups (it's the name/breed field). I was hoping that by having the unique field (DogID) in the combo (but not as the bound field) it would resolve the problem. Any suggestions on work arounds? Fields in the subform include... the combobox (bound name/breed...

Hello and Many Many Thanks in Advance! I have a combo box in a subform. The combo box is "based" on two of the subform fields: DogNameBreed and DogID (two columns in the drop down; name is first, then ID). Every dog as a unique ID but, it is possible for there to be multiple dogs with the...

That's correct, pick a name in the combo box in the top row...click the "Add" button, and it adds the name to the list below. I haven't figured out how to get the "Remove" button to work yet but, goal is to use that to remove names if the wrong name is accidentally added. what do you think...

See attached screen shot...I wouldn't be surprised to hear I didn't do this in the most straight forward method...(hopefully the VBA/Access short course I'm trying to get my company to pay for will pay off and I'll learn some tricks of the trade). Note: in addition to what you see in the...

I looked at the link and your updates and now have this: Private Sub Command27_Click() Dim i As Integer Dim sSQL As String i = Me!SF2b_OwnersDogs.Form.DogID sSQL = "DELETE FROM Me!SF5_AttendForF2.DogID WHERE DogID = " & i DoCmd.RunSQL sSQL End Sub now I'm getting run-time Error 3131 (Syntax...

As noted in my original post, I don't really know how to write in code so, adjusting the "language" to fit my DB is not going to be easy. I tried the following but, the debugger is giving me error 3078 and telling me it can't find table SF5_AttendForF2. I'm quite certain I just don't know how...

I've found quite a few threads related to form/subform deletions but, haven't found anything that addresses this particular issue. And, thanks in advance for any help! Details about how the form is set up are provided below but, here's the gist of the dilemma...I have an "Add Record" button...

this worked. thanks.

vbaInet!!! I did it!!! (or...about 95% of the way there) I had the Form based on ClassesHeld (ClassID, ClassName, ClassDate) in SingleForm View so I'm looking at one class at a time. Then there's a subform (SingleForm view) with Dog/Owner info (not linked to Main Form) which allows user to pick...

This seems like the most simple of problems but, I can't seem to find an answer from searching this forum or google searching. I have a combo box which, when a selection is made from it, populates several associated text boxes. The functionality is fine. However, when I make the combo bok...

Let's say I adjust back to the original structure where the form is based on "ClassesHeld" (including fields ClassID, ClassName, ClassDate), and a subform with Attendance (including fields ClassID and DogID). In this way, the main form doesn't include the DogID field (only the subform includes...

sidenote: I'm currently scouring this Forum based on a search about "attendance" and have come up with a number of threads related to attendance tracking questions. (I actually see your name offering solutions to some of these questions too :)) Perhaps I'll find something in the search...

UGH! That's basically what I thought. The problem is, if I use the approach you suggest, I have to go to the page for each individual attendee (i.e. each dog), and say that it was in that class. Not very user friendly since in some cases there are A LOT of attendees in each class. My...