Search results

  1. D

    Summing records from current to last non-null value

    I have a section of a database that keeps track of gas purchases (see attached photos), called tblGasoline. I have constructed a subquery that will calculate the "previous" ODO read so I can tally the total miles driven since the last fill up. I am looking to create an additional field that...
  2. D

    VBA Code changes disappear if I save a subform when closing

    A particularly odd little scenario, and I am almost certain this is a bug. I have a form, [Financial Information] that contains a subform [chtWeeklySpending] which is displayed as a pivot chart, among other subforms. Whenever I make any changes to VBA code in the [Financial Information] form...
  3. D

    Question Question asking etiquette - using paragraph labels helpful or no?

    I just read the thread suggesting how to ask questions the right way, and now I'm paranoid that the method I used is more trouble than it is helpful, so I want to run it by the forums Generally, when a problem comes my way, I tend to search the web for a quick answer, then use MS Help (sadly...
  4. D

    Question Why are my tables/queries invisible?

    I have been working on a personal finance database, and suddenly, I notice that both my tables and queries are invisible. All of them. I know they are still there because the forms that use both tables and queries are working and generating all of the data. I also know that they exist...
  5. D

    Question How do I format a number based on currency used?

    Background I have a personal financial database that keep track of my accounts in three different countries, the US, Korea, and Australia. Goal I want to be able to display a report (or subreport, rather) of my accounts for each currency. Problem Korean won (KRW) do not use the "#,##0.00"...
  6. D

    Create charts/Subreports based on a listbox selection

    I'm sure this is not in any way an overly advanced procedure, but this is the situation. My Access skills are by no means advanced, but I do know a bit of VBA and have a cursory knowledge of SQL (I can read and understand it, but I could not write it from scratch -- so jealous of you kids who...
Top Bottom