Search results for query: *

Hi I have a table which shows a dteYear based off dteSessionDates but it's showing the wrong year, all i'm doing at the moment to get the year is: dteYear: Format([dteSessionDates],"yyyy") The above isn't correct and giving off some wrong dates 03/10/2023 = 2023 (which is correct)...

Hi I'm trying to add a parking permit form to my database, each person is given a unique parking permit number which can be handed back in and then handed out to another person. If a parking permit is already in use i don't want the combo box to show it, i can't think of a way to do it. The...

Hi The main set up of the database is: MainForm: frmCustomers, tblCustomers, lngPeopleID (PK) Subform1: frmCustomersBookings Subform, tblBookings, lngBookingID (PK), lngPeopleID(FK) Subform2: frmCustomerslInvoices Subform, tblInvoices, lngInvoiceID (PK), lngBookingID (FK) I've got 3 search...

Hi I'm trying to open a new blank record for data entry linked to whatever person/record i'm on. For example, i if i want to add new bookings to record 1 (lngPeopleID). I should just be able to click on the new booking command button, the form should open with the correct lngPeopleID with...

thread702-1705763 Hi the above thread was closed and I think Duane mentioned that there would be a problem when some dates that have 1 or 2 characters at the start. On the attached image i'm having problems showing the correct values as some dates have 1 character and some have 2 at the...

Hi I'm trying to colour code a text box based off values in a string. the string value in the query looks like Val: Min([lngSessionTypesID]) & Chr(13) & Chr(10) & Min([strRepValue]) this outputs values 25 B2 how do I get it to colour the text box based off of a string value which might be...

Hi I need to show calculated fees for all 52 weeks of the year, if there are no fees for a certain week, i need to show a zero for that week. my first query lists the weeks, the SQL is: SELECT tblDates.FinYrGrouping, tblDates.strWklyStudentCostsWkNo, tblDates.strWklyStudentCosts FROM tblDates...

Hi I've created a nursery database which records a daily record of a child's attendance, this includes dteSessionDates, ysncurrentsession, there's a few more fields but these ones are the most important for my problem. i currently show on a form the current information for the child via the...

Hi I've managed to do this problem in excel but i need to convert it onto access. The problem is i need to return a 1 when a child hits a certain date grouping. A child at a nursery will receive funding the term after they turn 3 so for example if a childs's date of birth is: 29.01.2016...

Hi I have a continuous form on a unbound main form and a command button that opens up frmFamilyCentre to record based off the continuous form. the subform frmChildList2 is bound to qryChildList the code to open Private Sub UpdateFamily_cmdbutton_Click() On Error GoTo...

Hi I have a list of children that may appear in different financial years and I need to work out their age based off this, in the example below Child1 was born on 12 Feb 2008 and appears in 3 financial years. Is there a way to calculate his next birthday based off Calc_Year and then therefore...

Hi I have a form called frmPeople which has a subform called frmPeopleSubPlacementHistory. frmPeople has the table structure lngPeopleID (PK) frmPeopleSubPlacementHistory has the table structure of lngPlacementID (PK) lngPeopleID (FK) there can be more than 1 placement which is where my...

Hi I need to somehow create a totals query which somehow extracts all the months between 2 dates, so for example if it was: 01/01/2013 to 31/03/2013, it would ouput Jan-13, Feb-13, Mar-13. The query i'm trying to create the totals query looks like: SELECT tblChildrenRunNumber.curRunNumber...

Hi I've created a few reports on A3 size paper just so that i can fit everything on the page. When users print out the reports they sometimes forget to change the printer properties to shrink the report to A4. Is there any code i can put into the report, command button that prints the report...

Hi I know how to create a query which can be used for mail merges but like anything, some situations are unique. I need to set it up so that the mailing label can say either: "Parent/Carer of John and Jane Doe" or "Parent/Carer of James Wilson" or "Parent/Carer of Fred Dawson and Jim Jackson"...

Hi I know how to filter reports via form combos but for some reason, a little glitch is happening, when i click the command button a pop up window appears asking to enter the paramater value, for example if i've selected May-13 for the combo box, the parameter pop up window will ask for "May"...

Hi I've used Duane Hookems recurring database example and created a form that populates booking information for a child's attendance from April 14 2013 to March 31 2014, the fields are: dteSessionDates ysnCurrentSession lngChildID lngClubID lngPickedupFrom lngSessionType curSessionCost and...

Hi I'm trying to get a unique count total from a crosstab, the data i have is ParentID TotalChildID New Old 1 4 0 4 176 22 0 22 690 22 0 22 1192 96 92 4 so my sql statement is TRANSFORM...

Hi So with Duane's previous help and his "recurring.mdb" database, i've been able to populate a table from a "start date to end date" to show a child's attendance on a daily basis at a certain childcare provider, the table design is: tblOccupancyBuildNewPerm lngOccupancyPermID dteSessionDates...

Hi I've got 2 bound subforms on a unbound form, i've created a filter search form based of Allen Browns example. The 1st subform filters perfectly and i've got running subtotals. I now need to somehow filter the 2nd subform based of the criteria in subform1. What i would like to happen is the...