Recent content by paramesium

I realise I have to set windows pop up property to "Yes". Now I got it =)

Hi Alan, I did this using docmd.minimize on my file, but it doesnt seem to work, do you have any idea how to solve this problem?

Hi All, I am working on a database project where I will Select a record on a subform Please see the picture attached. I know that using DAO recordset, i can update the checkbox one by one, but it become way too long when I have thousands of record... May I know if there is a way to Select...

Hi Redalert, Thank you for your help last time, I am having great progress now. However, I still need some little advice from you. The program I am working on will be able to filter off the recordset on the subform using following method...

Hi Felix, I saw one of your post at http://www.access-programmers.co.uk/...d.php?t=240613 stating you wasn't able to make your program work with spacebar, did you manage to solve it? I has been trying but couldnt make it work. Hope you wont mind to share with me, thanks in advance! Regards, Jack

thanks John, but how do I maintain the search after a spacebar?

Hi all, I wanted to build a dynamic search form using text box instead of the common combo box type. After searching throughout the forum, I found an example that used the combo box and the searching portion of the code is as followed: If Nz(Me.txtID, "") > "" Then If Len(Nz(strFilter))...

Thanks for your help, Roku. Your method is working!

Thank you for your reply, I will try to take it directly from Query later. However, I tried the code, It dont open a single report. But If I do it without a for loop, that means I copy the code one by one, it works. I found it weird. Did I miss out any syntax error?

Hi All, I wanted to print multiple reports using for loop but I am not sure how to start with. This is basically my idea: 1. Create a hidden indicator, I name it txtHidden. 2. I have one table, there are one column for "report name". 3. I have one query, filtered the "report name" column...

yes! this is exactly what I want! Thank you so much!

Thank you very much on your ideas. I was wondering, how is the tbl_options being updated after it is binded with my data using queries. I mean, when I select the option, I am actually clicking button on the subform which the "table" came from the query that link tbl_Options and my table. What...

Actually I was working on a dynamic search function, I have already coded it on using a list. Is ok to lose the multi select property, but how do I link the subform with the list? is it very complicated?

thank you for your reply. Actually what I wanted is as followed: ----------------------- Name | Phone | Type| ----------------------- Joe | 123 | CB | Amy | 456 | CV | <--- Highlight this row James| 789 | CB | <--- Highlight this row Then, by pressing a...

Hi All, I wish to generate a new query consisting rows that I have selected in a multi colum list box. May I know if it is possible to work? I am totally lost now :( Thank you!