Search results

Hi DBGuy, As you can see MajP has solved this for me, but a thank you to you as well - he used your function! Thanks and regards - Kevin.

Hi MajP Thank you very much indeed - this and the Grid issue you helped me with is brilliant. As I said, I'll take on board the lookup in tables issue and now it's been pointed out, it does make sense! Thanks and regards - Kevin.

Hi MajP I wasn't aware of the issue with lookups - it's all I've ever known. They are integrated into the main database, so I'll have to have a look at it, but i will take your point on board (after reading your link!) Unless anyone else can help, I'll need to re-think. Thanks and regards.

Hi everyone, I have hit a brick wall I am going round in circles trying to figure out the correct WHERE part of the Concatenation module from Allen Browne. I need to Concatenate the Qualifications for each candidate, but the query is returning all Qualifications against each candidate. So for...

Hi MajP, Works great - thank you very much! I need to give you a break now don't I ! I have attached the V14 DB changes, so that you can see where I've got to with all your help. A long way to go with the DB yet, but I am hoping most other stuff, will be somewhat simpler. Thank you very much...

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