Search results

  1. P

    Maximise Form on load

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

    Maximise Form on load

    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?
  3. P

    Update subform entire column

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

    Get SQL from data on the multi column listbox

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

    Hi Felix, I saw one of your post at http://www.access-programmers.co.uk/...d.php?t=240613...

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

    Search filter text box

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

    Subform filter with multiple text box

    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))...
  8. P

    Open Multiple reports using For Loop

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

    Open Multiple reports using For Loop

    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?
  10. P

    Open Multiple reports using For Loop

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

    Get SQL from data on the multi column listbox

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

    Get SQL from data on the multi column listbox

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

    Get SQL from data on the multi column listbox

    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?
  14. P

    Get SQL from data on the multi column listbox

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

    Get SQL from data on the multi column listbox

    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!
  16. P

    paramesium says hello

    Hi All, I am a newbie in Microsoft Access, currently working on a MS Access 2007 project. I hope that I can learn more about MS Access in this forum at the same time helping those who need help with all I have. Have a nice day ;) Best, Jack
Back
Top Bottom