Search results

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...

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 ^...

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...

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...

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...

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...

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...

I have a <person> table, a <house> table and need to register people's tenancy in these houses. First thought is to create a <tenancy> table with foreign keys to <person> and <house> tables. So far so good. A tenancy will have a start date and an end date, no problem there. However, a...

Hi. I am up to version 4.0 in a database to one of my clients. The database is used at different locations and all work independantly from one another. Now, one of the sites want some special work done (additions) to the database. I want to be able to maintain the "core" database and add...