Search results

  1. JokerUSN

    Updating a table using update query from linked csv

    Hi. I have a db of monthly costs and forecasts. As each month closes, I want to update the actual costs table from a download (csv) from our financial system which includes any prior months that were amended. Due to output format, I have to run a query to parse out the specific fields I need...
  2. JokerUSN

    Using List Box to filter subform

    Hi there. I have a form with company information and embedded is a subform displaying a list of transactions based on the company selected. The subform does filter the list off the Company selected in a combo box but shows all transactions the company has ever made. The problem I'm having is...
  3. JokerUSN

    quickly converting Date stored as text in a specific format to Date

    Hi. I have a bunch of data that has a date field in the format yyyymmdd. Is there a way to quickly convert it to mm/dd/yyyy in date format? Currently breaking it down with left/mid/right formulas and then Format(CDate()) but was hoping there might be an easier way. If what I have is it, then...
  4. JokerUSN

    Opening a form stand-alone

    I know I've done this before but I can't seem to figure out how to do it again. I want to be able to open a form/series of forms separate from the main Access window like it's its own application. How do I do that in Access 2003? Thanks!
  5. JokerUSN

    Button that returns to previous form

    I'm working on a db that tracks actionable items for an office department. I'd like to be able to get to some forms from multiple locations/forms and then be able to automatically return to the previously viewed form without having to create separate forms/buttons/macros that only specify one...
Back
Top Bottom