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

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

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!

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!

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

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

SOLVED: Open Form Move to last record I am trying to open a form and move to the last record. I am using this code: Private Sub Form_Load() If Me.RecordsetClone.RecordCount > 0 Then Me.RecordsetClone.MoveLast End If End Sub It does not move me to last record, how might it...

Where do I set the Option Explicit setting for Access 2010?

Big dummy, but how do you post the Solved on a post? Thanks

Solved: What is wrong with this code This Code: Dim db As DAO.Database Dim rstAttendance As Recordset Set rstAttendance = CurrentDb.OpenRecordset(Name:="Attendance", Type:=RecordsetTypeEnum.dbOpenDynaset) With rstAttendance .FindFirst [Member_ID] = Me.Member_ID...

Been TOO long that I was away from ACCESS coding, used to be decent. Now, not so much. I have a table for Members, Events and Attendance. Want to get the Members that Attended each event. Have set up the Relationships between the Members to Attendance and Events to Attendance. I can set up...

Can one pragmatically turn the DatePicker attribute On and Off? Thanks!

I can set the doCmd.Open form filter programatically with the Like statement, using Contains I get a syntax error. What am I doing wrong, this works with the Like modifier DoCmd.OpenForm "frm_Members_1", acNormal, , "Last Like Forms![frm_Hidden]![Hidden_txt0]", but this DOES NOT work with...