Recent content by Bob

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.