Hello
I want append n record to a table
All records are the same
W y plz help me.
Sent from my SM-J701F using Tapatalk
Hello
I want append n record to a table
All records are the same
W y plz help me.
Sent from my SM-J701F using Tapatalk
You can use an Append Query to append a record to a table.
If you need more, please provide more details into exactly what you are trying to do (i.e. where is this data that you want to append, what does it look like, etc).
Ok. I know but i need append for example 10 records to table that 10 record are the same .
Id(primery key),PartNo,ChargNo,Qty,
Sent from my SM-J701F using Tapatalk
Your posts are very short and cryptic, lacking in detail. Please give detailed exaplanations so we have a clear understanding what you are after. Otherwise, we are just "guessing" at what you mean.Ok. I know but i need append for example 10 records to table that 10 record are the same .
Giving examples often help clarify thing.
I am not clear if you are trying to add new records, or update existing records.
"Append" means to add new records.
"Update" means to update existing records.
If you are looking to "update" existing records, then you would simply do a matching query between the two data sources, and then use an Update Query to update the records.
You can Google "create an update query in access", if you do not know how to do that.
Something like:
For x = 1 to 10
CurrentDb.Execute "INSERT INTO tablename (Id, PartNo, ChargNo, Qty) VALUES(" & Me.ID & ",'" & Me.PartNo & "','" & Me.ChargNo & "'," & Me.Qty & ")"
Next
So if you need more help, provide more info.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you. very useful and i will use this code
Sent from my SM-J701F using Tapatalk
Yes . You are right . But i cant read and write english very well so i type short sentences i can write persian.Your posts are very short and cryptic, lacking in detail. Please give detailed exaplanations so we have a clear understanding what you are after. Otherwise, we are just "guessing" at what you mean.
Giving examples often help clarify thing.
I am not clear if you are trying to add new records, or update existing records.
"Append" means to add new records.
"Update" means to update existing records.
If you are looking to "update" existing records, then you would simply do a matching query between the two data sources, and then use an Update Query to update the records.
You can Google "create an update query in access", if you do not know how to do that.
Sent from my SM-J701F using Tapatalk
But we still need to be able to understand what the question is, otherwise we won't be able to help you all that well.But i cant read and write english very well so i type short sentences i can write persian.
Maybe "Google translate" will help there, where you can write the question in Persian and let Google translate it for you.
Okay.Thanks for your comment.
I try using google translater next time.
Sent from my SM-J701F using Tapatalk
I've seen much worse English in postings. I think your grammar and vocabulary quite good, even using contractions which can be difficult for non-English speakers to get hang of. Of course, omitting the apostrophe but even native English speakers are falling into that trap these days.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you so much for your hope. I'm a beginner at Access and may be bothering you, but you are bored and kindly answering my questions.I've seen much worse English in postings. I think your grammar and vocabulary quite good, even using contractions which can be difficult for non-English speakers to get hang of. Of course, omitting the apostrophe but even native English speakers are falling into that trap these days.
Sent from my SM-J701F using Tapatalk