Search results

Thank you.

So trying to build a form, and not sure what is happening. I click form design, and I don't have header/footer showing. I right click and add those. Bring in a combo box that I place in the header, and connect to it's data source. Switch to form view to check it, and I can't see it! If I...

The address and the number of holes are the only repeaters anyway, as course and slope ratings are all specific to the tees. I'm not even sure I will keep addresses, I was just trying to show what a table might look like. I do play the majority of my golf at one location, so those things don't...

What I do actually is simply treat each set of tees as its own course. At my home course I tend to play different tees depending on time of year, playing partners, etc., So I would have Augusta National Blue, Augusta National White, Augusta National Green all as separate courses. As I...

So I must post a mea culpa: re:the hole listing, I thought I had mentioned this already, but upon further review, I had not. In the first file I posted, I wanted to randomize the names of the courses I had played so as not to reveal any location data. Rest assured I have not played any of...

Thank you. I thought I had cleaned all of that up. Good catch. Done.

It's tough because for this to work, you need to be able to tie that stuff to each other. I've tried to minimize as much as possible. More importantly, try to make sure the base is set up right.

So what you displayed in the screenshot is almost what I would say a report or query would look like, at least to my thinking. I would almost be thinking about the form being relatively plain and utilitarian, but maybe there is something to this. I have to say as much as I am wanting to learn...

Now I looked over your file you posted, which was quite nicely done. I haven't posted anything back because I've been just trying to get some learning done, but my overall thought on the components on this, and you can tell me if I'm wrong, was that a)the tables would be where the data was...

So I've been messing about, and think I may have a path, but I am getting stuck at one spot. I'm building a form for inputting shot data. I want to have Cascading Combo Boxes for Course, then hole. But can cascading combo boxes draw from separate tables? I would want the CourseName from...

So what happened there was that without the course name, it was showing round number and then the hole # of that particular round. My thought process was somehow looking at the hole ID should bring in the proper course. i.e, HOle #24 is Augusta National #6(and in the form that is what you...

Thank you. I will go through this and see what came about. Not sure whether to be proud or dismayed I made your head spin....:ROFLMAO: ETA: My apologies. I should have adjusted it first. I had started on a new layout trying to get the courses lined up better. Something went haywire and I...

Are you referring to how I have tblHoleListing looking to CourseList? I have to admit, it's likely my way of learning, so I am stuck on what I know? Could I ask you to be a bit more specific? I'm not saying you're wrong, I'm just not seeing what you are saying.

So essentially I have what I posted above. My sticking point seems to be the hole information on tblShotData. When I try to create a form(for further adding), I can only choose numbers. tblHoleListing displays the course name, but tblShotData(which is looking at tbl hole listing) only gives...

Here are the updated relationships. I still need to tie Club and lie. Will also do the PK, FK thing afterwards. Thought I removed # from the field names, and I have removed score from tblRound_Log My big question is that in the shot data(and maybe I won't care about this with a form), for...

I only have tables so far. So just post the full file?

Tons of good stuff here, and I really like your idea about splitting course and hole. Fantastic. Getting to work on some of this now. Thank you. Question about id in tblShotData. Ideally I would want to be able to incorporate the roundID, the hole and the stroke on the hole. I know there is...

OK. Replies/thought process. 1. Autonumber. I will incorporate. 2. So here is the thought process behind that. When I enter a shot, what I need to input are the hole I was on, the stroke of the hole(1st, 2nd, etc--although that could be calculated), the club, the type(tee shot...

Thank you both. Upon reading, I do have a course list table but it's not linked yet as I was still trying to get the rest figured out, but based on what you have said, I likely have a circular relationship about to form there as well. It will take me a few days likely to digest and get this...

Here is a screenshot of my relationships. tblRoundLog and tblShotData are the only ones that would see any form of regular additions to their tables. @MajP I am not sure how to post what you are asking unless you simply mean post the entire file? This file is meant to compile all my shots over...