Search results

Hi, I need advice and hope you can assist. I have a report that contact subreport in the footer and this subreport contact multiple page. for some reason, when the subreport print out. the header on the sub report only print in the first page and the next page, it all empty.. any solution...

Hi Again, I have a form that contain 2 sub-form and I would liike to know how to do a validation where the field require must have an entry? The field that I need to are: - Name - Country - Detail1 please open the frm_Main to see the sample Apprecaite your advice.. wongray

Hi vbaInet, Many Many Thanks for your advice.. The sample that you given works exactly what I need. apprecaited. regards wongray

Hi SOS, Thanks for the advice. I try and add it into the database but cannot insert the date into the ray_log field. can you have please advice? here is the sample data many thanks

Hi Again, Firstly, I like to thanks people who tough me a lot on how to use access programming, it does help me. I do have another question that I hope I can get an answer. I want to insert a date into a table (log) after I click a button in a form. but for some reason, I can't do it. here...

Hi Khalid Afridi. THanks a lot for showing me the example. I got it to work.. but when I try to do it and run in a bigger data.. I got this error. Run-time error '3021' : no current record. I did search in the net and said, that I can write a trap on it.. but don't where should I put the...

Hi VbaInet, Thanks a lot for the info, it is possible for you to show me on my sample? I'm pretty new at this and if you could do it under my sample data, that would be great.. Still learning a lot here.. Many thanks Wongray

Thanks All for the help. I still having some issue on how to insert those results into the table. What I would like is: Original Table = Tbl_Country Project_ID | Country 1 | Hong Kong 1 | Singapore 2 | Hong Kong 3 | Singapore 3 | Tokyo End results is to have this data insert into a new...

Hi Afridi, THanks, but I'm very new on this setup.. where should I put the code ? Can you help me to put it into my sample data? appreciated

Yes, so the results will be : project_ID 1 country hong kong , Singapore many thakns

Hi, I need help, I have a database that I need to combine all the country into one single field base on an ID. Please advice how to write a module to do this automatically, where I can remove the combine data, then append with the latest data.. here is the attached sample Thanks Ray

Hi Rabbie, Thanks for the suggestion. I agree with you on store the .jpg files into the database.. I should have explain a bit more details. What I want to is I have to create a database that specific a product ID and each product will have a picture display when the product ID is...

Hello, Need help. I'm planning to create a database that would capture picture into the database and able to preview it in the form. Could you please advise what is the best way to do it? My Idea will be: Product a - then it will display JPG files 1.jpg and 2.jpg Product c - display...

Hello, this work perfectly.. many thanks

Hello, I have a question that I hope you can help me. I got 5 check box in my database and I would like to make it where if I click on 1 of the check box, the other 4 check box will not be checked. For example, Check 1, 2, 3, 4, 5 if I click on check 2, 1,3,4,5 will be empty If I click...