How to create a Query to Update values in a Table

[Mallol02]

Hi everyone,

I don't know how to actually create a Query or a Code to Update Information on a Table that have a field that in the index is a YES/NO DUPLICATE. The only thing that does not change is the auto number. but all the information may change.

I have created a macro to transfer that information to excel and then another person will extract that information from excel to access. when we did the transfer and the extraction the first time, it works, but when you change information in the table and try to pass it again. it doest not make any changes...
there are any way to create a query or a VBA for this excersice.??

Thanks in advance...

and i did my home work trying to find something like this in the forum...

 

[Mallol02]

are there any possibility to solve this one?

 

[John Big Booty]

Have a look at an Update query. To create one on these, simply create a normal select query. Once you have this working correctly, Click on the Query menu and select Update Query, when you do this you will notice a new row appears in the query builder grid, labelled Update To: in this row you can specify what that field is to be updated to, it could be a fixed value or an expression.

 

[Mallol02]

Thanks for the Reply... I tried to Update from one table to another but not success.! i don't know what to do.... both tables have a yes no duplicate on one field but the rest can be updated or modify.

 

[jjturner]

I don't know how to actually create a Query or a Code to Update Information on a Table that have a field that in the index is a YES/NO DUPLICATE. The only thing that does not change is the auto number. but all the information may change.

So in your table you have an autonumber field (which will change, by definition) and a field setup with an index to allow no duplicates OR, to allow duplicates - which is the case?

My apologies, but I can't quite understand your ultimate purpose. Generally speaking, if your table is setup correctly, you shouldn't need to be routinely updating it.

Kindly elaborate a bit, if you would.

Thanks,
John

 

[Mallol02]

ok. i have a database that share information about client information with another database. when i said that have a yes/no duplicate is because both database have the same identifier for the client. ok! let say that i export all information about the clients and the other database have to make and append to his database. Thats the easy part!... if i change any information about that client, let say the address when i export the new info the other database dont see the changes. here is that i dont know what to do to make this happen.

 

[Mallol02]

So in your table you have an autonumber field (which will change, by definition) and a field setup with an index to allow no duplicates OR, to allow duplicates - which is the case?

My apologies, but I can't quite understand your ultimate purpose. Generally speaking, if your table is setup correctly, you shouldn't need to be routinely updating it.

Kindly elaborate a bit, if you would.

Thanks,
John

ok. i have a database that share information about client information with another database. when i said that have a yes/no duplicate is because both database have the same identifier for the client. ok! let say that i export all information about the clients and the other database have to make and append to his database. Thats the easy part!... if i change any information about that client, let say the address when i export the new info the other database dont see the changes. here is that i dont know what to do to make this happen.

 

[jjturner]

I still don't know what you mean by "YES/NO DUPLICATE" - presumably you're referring to a lookup table?

It sounds like you're attempting to synchronize a remote database to your local database. Are you able to link the tables from your database to the remote database?

If not, then you're faced with a number of issues. Can you please post your table structure - like this:

TableName1
- Field1 (data type)
- Field2 (data type)
etc.

TableName2
- Field1 (data type)
etc.