Search results

  1. C

    Loop Through Input File that does not contain field names and data is in different rows within a single column; Field1

    I have a Report file exported to text that contains numerous rows of information that will not be used. When the data is imported, it all gets dropped into Field1 in my table as the exported data does not have any reliable delimiters. In the middle of a record line I have a field I can collect...
  2. C

    Suspense Accounts - Cash Aging Report

    I have collected data for a designated timeframe (Beginning Date and Ending Date) for Multiple Suspense Accounts. For discussion sake, let's say the reporting period is 1 week, though it could be different at times. Additionally, I have collected data for 6 months prior to the Beginning Date...
  3. C

    Import comma Delimited xlsx file that has NO Headers

    I have an issue that I hope is child's play for someone with more experience coding than I have. I have an Assets.xlsx file that is actually a comma delimited file; all the data is contained within the A1 cell. I need to be able to append the input file's data into a table that I have defined...
  4. C

    Create Field Names in Table that are ever changing

    I have a table that contains data that is updated annually and keeps previous year data as well to reference - back 5 years. So, to keep data in proper perspective, I created fields (as Current Year, Year-1, Year-2, Year-3, etc.) to store and reference data values. I created a query to find...
  5. C

    Need VBA Macro to change subform SouceObject/Master/Child fields

    In my subform I have a [DueDate] field. I want to find project records that are not past due as well as the records that have been completed On-Time. I created a query that works and displays all the data I need. How can I use VBA code to change my SouceObject/Master/Child fields to another...
  6. C

    Use Macro Buttons to Run Different Queries against a Subform's Data

    Perhaps this will help to explain what I am trying to do. Please read through all of this post as the end might be easier to respond to than each of the individual processes I list: On my form, I currently have macro buttons that filter my subform for “Complete” and “Incomplete” projects. I am...
Top Bottom