Search results

I'll try to explain this as best I can. I am working on the queries and reports section of my database. My database consists of various data grouped by Month, Week and Department, and within each Department, there is a Category and a sum of Data. To open the reports, I want to allow the user...

I tried to do the bound controls, but I can't get it to work. Basically I have: Text box (locked, Subcategory name) Text box (edit-able, Data) Text box (locked, Subcategory name) Text box (edit-able, Data) Text box (locked, Subcategory name) Text box (edit-able, Data) Text box (locked...

But my fields are unbound, won't it make a difference? Thanks!

Is there a certain way to refer to subforms in the IsNull function? I'm trying to do something like this: If Not IsNull(Me.Controls("Forms!frmSupplyChain!frmSCProduction.Form!txtMat" & fieldNum)) Then where frmSupplyChain is my main, frmSCProduction is my subform Thanks!

I have a bunch of fields with different names, same format as txtMat# where # starts from 1 and onwards (txtMat1, txtMat2,...) I want to write a code that's something like If Not IsNull (txtMat#) where the # can be controlled by a variable which increments by 1 in a do-while loop. How can I...

Hi there, I have a database that collects information about company operations either monthly or weekly based on several different elements. For example: On the main form (frmMaster), there is a Date and Week combo list. (these write to tblMaster) On the subform (frmTest) there is something...