Recent content by prmitchell

Hello I have a table - tblBarSessions - with similar data to the following which is just an example Subject ShiftDate StartTime eA Shed Lunch I: Bill 1/03/2023 11:00 AM bgates@iinet.com.au Bowls: Bill 8/03/2023 3:45 PM bgates@iinet.com.au Shed Lunch: Satya 1/03/2023 11:00 AM...

I have a recordset (titled ASBSelectedMonth) which is executed from a button on a form with the following fields emailAddress, ResidentName, EventName,SessionDate,Message1,Message2 I want to email each person in the recordset, they may be in the recordset once or multiple times, the contents of...

How do I email a recordset to an email address contained in the recordset - as a report or query - using Outlook as the application? Example of the recordset email FirstName SportName SportDate ActivityName ActivityDate volunteer1001@gmail.com Peter Lawn Bowls 15/10/2021 Oct Dinner 23/10/2021

In a subform I have participants who are either left or right (sporting type database) and as I add participants alternatively left or right I want to add up the total weight of participants on the left and right in the form I can add up the total weight of all participants (in the race)...

thank you Minty

path to the accdb file

Hello In Access 2010 how to add a file path in the report footer? thx

I'm looking to make a report that prints out a class/tutorial list as a seating plan. So whilst variable let's say 28 students in 4 rows and 7 columns as an example. I know how to store the data - but my question is how to print out the student names 7 across by the 4 rows? Easy as a list with...

I wish to open a form based on the transaction table populate one of the foreign key fields with a selected value from a combo box from the switchboard (with going to a mainform&subform). I know how to get the value of the combo box on the switchboard. I just know how to then store this value...

How does one remove the layout guide that is automatically included in a blank form in 2010?

thank you for your reply I don't consider there is any relationships just after anyone's thoughts for confirmation (or otherwise).

Thank you jdraw. Reasonably aware of database design and these kind of resources. I was really seeking a comment - does setting primary keys help to achieve privacy just that, is primary keys about achieving privacy?

I would be most grateful to receive any feedback/thoughts on this concept - which was asked in an exam question I have seen - where the scenario is a store keeping track of sales to customers outline how primary keys can ensure the privacy of its customers

Hi How do I prevent the value of a field being deleted by the user, which is occurring in a form, but how not sure, somehow they manage to knock out the suburb name from a Postcode and Suburbs table (which is a linked table). Peter

Is there any way of closing an access file when another user has it open (without logging on as them)? Peter