Recent content by terces

as i've read on other sources, PIVOT and UNION queries are not supported in Jet. I think there's still workaround in this case.

okay, it took me time but i still cant figure out where to insert the UNION. please refer to my post below: PARAMETERS [Forms]![ProgramsF].[ProgramStatusYear] Text ( 255 ); TRANSFORM CLng(Nz(Count([CountYearQ1].[Status]),0)) AS CountofStatus SELECT Program.BARProgram, Status.Status FROM...

Hi, I have attached part of my db to ask for assistance. I need to show the complete rows for all the status in each year with or without any record/data. Maybe this is very simple task, but i somehow can't manage to do so.:confused: Thanks in advance, Terces

the subsubform is not visible since it's also a subdatasheet in which you can collapse and expand from the subform

Hi Guys, Once again I am needing an assistance, same matter with the finances and calculation referred from a multiple record on a second level subform. here is the situation: I have 3 tables: Projects Releases Liquidations Given that, for every project, there will be multiple tranches of...

is same code to be used if my sourcefield is a combobox?

yea, i did this in the form instead of query before but if i do this in the form...then the concatenated field in the table would be dependent on the other field which would fail the NF1 afaik.

sorry, but i don't know how to handle errors..and i haven't used update query yet so basically my grasp regarding this is very limited.

indeed a very simple reply. but I wish to know the exact idea. what I like to achieve in query is: Agency_Name Agency_Count Agency1 1 Agency2 1 Agency3 1 Agency1 2 Agency1 3 Agency3 2 Agency5...

I have a query named Project_Code which have the common fields plus this: <[Agency] & "-" & [Research] & "-" & Format([Date_Started],"mmddyy") AS Code> to auto-generate a serial number. What I need is an auto-increment based on the max count of agency field so as to avoid duplicate on the first...

It really sounds complicated but is sure solved my query. No need to redesign. Cheers! you're amazing!. Thanks a lot!

Thanks for the assistance...but how to do so? use setvalue? Honestly I just embedded this macro from microsoft access templates and I am not really a db developer, just learned from asking and googling. Thanks again.

I have been googling it for days...now i'm thinking to redesign my db...sob

Thanks for the help...I removed the close command but still having the same problem... master/childs linking can be done in VBA right? even for separate forms? i just got the idea but i don't know how to code it. I suppose Ms. VBA girl can help. =]

In the Agency List (form), i embedded in dbl click a macro in Agency Name (field) in which will open Project List (form) showing a filtered listing of projects from that Agency. The problem is whenever I add a record from that filtered form, error 3101 appears. "The Microsoft Office Access...