Search results

sorry for the delay in responding. thanks for the suggestion. , i will look into the screen.activecontrol to see if it will fit my needs for the moment i have added events to all the boxs :S thanks again

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

ok, i have traced part of this issue down to the bound column setting of the combo box. but i have differnet results on 2 different combo boxs. One has been set to display the months of the year which i have populated a design level using row source and row source type. if i set bound column to...

that will achieve the result i need in this case Bob but if the list contained something else that was not covered by a function in VBA how would i go about telling the combo to display the value? It seems that whatever i have tried to do with this combo, it will not allow me to tell it to show...

still doesnt give me the values i have added but is giving the index in the combobox this is what i am using where first year is static and set to 2008 Public Function Populate_cboyear() For i = year(first_year) To year(Date) cboyear.AddItem CStr(i) Next i cboyear.SetFocus Me.cboyear =...

i wont know the value at runtime, it will be calculated as the form is opened so i need to read the index and change it to point to the last entry in the list. The list could contain 1, 2, 5 or 20 entries. so i need to populate the combobox in code and then make it show the last item that was...

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

thanks bob that has allowed me to add the control i needed. how ever i didnt quite get the giving it a control name ( in this instance i dont need to reference it by name) but could you clarify for future reference. Is this like giving it a key ? thanks NVM - i looked it up and can see it is...

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

ok - call off the dogs , i think i have found the problem. After trying the things you guys suggested and getting bad results compared to your own, i visited control panel and found that the first day of the week was set for monday. I have no idea why and as far as i know it hasnt affected...

i have also tried jdraw's debug code and it also returns tomorrows day not todays.

i have put the following lines into my code (to debug) :- tdim = DateSerial(year(dtdate), month(dtdate) + 1, 1) - DateSerial(year(dtdate), month(dtdate), 1) testdate = WeekdayName(vbSunday) fdom = WeekdayName(Weekday(DateSerial(year(Date), month(Date), 1)), , vbUseSystem) based on todays date...

sorry Bob i have posted an edit to the original question and seemed to have cross posted with yourself. where does vb get the value for the vbUseSystemDayOfWeek ? if the other values are offsets from that, then it must be wrong. as i stated in the edit everything else appears to be ok with the...

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

thanks for the links - they look as though i can use them as is but i will take alook a the code ( if possible) and maybe redo it to suit my needs

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

ok, thanks for the info. I will have to try a few tests and see what is possible, am i correct in thin king that using these forms modify the MDW file rather than the DB? I dont think any changes will work while the table is in use, but hopefully will take effect next time the user opens said...

so this is basically launching the same forms as from the access menus when logged in as an admin ? do i have to elevate the user or create a new workspace or something before using them to do administrative tasks within the actual DB ? can i use this method to alter the backend database as...

i am developiong in 2010 but ideally need it to run in 2003 onwards thanks again

Hi and thanks for the reply. i am not aware of the form you mention, could you elaborate please ? thanks