Ranman256's latest activity
-
Ranman256 replied to the thread Debug error???.FILTER spelled wrong. but you dont need to set filter = "" if you are gonna turn it off. So no need for it. -
Ranman256 replied to the thread Select Case Textbox.a control is not an event /nor value, so dont use : Select Case ctrl for every button CLICK EVENT send a parameter value to...
-
Ranman256 replied to the thread Solved Grouping within a group or grouping DLIST, is it possible?.make a query based on your table that makes the groups say: qsGrpData select *, Left([code],3) as Group, Format([mo] & "/1/2000","mmm")...
-
Ranman256 replied to the thread Module Import or Export.you can use the access menu: external data datasource from Access import select the db to import from select the modules & forms to...
-
Ranman256 replied to the thread MEMBERSHIP TRACKING DATABASE SOFTWARE.your query is labeled: Women Radio Membership DB Query, but it pulls only Men so.....shouldnt it be : Men Radio Membership DB Query...
-
Ranman256 replied to the thread Filter report with two criteria using combo boxes and button on form..another way: Public Sub btnOpenRpt_Click() Dim sSql As String, sWhere As String sWhere = "1=1" 'the query is built depending on...
-
Ranman256 replied to the thread Checkboxes and unique records..on the form ( fMyForm), a combo box holds ORIGIN items. also a subform that holds the list of all Products the list has the PRODUCT...
-
Ranman256 replied to the thread Total on Report.in the query add these calculations to get amts per CommType: select [field], AgentAmt: IIf([field]="Agent",[Amt],0) ,AdminAmt...
-
Ranman256 replied to the thread Solved Curious on Multidimension arrays.all tables are 2 dimensional as is your example array. the table/recordset IS the array, what more do you want to do with it?