Search results

I am a bit puzzled by this one so would appriciate any advice that can be offered.. I have done a test split on my database and set it up on my server at work. It is on 2 desktops and one laptop with dual monitors. All of the monitors are the same make model size etc but on two of them the...

Whilst testing my DB I have stumbled across an issue that is confusing me !! I have a Cbo for occupation - as it is not vital data the user can add to the list if a new occupation is required and not there. The issue I have is that if someone puts in "painterr" the notinlist event will fire...

Thanks Bob. I will look into that when I start doing the custom ribbon and keep my fingers crossed !! Will post back with the results thanks again

Is it possible to disable the 'File' tab on the ribbon through code? At the moment I have a login form set up and depending on the access rights of who logs in the whole ribbon will either show or not show. DoCmd.ShowToolbar "Ribbon", acToolbarNo Whilst going through some testing it has...

Byron - thanks for the reply - I think we may of discussed this prevousley in hindsight !! Gnasch - thanks for tip Gina - thanks again ! I have worked with Mr B an awful lot with the devolpment of this current DB and without him (mainly) but also others on this forum, I would not be anywhere...

Im not entirely sure but something tells me your not happy with his service !! lol Thanks for the tip I did actually consider getting this

no probs - glad you got it sorted

Thanks Gina, I have read the first link already but will look through the 2nd link later today Thanks for taking the time to reply.

Thanks for the replies guys ! I had a eureka moment just before reading this and worked out it would be better to use the 'Clear Dates' cmd to disable the other cmd button - thanks Jdraw on the same thought patterns there !! Byron - thanks for the reply will email you soon hopefully this week ...

Hi Guys I am getting confused trying to code a button after dates have been entered in two boxes - Start Date and End Date On opening the form the cmd button (View Reports) is disabled. The user enters dates in the Start and End date boxes, once this is done the cmd button enables. However if...

Hi Sabrina, If I am understanding you correctly you want to turn off tab control on the forms? In Access 2010 you go to File, Options, Current Database and un-check "Display Document Tab" and that will do it. Not sure if this is the same in other access versions though !

Hi guys Is it possible in Access 2010 to create a new ribbon to show when a particular report / form is open? I have read loads about being able to customise the ribbon and very easily added my 'test' tab but when i go back into Access all the other default tabs - Home, Create, Database Tools...

Hi Mark, Thanks for the reply I have looked at this all afternoon and did go back to change the code as suggested by 'Thales' so my issue is resolved but in reply to your response the problem with the subforms of the Navigation area is that they are all called "NavigationSubForm" so you can't...

Good point ! Unfortuntately Im so far int the design of the DB it would mean changing a hell of a lot of code for it work (with all the other permatations used by the Navigation form). Surely there must be a way to go back to the form - Anyone?? thanks

Thanks For the reply, The problem I have using 'me' would not work here as its the navigation forms I asking the code to open.. So I tried using Forms!Navigation ect but this did not work either. When looking at the Navigation Area all of the subforms are called "NavigationSubform" (although...

Hi Guys - seems ages since I was last on here but am back to finishing off my DB and need some advice again !! I have a Access Navigation form, with subforms within each 'button' one of these buttons is called 'Treatment Menu' (NavigationButton19) On the 'Treatment Menu' subform (called...

Ahh thanks Dave That actually makes sense to me - I appricate there are amny combinations but Im pretty much stuck with the questions so don't have much choice. luckily it only has to be done form one main form !! Thanks again

good point - No!! I will look into that now - thanks for the reply

Could someone please tell me how I can handle responses to various msgbox's. At the end of a from the user is presented with a yes / no msgbox. Depending what the response is relates to what happens next. So in my case if they answer Q1 with yes they get Q2 if they answer Q2 with Yes...

many thanks, I will give that a go and get back to you