Search results

i have a form with 40 text boxes on it. i want to assign the same code to the onclick event and ondblclick event of all of them, is there a quicker way than creating all 80 code sections. can i create a custom event that will check whether it was one of the textboxs clicked and pass a handle or...

hi after spending almost an hour trawling and testing various methods, can someone please explain how to initilaise the combo box value at runtime. i have a combo box with 5 items in it and i need it to point to item 5 when the form displays. should i be using .listindex or not ? tia

HI how can i add an object ( in this case a textbox) to a collection by using its name ? colmycollection.add me.day1 - this adds the object day1 to the collection ok. but i want to be able to add multiple objects using the count value of a loop dim strcontrol as string ' or should it be...

Hi i am using the weekdayname function but it has been returning the wrong value when i use the default setting. I set the start day to vbsunday and it worked correctly. i checked the vbUseSystemDayOfWeek and it is returning 0 where i presumed it was going to return 1. My question is where do i...

i am looking to code up a form which will display a 'clickable' calendar for a chosen month/year. my prolem is, the best way to get the correct dates to show under the correct days. At present i have 5 row of seven columns with an (additional) heading on each column fot the day of the week (...

Hello Is it possible for me to change the group permissions from within VBA ? For example. If i add or import a new table into the database rather than use the security settings in access to change the group/user permissions, can i code it onto a form for editing from there ? I can list all...