Search results

OK, you asked for it: I hate comboboxes for several reasons. Pardon me if I seem vague in some reasons as it's been years since I had the difficulties with them. I dislike the way the fields are handled as "columns," and the confusing string listing of them - it's (sometimes?) difficult to...

Thank you. Will do. One thing though, I hate Access comboboxes. I tend to get elaborate with the vba to avoid their use.

Yes. It designates the transaction type. So far, I have not encountered any type of transactions that would not be covered, and don't anticipate any. Oh, to elaborate: a cash transaction would be either deposit, withdrawal, or shift - a transfer to a new or different cash account within the...

This is the part I am talking about now, I cannot even create the main table because I do not understand how to do it without separate tables for accounts. I've attached what I have. I can't finish the relationships because I can't join both the debit account ID and the credit account ID to the...

I'm having trouble redesigning this to work off of 1 table, plus an account directory table and a broker table. Here's what I can't seem to understand. Each transaction has a credit account and a debit account, and the running total amount of each is subtracted or added on each transaction. So...

I was originally planning to use a transaction table, showing many binary properties of each transaction among other properties like transaction date & timestamp, broker ID, stock split ratios and amounts, and the 2 accounts of each transaction. Do you think I should keep that, or somehow just...

I am structuring this similar to accounting method, where I have a debit entry that matches the credit entry. So I need to make a form that makes two record entries simultaneously? I can do that in vba without a problem, but is there a way to do that in vanilla tables? MODERATOR: Perhaps this...

Oh, OK. I am considering that now. So instead of making separate tables, I just make two more fields in my account template, account number and account name. Yes, I see how that would work better now.

Perhaps. I have lots of pretty fancy stats I want to eventually track on my investments, such as gain & loss, taxes paid, current cost per share, dividends, per acct. and total of all investments, annual as well as total and per transaction, and the usual tracking of performance, etc.

Good day all, I am making a personal investment recording/stat database for myself. I want to make a form that 'browses' the transactions, so I can easily and quickly verify that my database is working properly. I have a transactions table, a table for the long text descriptions, and account...

Yeah thanx, appreciated! :) :)

I think you are missing the point: there is no "calc today" field in that table, the ONLY field is "ID". Thus I have to come to the conclusion that the error description is inadequate to describe the error encountered. I could do as you said, but it would accomplish nothing as it would still...

Hello, I'm trying to write vba that copies fields across TableDefs - I just want to be able to do that, as a learning exercise. I have written the following code to do so, but I get Error 3367: Cannot append. An object with that name already exists in the collection. In the line...

Oh, I see, nice tip :) TY

Thank you, guys.

That would simplify things quite a bit, as long as I am careful that the subroutine/function doesn't leave any crucial settings modified.

Hi, I just ran into the situation where I may want to pass a couple of recordsets to a function/subroutine. Pardon me for asking, but when I google this I get hundreds of misses on the hits. When you pass a recordset to a function/subroutine, I understand this is a copy, not a single shared...

Belated update: 16 GB SRAM and DoEvents DBEngine.Idle dbRefreshCache inserted into my time-consuming loops took care of the problem. :) My thanks to The_Doc_Man Isaac and everyone else for your help.

Actually I just pasted from a previous version save, and yes I did troubleshoot said extraneous comma and remove it before it would run. Apparently I used the save previous to that troubleshooting session, sorry.

Yes I did (actually in the popup window from MsgBox() from the immediate window). But I found that when I put it into the query designer SQL it didn't like 'SELECT "*"'. So I had to go to the "design view" and drag all the fields into the query manually. So then I took that code, which worked...