473,324 Members | 1,856 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

How to transfer automatically the record to other table?

180 100+
How to transfer automatically the record to other table?
i have table name tblDTS and tblARC
my form name is List the default view is Split Form
and another form name is Entry the default view is Single Form
i have two fields: subject and status
in my entry form i have one textbox for subject and one combobox for status, you have two option to select in this combobox (done and pending)
my datasource is tblDTS. when add record and i select done, i want this record to transfer automatically to the table tblARC.
any help will be highly appreciated..
Sep 30 '10 #1

✓ answered by RuralGuy

I'm not sure why you want two tables with the same data. maybe just implimenting an Archive system would work for you. http://allenbrowne.com/ser-37.html

8 2342
RuralGuy
375 Expert 256MB
I'm not sure why you want two tables with the same data. maybe just implimenting an Archive system would work for you. http://allenbrowne.com/ser-37.html
Oct 1 '10 #2
eneyardi
180 100+
thnx.. alot
Oct 4 '10 #3
RuralGuy
375 Expert 256MB
Glad we could help.
Oct 4 '10 #4
eneyardi
180 100+
do you have a sample detailed intructions on how to do this?
Oct 12 '10 #5
RuralGuy
375 Expert 256MB
That was provided in the link in Post #2.
Oct 12 '10 #6
eneyardi
180 100+
the instructions in the link you provided is not working. do you have a sample program where this is the form, and this is the code automatically update database (the record containing done field will be move to other table) when you type the done in status field. i hope you got my point..
Oct 15 '10 #7
RuralGuy
375 Expert 256MB
Maybe posting your db so we can look at it would be a better approach. I do not have a sample db handy that impliments Allen's code.
Oct 15 '10 #8
eneyardi
180 100+
OnError Next,
RunCommand SelectRecord
[MacroError]=0 RunCommand Cut
[MacroError]=0 Close Close
[MacroError]=0 OpenForm 248 Quarantine Record, Form, , , , Normal
[MacroError]=0 RunCommand PasteAppend
[MacroError]<>0 MsgBox =[MacroError].[Description], Yes, None,

this are the macro code i did, but it not exactly what i want to make, because of this code, i need to click command button. i want a code that automatifcally transfer record when the record contain (done) for the field status
Oct 18 '10 #9

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Sami | last post by:
Please bear with me, and if you answer this question, please do it step by step. I am new at Access, not at all sophisticated. I am using Office XP. This will need to be read in Access for...
1
by: Michael J. Savage | last post by:
Can someone help me? I use Access 97 and I have no idea how to do the following: I have one table called tblWorkDescriptions. Each work description has fields Priority, WorkDescription,...
0
by: Mark | last post by:
All, Excuse the re-post but I have found something which works for the UserID but not for the Password (see previous post below). The problem is I don't understand how it works and therefore...
0
by: Cyberwolf | last post by:
OK, how to explain this. I have a table that will feed into another table using an append query. What I want to do is look at the table I am appending the record to to check for a duplicate...
1
by: gaurkamal | last post by:
I want to delete record in table B when i delete record in Table A both table have a common column. I want to do it using trigger .Can any body give some idea. Table details are. Table A: ...
1
by: soahil | last post by:
Hello to everybody! I want that during inserting values in the master/detail form whenever I select a Company ID and enter BILL Amount against that company and SAVE that record then It should SAVE...
1
by: khalid sohail | last post by:
hi everybody, can anyone one help me how i can display colunm from other table in the datagrid actually i want to display the department name on the basis of department id in the employee...
1
by: rhepsi | last post by:
HII all, im working on postgresql database where i want to copy the data from one table to other table.... when im trying to write the sql query.. ERROR: 42601: syntax error at or near...
5
by: saga git | last post by:
how to display nth record from table
1
by: Mysterydave | last post by:
Hi, I have a database where I have to produce lots of reports on a weekly basis. There are only 2 report types at the moment (probably 5 types in the future). I have created a table called...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.