Search results

@arnelgp - THANK YOU VERY MUCH. This is now working as it should and the end users are VERY happy! Thank you to everyone who commented and for the time given to resolving this issue. I had spent hours and hours on this and to have it resolved is brilliant. You guys are great.

I agree. I’ve spent so long trying different things but to no avail. It will be interesting to see what DBguy has done.

The schedule grid is frmGrid, but it has onload criteria that restricts access. The form frmmainmenu uses the login to set the restrictions. Then select schedule grid.

Hi DBguy. I have attached the front end, back end dummy data and a DoNotDelete DB (which is usually encrypted) with licence info in it. When you first go in, the login screen sets user rights and other info, so select the username Eileen and the password is Dover, this will give full rights to...

Thanks DBguy, anything you can do would be very much appreciated.

Hi Gasman, Thanks for this - I have edited my original post. I hope this helps someone to help me! Regards.

Hi Gasman, How do I do that?

Hi Dickyp, So does this mean that the user can't set more than three from a form - instead, I will have to 'pre-set' the CF using the conditional formatting button and not allow the user to choose their own colour scheme?

I have the Microsoft Office 365 for Business (Version 2410 Build 18129.20116)

Hi all, I am getting the error... An error occurred: The format condition number you specified is greater then the number of format conditions. I have a table that lists the status details of a job (see attached jpg) which allows the user to select (from a form) a fore color and back color...

Hi both, I have solved it using 2 queries. 1st query (query1) links tblRoomDesc to tblEstSub (using the room number) I used the form to populate the criteria [SubMainEstID] with the ID Number for the record I want and this returns the 6 rooms used for that record. 2nd query links query1 to...

Hi Gasman, Thanks for the reply. I have 2 dropdowns - 1 labelled 'Add a room' and 1 labelled 'Edit a room' and if the user selects edit a room, it only lists the rooms already added (I did this because there are 28 variations to rooms and it saved them scrolling down). It's actually the...

I have a table that stores rooms (i.e. Bedroom1, Bedroom2, Living Room, Bathroom, etc.) it has the primary key as the room number (autonumber) and I have 2 tables to store information about the room. tblEstMain holds the main room information tblEstSub holds the individual items listed for the...

I have a query that lists products and prices and a form that I use to print Various product price lists. On a form, I select a product group and I can print off the current price list. For certain purposes I want to include zero value sell price (it highlights to me that i need to add the...

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