Recent content by spartansFC

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

I think you're right that i do need to add a status to each PermitNo but i'm still not sure how that would work or where do i add the status. When a user is entering a new parking permit, they select the permit no via a combo box, then i somehow have to attach the status there I'm so confused...

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

Thanks for the help Andy, it was a quick fix in the end, don't know why i didn't think of it. in the combo box i had SELECT tblBookings.lngPeopleID, tblInvoices.lngBookingID, tblInvoices.lngInvoiceID, tblInvoices.strInvoiceNo FROM tblBookings INNER JOIN tblInvoices ON tblBookings.lngBookingID...

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 Duane It does work, on the OnClose event i have Forms!frmCustomers![frmCustomersBookings Subform].Form.Requery This seems to do the trick

I really appreciate your help Duane. Thanks so much

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

Thanks for your help again Duane, got the report to colour code things

to be fair, i'm not sure what i'm doing. i was trying to use your crosstab query you helped me with a while ago which works perfectly, the full query i'm using for this new problem is: TRANSFORM Min([FundedDesc]) & Chr(13) & Chr(10) & Min([lngSessionTypesID]) & Chr(13) & Chr(10) &...

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

So somehow i managed to get it to work, there's always a workaround i find in access, anyways my solution was in query: qryBooking8StudentWeeklyCosts, the SQL looks like: SELECT qryBooking3Calculations.lngChildID, qryBooking3Calculations.FinYrGrouping, tblPeople.strForename...

Hi So i copied and pasted the new sql query, the results are below. It still doesn't list all 52 weeks, i even tried changing the query slightly but nothing seemed to work lngChildID FinYrGrouping S.strWklyStudentCostsWkNo C.strWklyStudentCostsWkNo strWklyStudentCosts SumOfChargeableSessions...

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