Search results

I have main form (called frmPCLog) and I had 5 queries with different results (like sum, count, totals etc.). I need to get those results in queries and put it all together in a single form using text box, and save it in another table (name tab_report) for report purposes. I got a suggestion to...

ok, my situation is I have my main form (called frmPCLog) and I had 5 queries with of course different results (like sum, count, totals etc.). I need to get them and put it all together in each text box within single form and save it in another table to create report. I want to save all the...

Thanks for enlightened me. ok i'l try to work it out with the subforms. Best regards, JErry

ok i'l try to use sub-form, since im newbie in access and my knowledge is really basic. Thanks for the help. Regards, Jerry

hi, can we assign more than 1 recordsource in single form? if possible, can you please teach me the syntax or setting up the recordsource in the form? Thanks, Jerry

hi, can we assign more than 1 recordsource in single form? if possible, can you please teach me the syntax of setting up the recordsource in the form? Thanks, Jerry

Got it, thank you so much. Regards, Jerry

hi nedkelly, where can i find the Recordsource, is it in the properties or i should write it in the form? please bear with me, im really newbie in access. Please can i get the proper code to get this value in the form. Please help me. Thanks

Hi flect, what's wrong on this query, I have 6 records and 3 of them has cc_code equals to a,b,c and the rest are e,f,g. I believe cc_code = abc description would be "BS" otherwise "VOCATIONAL". When I ran the query all DESCRIPTION are "BS". SELECT tab_course.cc_code, tab_course.cc_desc...

hi all, me again, I learned how to create query on this forum and i am comfortable in doing it thanks for all the help. I have something to consult to anyone, how can run the query in the form? I want to get the value of Amount in the query and display it in the form. SELECT tab_sales.desc...

Hi Flect, Please bear with me, Im new in Access so I really eager to learn more. Anyways, thank you for the reply.

Hi All, How can I write a query using IIF condition with multiple condition, I have 3 course_code [CS, BSN, HRM] and i need to display the corresponding description in the form not in report. I created a form, having 2 text boxes for course code and for the description, and command button that...

hi all, I have a report and a form, wherein i just grab the value of the report (say Total of a field as Total_Ded) and put it in the textbox by means of Control Source = =Reports![Total Deduction Report]!Text14. The value of text14 will be store in another form. If the the value is 0 or...

Thank you so much, it works. Best Regards, Jerry

Hi All, I have a combo box which has 3 columns field value, and 2 text box in the form. name, hunt_no, extension_no When I select the name in the combo box, I want to get the hunt_no to put in the textbox2 and extension_no in the textbox3. I tried to use BoundColumn but it didnt work...

since date/time is present on the field value like "1/5/2009 00:07:35 AM", can I just change the date format to "short date" to eliminate the time, coz I dont need the time anyways. I just after the date, after i run the query i want to view the filtered date based on value that I keyed on the form.

THanks Brian, Im looking forward to it. Best regards

Call start is Date/Time [data types] - i dont have access to my company's Phone Server that's why I dont have authorization to change the settings of the field. I just imported the CSV files from server. in table Call start field has value of "1/5/2009 7:02:00 AM" but on the forms, the value...

Good Morning Everyone, I'm getting stuck on between date query, it always shows null value when I run the query, SELECT [Smdr(backup1-5-2009)].Party1Name, [Smdr(backup1-5-2009)].[Call start], [Smdr(backup1-5-2009)].[Call duration] FROM [Smdr(backup1-5-2009)] WHERE...

double posting. Hi boblarson, sorry for that, if i dont get the answer from my previous postings, im sure they didnt get my question if my queries are too long or confusing. I re-posted the same topic and re-phrase it. Now i know it might cause me banned from forum, please dont let me get...