Search results

Thanks for that. Please be advised that I have re-posted my question to the Forms forum, which I should have done to begin with. Much appreciated, apologies for any inconvenience caused. It is at the following address...

I have a combo box and a list box on a form. I am having trouble with making a selection in the Combo Box and getting the List Box to display the appropriate message. The following details explain the situation: Combo box name: cboClarity, when clicked it will display one of three values...

I have a similar problem but I'm not as confident. My problem is I have a combo box: cboClarity, which is based on a query qryClarityData. There are only 3 alternatives: "Average", "Good" or "Poor". I have a list box: txtExplainer on the same form which has explanations of what these...

Thank you for such a comprehensive article, I've taken a copy of it. Much appreciated

Thanks MajP, I'll read it. I know I need to set up relationships but I haven't always done that. My experience with this forum has taught me that attention to this kind of detail is important for the long run viability of the database. I'll study this article. Much appreciated

Yeah thanks, I just might do that. My only wish is that I had some VBA issue to access your VBA Savant ability. You've helped me with the Running Total problem, that's why I came to the forum so, that's a win. I think I'll bow out with what I've gained, Thanks for your help.

Just a small side note, when I opened up the Relationships window, the tblRaceTransactions was not connected to the other 3 tables.

I need to add some more information to the discussion: 1) I bet offline, I don't physically attend the race meetings. I'm betting in multiple locations on each race day. Which is why the RaceTime is so important. 2) The RaceTime field needs to order the races (along with RaceDate) available...

The RaceTime field is important in that it tells me what is the Next race of interest. Did that have to go from the Meetings table? I'll take a closer look at the tables and give any feedback, may I ask how long you'll be in the forum for today? I looked at frmMeetingsRacesTransactions the...

Done.

I've changed the qryRunningTotals_MajP query with tblRaceTransactions. I'm running it now and its giving me the "Add Parameter"msg for T.RaceTime, I'm not sure what that is about, can you have a look at it? I've had another look at it, I think perhaps it needs to be updated to the new structure

Thank you MajP I'm knocked outt! In a good way. You've put a lot of time and effort into this it looks great! One minor thing was I ran the query "qryRunningTotals_MajP" and it gave an error about could find transaction table. Looking at the SQL it has the name "Transaction" but I think it...

@MajP I wanted to say that there are frequent/some instances where I'll be placing 2 bets in one race. There hasn't been a case where there were 3 in one race but theoretically it could happen. I just want to bed down the table structure issue and move on to getting forms built. With my...

@MajP I apologise for missing some of the info you have shared. I have saved the code you put up, thanks for that. I'm not sure if I should scrap the Meetings table. My reason for having it is I don't ultimately bet on every race, only certain races (which I don't know about 2 days before...

As pointed out above, there are 3 stages to my betting process: 1) There is meeting information to be entered which happens 2 days prior to RaceDate when the official fields are released. These are RaceDate, Meeting, RaceTime, RaceNum and Distance. Just these 5 fields initially. 2) Next...

In my limited experience with Access, I learned that Auto Numbers were "essential" to a database. I don't necessarily agree with that info today, I would say that the Primary Key for this database is a composite of RaceDate and RaceTime. Any duplicates to that are where there is more than...

It is called RaceDate.

So the issue with RunningTotal is now resolved by Query 1. That's great, there are a couple of other issues that have come to mind since the initial post. See below, but basically there are 3 stages to this: 1) Entering the Meeting data - available 2 days before race day, 2) Entering bets on...

Thank you. I'll download it and have a look. I just ran it and it's great! I'll have to study the query and go to school on it. Much appreciated, it looks great. I've got to step away from my PC now. I'll have a look tomorrow, I'm in Australia, its the time zones..

@strive4peace Thanks for your help Crystal. I have uploaded a new database "SampleDB.accdb". It has lots of sample records in it and should provide enough data to help create a RunningSum object. My embarassment is over now, I'll be happy just to walk away with a solution to my RunningSum...