Recent content by jappianing

Hello Pat, Thanks so much for your guidance.

Dear Alan, Your video really happened me. Everything is working fine for me. My only concern now is how to incldue a date field on the form. On the original table there is a field called purchdate, but on the search form I want the user to be able to search by DateFrom and DateTo. Your thoughts...

Dear All, I would be very grateful if any of you could help. I have designed an advanced search form which will be used to search for all our equipment in the Access 2010 database. The form is based on a query called SearchEquipmentForm. The query itself was run using a UNION query called...

Thanks John

Dear All, I would be very grateful if anyone could be of a help to me. I have designed an advanced search form which will be used to search for all our equipment in the Access 2010 database. The form is based on a query called SearchEquipmentForm. The query itself was run using a UNION query...

Hello Paul, Thanks for the info. I will try to reduce the number of tables in the query to say 10 and see what happens. Many thanks. joe

Thank you guys for your response. I will reassess what they want me to do and get back to you. Cheers

Thank you very much for your quick response. I will try it tomorrow. I'm almost done for the day.

Hello Brethren, I seiously l need your help urgently. I'm trying to run a query on 20 unrelated tables. Some of the tables are related. I used the query wizard but the wizard returned empty fields. I tried to manipulate the SQL code using RIGHT JOIN, LEFT JOIN OR OUTER JOIN, but to no avail...

Hello Brethren, I seiously l need your help urgently. I'm trying to run a query on seemingly unrelated tables. I used the query wizard but the wizard returned empty fields. I tried to manipulate the SQL code using RIGHT JOIN, LEFT JOIN OR OUTER JOIN, but to no avail. Your suggestions will be...

I am currently working on my first project as an Access DBA in a college institution. I’m learning the VBA programming aspect on the job, although I am not new to Databases. I used to work as an Oracle DBA. I decided to take a break from full time work and pursue my Doctorate in Instructional...