Search results

plog, CJ_London, MajP, MadPiet, Thanks for your ideas. Impressed by the quality and speed of your replys. (y)

Hi, Excel is fantastic for what I am trying to do with Access, but this is a fun challenge. Creating a budget tool, where each row (continuous form) is an account (general ledger) and each column is all months of the year (Jan..Dec). The budget table is normalised table of budget info...

Thank you for your ideas, Doc and Pat! Definitely a lot quicker to implement and maintain than my current approach. Fun times ahead implementing this.

Thanks. It is exactly the bloat issue I want to avoid. What do you mean by "overlay the previous copy"

Hi, I create a temporary table on the fly using DAO. A couple of fields needs to be of type dbDecimal. The <Field> object does not provide the Precision and Scale properties, but <Field3> does. I struggle to use <Field3> and gain access to these to properties, perhaps my references are not...

Hi Currently writing code for a financial function to calculate Internal Rate of Return for a series of payments and associated dates. Code works well in most case, but will occasionally give me an error namely "Invalid procedure call or argument". This is the code gives an error: dblRate ^...

Genius! Thanks.

Thank you arnelgp. This works perfectly. How can I then add CurrencyDate to the subquery as I'd like to show if there's a gap between TransactionDate and CurrencyDate?

I have a table of payments in various currencies that needs conversion to local currency. tblPayments table looks like (PaymentID PK) PaymentID TransactionDate CurrencyCode PaymentAmount 17 4/3/2023 EUR 512.00 Conversion rates are provided by tblCurrencyHistory where PK is a composite...

Managed to solve problem by using an unbound report with two subreports. There must be a neater solution though... 🤔

I'm getting rusty. It has been a while... Two tables, one for person and one for gadget. One-to-many relationship, a person can own multiple gadgets. I want report to first displays all people contained in this report. Below is a list of all gadget owned by people. (The normal approach would...

Found the solution elsewhere. In case someone is looking for the same it was Bob Larson (MrExcel, MVP) who provided a solution that works in my case:

Hi there I have the usual setup with a front and back end. I want to copy three of my tables from the back end to another database (backup) at regular intervals. When using docmd.CopyObject and docmd.TransferDatabase it is the link that get copied (naturally) and not the table itself...

Hi. I have and tblOrders table with the usual PK/FK relation to tblOrderDetails table. ProductID in tblOrderDetails table is FK to tblProducts table where details about which warehouse the product is located. I need to create a query that return those records where an order is shipped from...

Saul, You can link directly. For questions please start a new thread. This way others can better make use of all questions and answers.

I am building an investment portfolio database (another one, yes I know) I am currently analysing the transactions ie. Buys and sells of shares (& bonds) plus interest and dividend payments. There are more types of transactions but let’s leave that for the moment. All transactions have a...

Hi I have two fields on a table, let's call them Category and SubCategory. Both rightly should have 'Required' set to Yes. Possible values for both fields are done with lookups so I use a combo in both places. When I select a category the subCategory will need to be requeried. All good when...

Thanks Banana and LPurvis. All very useful and very much what I was looking for. As I was planning to use ADO I thought of having a simple boolean controlling whether we were in a transaction or not. Declaring my connection object WithEvents should fire BeginTransComplete, CommitTransComplete...

ADO only chosen in case I want to move it to SQL server (perhaps MSDE). But then I would probably use a stored procedure for this, so... I haven't run into problems (yet!) but I have a vague memory that one should be careful, so I was just looking for some general guidelines. Thanks. From a...

Hi there I have a series of statements that needs to be carried out as a single unit (transaction). (If one fails, all should roll back) I intend to use ADO and command objects on the mdb backend. What is good practice? As I build and execute the various appends and updates I need to do...