Search results

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

Below in blue is the code I am running: Private Sub AddtoEvents() Dim db As DAO.Database Dim qd_AttendanceUpdate As DAO.QueryDef Dim prm As DAO.Parameter Dim AttendanceUpdate As DAO.Recordset Me.Event_ID =...

I have a listbox with Column 0 set to a Primary Key. I would like to use a combo box to select a value with the Bound Column of the Combo Box being the same Primary Key as the Listbox. How do I get the Listbox to show the row of the Combo Box's value?

I am trying to remove data from a table that is not needed. The code is shown below. When the Sub is called I get the error that 'Item Not Found in this Collection' I have checked and rechecked the query and the item is in the base query Public Sub CleanUpAuctionItems() Dim db...

So here is what I did. Created a matching table with different name, with the Primary Key being an Auto Numbered but Random field. Created an Append Query that Appended everything but the Original Tables Primary Key. Then swapped names on the Tables so that New Table became Old Table and vice...

Solved: Strange Table Performance/Response MS Access 2010. I have a VERY simple table, no look ups or whatever. Primary Index is an integer, increment field. There are no other indexes in the table. I had not had to use it for a time, today when an attempt to enter a new record via form...