Search results

hi arnelgp , I will try looking this up , thank you .

is it possible to get a button to open a form on left click and do something else if same button is right clicked on? if so how please:confused:

thanks arnelgp, this worked great, once again you have proved a great help to me and others

hi arnelgp, tried this but did not save the color, it reverts back to original color, any ideas please

hi grumm thank you for your response , this is great, I cannot follow the VBA to learn how to use it yet , but as I say this is great, one other question is it possible to save the color picked so when the user opens it again it keeps the color he/she has chosen

hi all can you help please I have a front end form and would like to give the user the option to change the background color , what I need is on the click of a button to open the color picker so they can choose the coler they would like on the form and then the background change to the color...

thank you arnelgp for your quick response , do I place all code into a module? and how do I call the code from vba please. (please excuse my ignorance as I have limited experience in vba )

hi all is it possible to resize text boxes to the size of the form ? another words if I stretch a form then the text boxes expand/contract to suit , this way all text boxes would always be displayed , (sometimes when using laptop not enough room to see everything:confused:

what does Twips stand for?

hi all I have been trying to adjust the size of a text box with vba , if you look at the property sheet the sizes are in cm , but if I try to place this in vba it wont accept the cm (textbox. width = 6.25cm) how do I get around this please ? :confused:

hello arnelgp, thank you for your solution , it works a dream, just a few changes , well done , I have noticed that if you delete a record/row in the subform that it shows we have deleted a row but does not show what was in that row, so if this was accidently deleted I cannot replace it , is it...

Hi all can you assist with this problem please , I have a database this a main form [mainfrm]and two subforms [subform]and [ work details], when I open the main form I keep the subforms hidden until a button is clicked , the subforms are connected via a one to many relationship, all works great...

hi all, can you help please, I have a main form and a datasheet form , what I want to do is if I start a new record on the datasheet then a field on the new record [name] will auto update with the same value as on the main form from a text box called [name] how do I go about this please, if you...

hi ruralguy , thanks for your help, I went online and googled the where condition and have found the solution , that you for your help

can you show me how please

hi all can you help please I have a main form and what I am trying to do is open another form matching only records shown in a text box [text1] , I have a button to open the form so I need the vba so when I open the form it shows only what records have the same value as main form (datasheet...

thanks sneuberg, will try disabling the clock , will keep you informed

hi all can you help please , I have been given a form and when I run it the word calculating shows in the very bottom left of the window , it seems to be re calculating all the time , it does not seem to be stopping anything working but just slows it down , it has a clock on the front screen, do...

hi all , can you tell me the pro's and con's of each please, and which is prefered :confused:

thanks spikepl , this works great , I will try and read the vba to understand how it works