Recent content by trab

I have a linked table, and i've created a local table by copying (structure) only. When I come to append records from the linked table that satisfy a given date range, I get the INSERT INTO error message. Any thoughts?

I do have a clinician table, but unfortunately, the text for the signee of the letters often differs from the text of the names shown in the table. I'll try the VBA route then.

I have imported the text of medical letters into an access table tblLettersText. Each line of the letter is stored in a memo field LineText. Each letter is electronically signed, and I wish to put the name of the signee/clinician into a field Clinician. Sometimes the name of the clinician...

Thanks Jdraw, Following the tektips link, this can this be done then by appending a new property to the query definition(?), and assigning the new description to it. Presumably, I can update the new property as and when(?). I'm writing a large number of SQL queries in VBA, on the basis of...

When you right-click on a query in the navigation pane, you can go about changing the query's object properties. How can you modify the same using VBA?

So if, as part of the linking criteria, I wish to link on the location, how might I do that, if the codes on each table are different? You might say just link on patient ID and the date, but sometimes the drug (cancer drug) is issued on the pharmacy system in advance in preparation for the...

No it's in transactions. Why is the ward mapping table useless, if I have different codes for the same location, depending on which table they are in e.g. for ward 1, say, it's WD01 in transactions, and W001 in the patient visits table?

Hello, I work in the NHS, and I'm linking drugs expenditure to patient visits here, linking on : date; consultant (ConsCodeNat); location; There is also a mapping table for locations, mapping locations on the one table to those on the second. The two tables, transactions and...

I'm using MsAccess 2007, and I have two large tables of data, say tbl01 and tbl02, which are added to each month, and I have to update tbl01 from tbl02, based on different sets of linking criteria. This can take a long time. Would it help, if I appended to a temporary table with linked records...

Thankyou all. Not the answer I was hoping for, though - I wondered whether access would have some trick up its sleeve, maybe somewhere in the Build option. I have over 40 update queries, and I didn't relish having to edit them all. In the end, I went along with the VBA route using a variable for...

I have table which I add records to on a monthly basis. I then populate fields using a succession of update queries. I would like to update a field, which tells me which update query was used to update that record. Is that possible without simply using free-text? KR Trav

Many thanks for your quick responses (tell me where the thanks button is and I'll hit it.):) I do have Access 2007 on my PC - I do have problems running two versions of Access. This is a necessity as I run some software which generates, can you believe it, Access 2 databases, which Access 2007...

The problem being, though is that I'm effectively using a Access 2003 database, and it doesn't like 2007 files(?)

I've been downloading an Excel data file from a website for some time now, and with a link to it from Access, I was able to import the data to a cumulative table, but a month or so ago, the export facility on the website was updated. When I download the data now, the link in Access no longer...

A long time after the event, but I wonder if this ever got sorted. It would have been useful to know. I have a form with three subforms, and when I close the main form, I get a succession of 5 parameter value requests, all seemingly relating to 2 controls on the main form. The 2 controls are...