Replies

Thanks for the advice Hans

It looks like I am going to be opening and closing a lot of documents

Mich

Thankyou Stuart

Hi

Just wanted to let you know that after reading some earlier posts, it would seem our problems were caused by Microsoft Word being set as email editor in Outlook 2003.
We unticked this option and the macros work and word closes properly.

Mich

Hi Hans

Thanks very much, you are a star

Mich

Hi Hans

Thanks for the help so far. I am now 95% there. That gives all the new records the same “updated transid”.
Would it be possible to “loop” through the data so that if the transid increases in the “sampletobeupdated table” it also increases when the update query is run.

eg data to be updated transid is 10211 – new updated record transid is 26518
data to be updated transid 10212 – new updated transid is 26519 and so on

Im presuming I will have to create a routine where I enter the old transid and update it for each record

Thanks so much for the help given so far.

Hi Hans

tblStockDistribution

Hi Jeremy

I have attached a very small sample of the db, this includes the data entry form that user uses to enter the data. A sample table of data that I wish to update and append.

I want to update the the transid of the data of the “data to be appended” I presume this will be via an update query.
I would like the updated transid of the records to continue to follow the sequence of the data that i am appending to

Hopefully this makes sense

Thanks in advance for any help, guidance etc

Hi Jeremy

2 tables would probably be the best solution however this would involve reeingineering the whole database. I will try to attach a sample of the database to see if that explains a bit better what I am trying to achieve.

Hi Hans thanks for the quick reply

A bit of background, the data records stock transactions, but each stock item needed to be recorded as an individual record. The same transaction id is created for each stock item that is taken at the same time.

eg a typical records consist of
trans id
contractor id
stock item ref
quantity

What I have been asked to do is import data from an identical standalone database but update the trans id for each records so that they follow in sequence of the main datatable (the one they are being imported to) They could potentially have data with the same transaction id.

Hope this makes sense, I know what I want to do – I just dont know how to achieve it

Charlotte

I have 2 standalone applications written in Access 97 (both runtime) and I have been asked to create a routine via 2 command buttons which enables a user to export data and import data into their database. I have since found that the TransferText Action should do what I want and I presume it will work under the “runtime” restrictions.

Thanks

Charlotte

I have 2 standalone applications written in Access 97 (both runtime) and I have been asked to create a routine via 2 command buttons which enables a user to export data and import data into their database. I have since found that the TransferText Action should do what I want and I presume it will work under the “runtime” restrictions.

Thanks

thankyou

Thanks for your help

Thanks for that Mark

Could I also use this to add new records to the table?

Hi everyone, solved the problem by using the insert symbol option.