Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. homer70

    Clickable design flowchart

    That's exactly what I needed. Thanks a lot.
  2. homer70

    Clickable design flowchart

    I have Visio 2007. Can I use it to create a flowchart where I can click on a decision and it will "send" me to the next decision? (This would be helpful in planning a complex db I need to do.) If Visio won't do that, are there any free tools that will? Thanks all.
  3. homer70

    OODB or RDB for checkbook/budget program?

    Gotcha. Thanks for the help everybody!
  4. homer70

    OODB or RDB for checkbook/budget program?

    What about SQLite's limitation to only the basic types, NULL, INTEGER, FLOAT, TEXT and BLOB? Is this a problem?
  5. homer70

    OODB or RDB for checkbook/budget program?

    I see what you mean. From what I've gathered I can have an OO front-end and an RDB back-end. Is that true?
  6. homer70

    OODB or RDB for checkbook/budget program?

    Hi, I wrote myself an Access db several years ago to do some things for my checkbook and budgeting and I've really enjoyed it ever since. Lately I've been thinking about writing it as a stand alone program so I could let my family and friends use too (I don't want it to be Access dependent...
  7. homer70

    Find most recently created files, add file sizes and compare sums

    Hi, I'm trying to get a bat file that decides which kind of backup to do by comparing the sizes of the most recent full and differential backups. This is what I am working with: 1) I store copies of my backups online. Due to my online storage provider's 2GB file size upload limit, I...
  8. homer70

    Terrible time with a crosstab query

    Yep. That did it. Thanks for all your help! It needs heavy tweaking, but hopefully the hard part is done. Thanks again.
  9. homer70

    Terrible time with a crosstab query

    It's alive! haha! Thanks for your help. It's crude looking but the data is there except for the payees. How can I get the payees to be listed on the left like in my first post above?
  10. homer70

    Terrible time with a crosstab query

    Using your instructions I created this query to get the payments for the last 6 months and made it the Record Source for my main report: SELECT Payee, amountdebit, datetransaction, Month([DateTransaction]) AS Mth, Year([DateTransaction]) AS Yr FROM tbltransactions WHERE...
  11. homer70

    Terrible time with a crosstab query

    As I was putting in the text boxes for TransactionDate and TransactionAmount on the subreport, I couldn't think of how the payees would be coordinated with the date and amounts, so I figured I'd have to hard key the payees onto the main report. No? Truthfully I'm pretty lost and trying to keep...
  12. homer70

    Terrible time with a crosstab query

    Hi dhookom, Haha, I think part of what I've found is that reports can be more complicated than I thought they could be. So far I have a report started (will be the monthly subreport x 12) that has a field for transaction date and a field for transaction amount (those are the only fields on it)...
  13. homer70

    Terrible time with a crosstab query

    I downloaded "Cross Tab (69 KB) Access 97" in your section, but the zip only had crosstab.mdb in it.
  14. homer70

    Terrible time with a crosstab query

    I must confess I didn't know there were such things as subreports so unfortunately I'm well below your level of expertise. Let me look at them and see if I can become more familiar with what you are suggesting and after that I may come and ask for more guidance, if you don't mind. Thank you...
  15. homer70

    Terrible time with a crosstab query

    Thanks dhookom. I may be mistaken but it it appears to my novice eye that the main goal of your suggestion is to organize transactions on a report based on the month and year of a transaction. I may be mistaken, but I was under the impression from what I've read that the hard part of what I'm...
  16. homer70

    Terrible time with a crosstab query

    I am having no success getting this thing done. I have designed a little db I use to keep track of expenses and bank account transactions that I've been using for a year or so and it helps greatly, but I need a report that I can't seem to figure out how to do. I've searched several sites but...

Part and Inventory Search

Back
Top