Search results

Hello, i have very little knowledge of vba, still there should be a solution my DB was working everything good modules etc After splitting front end command which calls this module Public Function fncNextShift(ByVal dte2 As Variant, ByVal teamID As Long) As String Static rs As DAO.Recordset Dim...

Hello, please help me on refrase this working ok sql from my form's listbox to same form's textbox value (because the need of conditional formating and more) SELECT Count(hreomenoylikotbl.ylikoID) AS CountOfylikoID FROM ylikatbl INNER JOIN hreomenoylikotbl ON ylikatbl.ylikoID =...

Hello, i was wondering if it is possible for a combobox which is coded to dropdown with an afterupdate event of a previous previous combobox, to not dropdown if it is empty..? That s what i need Thank you my code is Private Sub cboEidosypiresias_AfterUpdate() Me.cboOrario.Requery...

hello i would like some help, have this crosstab query QrPlanCross, with TRANSFORM Max(QrPlan.EidYpirSynt) AS MaxOfEidYpirSynt SELECT QrPlan.Epitheto, QrPlan.[A/A], Max(QrPlan.eidosypiresiasID) AS [Total Of eidosypiresiasID] FROM QrPlan GROUP BY QrPlan.Epitheto, QrPlan.[A/A] ORDER BY...

hello, i am trying to accomplish this in work there are 5 groups or teams working each day and weekends, in 5 different shifts (eg morning, afternoon, night, rest,day off). like in this example TeamShiftstbl ID teamID DateParam shift 1 1 1/11/2022 Night 2 2 1/11/2022 Rest 3 3...

Hi, as i am unfamiliar with VBA i need help with code on this purpose i 've designed a form with a button to insert records in a table which has a date column. When run from my query it is doing the inserts as expected (inserts as many dates in rows as month dates excist in calendar because...

Hello, i would love some help please In work there are 5 groups of people working in shifts like in my table “shiftvlisttbl” I would like to achieve this rotation with a query so given a year and month from form parameters and then another query, produce in my table “dutyrecordstbl”...

Hello, I need help to represent finished or future shifts, for each group of employees daily in each month (1 to 30 or 31 depending on month) in a crosstab query and then report Employee groups are A, B, C, D, E Each Group has to be represented with a regular shift each day of month...

Hello, having trouble specifiying email recipients in vba command syntax: I have a form with command to send email (click open report from my form and send attached report via outlook), it is working fine to recipiets whose emails are speciafied in vba For practical use, i need to send...

Hi all, Is there a way to eliminate #Error in calculated texboxes in forms? I have problem in adeiesfrm in my uploaded database..

Hi, i would like help to change a subform's recordsource by clicking a command button in my main form. Read some articles but still cannot achive it Main form name is adeiesfrm and subform's name is adeiesfrmsub1 adeiesfrmsub1 default recordsource is adeiestbl and i need changing that...

Hi, i would like a form, set to go on new record on load, Having in Header a textbox to inform reader as for " Employee Surname Name " every time is set to go around between records What i d like is form not to show anything when it opens with no records using so far =IIf("[ypalillosID]"="...

Please help, I am trying to replace combo boxes in my forms, to text boxes and.. i have a particular combobox with rowsource SELECT Tbl_Courses.courseID, Tbl_CourseNames.CourseName FROM Tbl_CourseNames INNER JOIN Tbl_Courses ON Tbl_CourseNames.coursenameID = Tbl_Courses.coursenameID; then...

Hello Trying to have a query that its records warn when date [RegDay] of a person [athleteID] comes as 30 days or less to complete 1 year passed from then to Date() , and if so in the calculation field [RenewReg], indicate if minus 30days, the days left to complete one year, if passed year...

Hello, i would appreciate help on my problem Having 2 subforms linked child/parent i am facing problem to have my athletes in second subform chosen by their gender selected in first subform ist subform is bound to Tbl_Races, second to Tbl_Times subforms are linked with textbox on main form...

Hello, i am stuck to a problem which is annoying Have a main form, Fr_Gala (single form) with two continues subforms (Frmsub_Races), and (Frmsub_Times) I need this to work like .. having swimming races in 1st subform, then in second subform which is linked as child to 1st, one could type...

Hello, i tried to associate value of a combo box between two subforms which are linked in my form Fr_Events Problem i guess is that desired combobox which is in second subform has no rowsource related to first combobox Specifically i need to populate combobox athletesID (in second subform...

Hi all, i wish i knew what is wrong with the query supposed i need returning records Main form called Fr_ScheduleEditor, subform Frmsub_CourseLastRecords. Subform has a single table as rowsourse, managed by SELECT Tbl_CourseSessions.courseID, Tbl_CourseSessions.instructorID...

Hello, Trying to get better i have much trouble providing code for my DB.. and i would like help on insert into fired from command button "cmdAllAthletes" on the subform of my form Fr_CourseSessions I would like to fill rows to Tbl_CourseAttendances for athletes registered in tennis course...

Hello, i have difficulty to produce proper code on an AfterUpate event In my Db in order to keep Attendance of athletes i have a main form called Fr_CourseSessions it has subforms to select Academic year Tennis Cource, Instructor etc All is working except: to make easier to track attendance i...