Search results

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

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

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

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

Hi Everyone, I come up with an inventory database, but i seem not satisfied with it. I got plans on how this would run for few users but i dont know what feature to use or ideas to come up with a better format. I can discuss my plans here if somebody wants to but in the mean time im attaching...

Hi to All, I have a main form (frmMain) and a subform (frmReport) where i select comboboxes and option frame wherein i have encoded in the search and preview button the ff: __________________________________________ Private Sub cmdPreview_Click() If Me.fmeReport = 1 Then DoCmd.OpenReport...

Hi, I am new to access and created a db thru e-learning. I need assistance on query criteria for running Total in computing finances on one of my query. Here are the following informations you might want to know. tblFinancial -finID (autonumber) -finGrant (currency) -finChkDate (date/time)...