Recent content by Someone123

gemma-the-husky, Thanks for the reply. I would like to understand more of what you posted, but I don't know what an NL is? My postings tables (transactions) has a foreign key field that references the primary key of a journal record (cotains a common description for both the credit and the...

Thanks for the replies Khawar and Simon_MT. It turns out that I already have a voucher_number field, only it's called Journal_ID and it links to the journal table that I mentioned! I would apologise for wasting your time, but I would not have realised that I had this facility as I inserted...

Good afternoon, I have a simple database that contains double entry book-keeping records, e.g. Getting paid £50.00 (moving £50.00 from account "wages" to account "cash" would be: ID | date | account | sum --------------------------------------------------...

Thanks for replying. The idea is that customers fill in a defect form, reporting defects in equipment. The engineers then repsond to this defect in a fault report form. The idea is to grab the "device", "date" and "description" fields of the defect and then copy them into the relavent fault...

Hi, I'm looking to include a button on a form that opens a new entry in another table and copies some field entries from the first table into the second table. I tried an append query, but it seems to be unable to be displayed in a form. I just want to copy data from one form to another. Thanks.

Thanks for any replies. Unfourtunately, I'm using MS access 97, and cannot upgrade. I have a report with time values stored in short format (eg, 12:00) representing durations in hours:minutes. The report also uses a date field to sort the entries by Month, Week and Day. I would like to have a...