Search results

I tried and it doesn't seem to be the way I want it to work. let's say the control field for Current Date says 29/8/2011. Then the first of those three controls should show August, then the second and third show September and October respectively. if the Current date changes to 1/9/2011...

These are controls on a form bound to a query with a number for each month. 1 for Jan, 2 for Feb 3 for Mar and so on. I would appreciate any suggestions or alternative solutions as long as it can solve the problem. Thanks a lot!

I have three fields on a form of months in the correct sequence. i.e Jan, Feb and Mar. I want these fields to automatically update into the correct order based on the current date/month. I.e today is 29th of August, I want the fields to show Aug, Sept, Oct. Is there a code that I can input...

Thanks John, This is really helpful. A second question to this topic; How can I auto-clear the selected values in the listbox for a new record? Thanks!

Hi all, I am a newbie in Access, and I have made a list box on a form that can have multiple selection. Is there a code I can put in the On Click event in the property settings that can help me to store the multiple selected values in one single field in a table where the values are...

I am a fresh beginner in Access so please take my apologies if I haven't explained the below issue clear enough and let me know so that I can further explain it in moer details. I have two comboboxes; Combo A and Combo B, coming from the same record-saving table but within that table they are...

I would like to create a subform with 3 columns. 1st column should list of about 20 time intervals which is fixed 2nd column should be dropdown/combobox with tasks that the user can choose for each time interval 3rd column should be dropdown/combobox with teamnames that the user can choose for...

Thanks a lot John!

The caption on the command button is fixed, but I forgot to mention that I have 10 command buttons with different suername and I want the username on that textbox to change accordingly. Thanks so much for the replies! I tried it and it works! :))))) ******* One further question, so now...

I have a command button showing a username and also a textbox which is linked to a table with usernames on the same form I want to autoupdate the textbox to show the username on the commandbutton when I click on the commandbutton. Does anyone know the VBA codes for the on_click event...