Recent content by GolferGuy

Thank you Moke. (o: Problem is, I need all the combo-boxes I have, and most of my queries have joins in them. I have found when you normalize data, joins in queries are a must. After I finish my current addition to the application, we are going to change from having an Access DB backend to...

Colin, I really believe you will find this app very pleasing to the eyes. This is the Home screen, and there are 10 separate photos that are displayed here, completely random. Only one photo per opening of the DB. The horizontal tabs you see here are for me and the boss only. Everyone that...

Pat, a subform is just that, a subform. It is a form that is embedded into another form. Not called by another form, but embedded in another form. Please re-read my previous posts again, don't try to second guess me, but listen to what I'm asking about and for. I do have 24 years of...

@Pat Hardman, Actually the boss has a great memory, mine is fading cause I'm getting old. (Please note this was only humor, hope you enjoyed it.) Both the boss and I have plenty of memory on our computers. But, we both use the whole database, not just one, two, or three of the tabs. It is...

@moke123, I have downloaded that DB and put the form into my database. I think I will be using it to manage the open forms/subforms by recording in a local table when a form is opened/visited. then as the user approaches running out of connections, I will close the least used, and oldest...

@Pat Hartman, The overall design of this database is to have the look and feel of the new (2010) navigation of the main horizontal tabs and the buttons down the side, but with the added feature of being able to return to the screen where you have been without having to relocate the record you...

Ridders, Thank you for the reminder. I never got any response or work from my website in about 10 to 12 years so I finally just let it go. I have not even been on this site for 4 or 5 years. When I posted this morning and saw my signature line I said to myself, "I should remove those." So...

I am looking for a discussion on using many, many subforms in one application. I have found that after opening one too many of these subforms, Access gives the error message, 3048 - Cannot open any more databases. I'm not looking for a discussion on another approach to this database that does...

Thank you all for this question and great replies! I have a subform used 5 times on a parent form. The subform show last month's forecast. If the forecaster wants to keep last month's forecast this month, a simple double click on the forecast number copies it to this month's forecast...

It means, that when in the Field Properties, and I press F6, the cursor is moved to somewhere on the screen, but I don't know where the cursor is on the screen. I just tried it again, and it looks like the cursor moves to the Database container. That is where the tables, queries, forms, etc...

In older versions of Access the F6 key would allow jumping to the field properties and pressing F6 again would take you back to the field name, data type, and field description pane. In Access 2010 the F6 key takes me from the field name, data type and field description pane to the field...

You can run a query, separate from the one that is the record source for your report, that can give you the count of how many rows (attendees in your case) you will be dealing with. Then there will be no guessing needed.

I did not see this the time before, but the problem here is that the REPORT (the sub-report) is being addressed, rather than the sub-report object. If the code were stated like this: srptRoster.Height = (20 / 3) * .25 * 1440 then the subreport object would be the object whose height was being...

Joanne, Thank you for that update. Needless to say, I had forgotten about this situation, but the knowledge you just shared I'm sure will come in handy some day soon. Thanks again for posting this fix.

Skip, upon re-reading your posts, I still don't understand just what you are trying to do. You said "I couldn't get the form to update those fields using the query as a control source." But earlier, it sounded like you wanted the query to be an update query. An update query can not be used as...