Search results

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

wonderful John (I think John) yes one extra parameter. thank you indeed

In reply to JHB, I should have had Races.[Race Date] in the select line and this field is Date data type.

I have uploaded the zip file I have changed the name of the name of the field so it's not just Date The button on the form produces the type mismatch error running a query without a criteria. Trust I haven't made any mistakes in deleting other components and code.

Thanks for the reply Here first is the straight SQL SELECT Rallies.Name, Races.Date, Owners.Surname, Cars.[Registration Number], Year([Date]) AS [Year of Rally] FROM Rallies, Races, Entries, Cars, Owners WHERE Owners.[Licence #] = Cars.[Licence #] AND Cars.[Registration Number] =...

Thanks Paul for the reply certainly sounds like a text vs numeric problem I have tried stCriteria = "[Year of Rally] = '" & Year(Date) & "'" and this makes the msgbox output [Year of Rally] = '2013' but I still get the type mismatch problem the [Year of Rally] calculated field in the...