Search results

  1. R

    Trying to re-format a date

    I have this query with various dates per record, i.e. status tracking. Each record has values for at least the first date, but not necessarily any more dates. I've tried to create a Public Function which will return the string value of month & date: 1/15/2015 "0115" 2/1/2014...
  2. R

    Year over Year comparison

    Thanks in advance for any help. I would like to create a query where I provide an As Of date to be compared to a number of fields from a table, and create an entry if ANY of the date/time fields match the month/day criteria. For example: 1 3/31/2012 4/05/2012 4/15/2012 2 3/31/2013...
  3. R

    Library Reference Problem

    I recently "dusted off" an older application, Access 2010 running under XP. I went to make some changes in a Win 10 Pro environment, and discovered that just about all the RecordSet operations failed. In particular, I have a simple screen that generates the following error code: "Operation is...
  4. R

    Post-Reverse Split Reference Error

    I'm using Access 2010, and after reverse splitting a database, I'm getting reference errors on a number of methods and functions that were working prior to the reverse split. One such example is .FindFirst " .....". I've checked the references in VB, and everything appears correct. One of my...
  5. R

    Totalling a SubTotal

    I have a report that has Detail, Lvl1, LVl2 and Grand totals. The Detail field is "Vote=Y/N". I'm trying to create a field which is a total of a subtotal and NOT the total of the detail. For example, Detail A1 - Y A2 - Y B1 - Y C1 - N I want a result based on counts of "Y" vs "N" unique to...
  6. R

    Variable Referencing

    I'm relatively new to Access, but am a long-time programmer. I'm confused on variable scoping. I have "form1" that has a button which initiates a pop-up "form2". The data contained in "form2" is a child of "form1". I am using a pop-up scenario since I already am displaying another child on...
  7. R

    Totalling Calculated Fields

    I have a general question re: reports. If you create a numeric calculated field from data within a table, can you total that field by referencing the Name associated with the calculated field? I'm obviously missing something, since I keep getting asked "Enter Parameter Value" for the [calc field]
Back
Top Bottom