Recent content by MarkA70

I cannot find a way to get a Report Page Footer Sub Total. In design view I add the field I want, click on the Totals button, Click Sum and it puts the field in the Report Footer section. Can you put sub totals on a Report Page Footer?

I work on a database for a non Profit that runs two events a year. These events take place in December of year 20XX and April of year 20XX +1. I am trying to write the code for a query that will have the date criteria such that it is like #12/1/20XX# to #5/1/20XX+1# to cover both events. I...

Sorry, I am an idiot, working with linked tables and the the tables in the reference database were not related correctly so it cannot be done in the linked relationship.

I am running Access 2010. I have a couple of Relationship Questions. A. Setting up two tables Tbl_1 PK is the foreign key in Tbl_2 which of course has its own PK. Relationship is One PK in Tbl_1 can have Many Tbl_2 records. A One to Many. B. Question(s) arise when. 1. I cannot check...

I have a form that allows the user to Click an Option button, fill in a text box and then Click the 'Find' Option button that resides within the same frame. Each option button changes its BackColor property when clicked. What I want to do is to change the 'Find' Option buttons BackColor...

I run an iMac, the Parallels software for Windows programs and Access 2010. Today I open the database I am working on and got a series of odd errors that I have never seen before and that did not exist when the database was closed last night. Upon closing and reopening the database none of...

I am an idiot, it do work, sorry, long day.

jdraw: That does not seem to work, it skips all text after the numbers. Thanks!

For the text capitalization issues the following works great, of course: Me.FirstName = StrConv(FirstName, vbProperCase) However, it does not work on an entry like 111 main st. I would like to be able to capitalize the Main an St. text. How's the best way, Thanks!

Thank you both, very insightful coding. Both solutions are very good, and this will help A LOT!

Two Text Entry Questions Solved I help with a database for a small Non Profit, we do not get computer literate volunteers, good folks, just intimidated. Need help with two problems on data entry. 1. How to strip a blank space out of a text box. That is they type in a name, but instead of...

What would cause the On Dirty event not to fire on a form. The form does not have data being entered programatically.

I have a form that has a button with the code: DoCmd.GoToRecord acDataForm, "frm_Clients_0", acNewRec I need a way to stop the new record if a button is clicked to discard changes. Have tried the me.undo but that does not work. Is there a way to stop the record being entered. THANKS!

MarkK and Cronk: THANKS a bunch. Wish I had asked this prior to spending about 24 man hours messing with this.

Sure, here goes: SELECT Attendance.Attendance_ID, Attendance.Member_ID, Members.Saluation, Attendance.Event_ID, Attendance.Event_Entry_Sequence_No, Aggie_Events.Event_Date, Aggie_Events.Event_Description, Attendance.Adult_Tickets, Attendance.Child_Tickets, Attendance.Guest_Tickets...