Search results

Hi MajP, Thanks for coming back so quickly! They have asked for the 1 combo box to select the time in 1 go and they don’t mind the 24 hr format if it helps. I was thinking of defaulting the combo to 08:00 Thanks again - Kevin

Hi there, @Gasman - thanks for your input. @MajP - absolutely brilliant work! I have made the changes you suggested and I have formatted the frmStatus and it works fantastically - so thank you very much indeed. I really am thankful for your time with this. I have been asked if the time picker...

Hi Gasman, Thanks for your help. I have added a debug.print and I am going crazy! If I use the Me.JObStatus.BackColor = RGB(235, 12, 5) format, I get no errors (although it doesn't format my fields correctly, as they are all the same colour), but as soon as I replace the 'RGB(235, 12, 5)'...

Hi Gasman, I have actually used this; Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("tblDefault", dbOpenSnapshot, dbReadOnly) TempVars("ColourRGB01") = rs!ColourRGB01.Value TempVars("ColourRGB02") = rs!ColourRGB02.Value TempVars("ColourRGB03") = rs!ColourRGB03.Value...

I have added the TempVars and the rest of the code to OnLoad of the frmGrid, but it errors.

The end user has asked me the question, “what if I want to pick my own colours or add another status and apply a colour to that status as you won’t be around forever to add the conditional formatting!”

Hi MajP, Thank you very much indeed - works a treat! I have added a date to be shown in the 'pick week' combo, so the week that the selection is on, shows in the cmboDate - it was something an end user picked up on, so I've added it. I have been trying to work out how to use VBA to set the...

Hi MajP. I'll take a look next week and see what I can do. Thanks again and have a wonderful weekend. Regards - Kev.

Hi MajP, This is fantastic, thank you so much. When I commented earlier about working on it for 3 hours, I had failed to add the 'completed field' into the group part of the SQL code and it kept erroring. I have just added a status column and it has worked a treat! I've also added another...

Hi MajP I don't understand the SQL part of the DB and tried to add the JobComplete field into the SQL statement and it did not work. I have attached V5 Thanks again - Kev.

Hi MajP, Thanks for this, your advice is sound - I have taken the relationship out of the schedule table, as it is one person to one job. I have changed the dates to UK (dd/mm/yy) and the grid now starts on Monday, so thanks forthat (see attachment). Also, I have spent the last 3 hours trying...

MajP - This is Excellent, thank you very much indeed. I can see why you commented on my simple code as you did! Three questions: Can I just go through the vba to change the date format to English UK (dd/mm/yy)? How do I get my week on the grid to start on Monday - not Saturday? I have added a...

Hi everyone, first of all thanks for your help and in particular MajP for that work. However, I think I have solved the problem, but I am that bemused at the simplicity of it, I am doubting myself. Can I ask that someone has a look a the code behind my form (frmXTabSchedule) and just...

Thanks MajP - I await your help! Regards - Kev.

Hi Mike60smart, Thanks for this and for taking the time to look at my issue, but the 'standard' calendar view is not suitable as there could be as many as 50 or 60 candidates placed in any one day per week. This means that I need to display as per the grid/spreadsheet above and be able to...

Hi there, I have put together the barebones of what I need and added it to this thread. I have the relationships for each job, so that an employee and a place can be selected against each job and I have created the Crosstab query (qryXTabSchedule). The query populates as I need it to, but how...

Thank you both for your replies. I haven't started this project yet, so I'll put together the tables and a form and I'll also check out Gantt charts and let you know when I've done that. I have a funeral today, so it will probably be tomorrow before I can get to it. Thanks again and I'll post...

Hi there, Is it possible to create a schedule grid like the attached picture? I haven’t started this yet, so I’m open to all ideas, but I was thinking along the lines of having an Employee table (with all the employee details in), a Schedule table (which would have date, start time and end...

Hi Pat. Thank you for the welcome and yes, I will follow the advice given.

Downloaded and incorporated into my DB. Thanks everyone - good to have such great knowledge and support from the access community!