Search results

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

Open db; one of the forms is set to open on db startup (close it); open form "F2_Attendance_Tracking"; just to the right of the text box labeled Dog 1, there is a combo box. Right now, if you click on that combo box, it lists all the dog/breed combinations that are currently in subform...

One quick note...the "method" currently shown in form F2 for bringing in the data is probably not the most straight forward. I've been playing around with options to "work around" this problem and so have been adjusting and readjusting the form/subform layouts and sources. Also, right now the...

Your summary of the problems sounds right. I've attached a "modified" version of the database...basically I just deleted records with actual client data and left in the few "test" clients that I had created when trying out data-entry on some of the forms I created. The Form that this...

Hello...and thanks in advance for any help. I got a form with fields: Class ID (unique), Class Date, Class Name with a subform with fields: Class ID (linked to the same field in Master), OwnerName, DogName The subform is based on a query; and the query is based on a table. The link between...

Hi. New to forum posting; apologies in advance for providing insufficient info. I have a form ([Attendance Tracking]) with a subform ([Name Lookup]). When designing the subform [Name Lookup], I placed two subforms in it's form footer ([DogLookup] and [OwnerLookup]). These are used in...