473,385 Members | 1,958 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,385 software developers and data experts.

Problem in append table

suriacute85
Hi,

I'm very new in Ms Access, i have a form which contain a sub form table, i also have text box for data entry. when i enter the data, and click the add line button, the data will automatically save and view in sub form. the problem is, now, i want the data move to a new table and after that, the data in the subform disappear when i click button save.
how can the data move to another table and the data will not view in sub form when i click the save button? Please help me.. I'm desperate.
Aug 14 '07 #1
3 1170
Rabbit
12,516 Expert Mod 8TB
Hi,

I'm very new in Ms Access, i have a form which contain a sub form table, i also have text box for data entry. when i enter the data, and click the add line button, the data will automatically save and view in sub form. the problem is, now, i want the data move to a new table and after that, the data in the subform disappear when i click button save.
how can the data move to another table and the data will not view in sub form when i click the save button? Please help me.. I'm desperate.
Why have a subform at all then? Sounds like you can just use unbound controls and use a DoCmd.RunSQL "INSERT ..." on button click.
Aug 14 '07 #2
i have another problem, in my form, i have a sub form which i take the record from my table T_LogEntry, after i click save button, i want the record in the sub from move to my another table called, T_EntryData. and automatically, the record in the sub form will disappear. will U help me?
Aug 15 '07 #3
Rabbit
12,516 Expert Mod 8TB
i have another problem, in my form, i have a sub form which i take the record from my table T_LogEntry, after i click save button, i want the record in the sub from move to my another table called, T_EntryData. and automatically, the record in the sub form will disappear. will U help me?
I refer you to post #2 because this is the exact same question.
Aug 15 '07 #4

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

Similar topics

7
by: Vitamin | last post by:
I have written a stored procedure which will paging the recordset, and return a range of record that i need, and i write a asp code to call it however, no any return after the set objRs =...
1
by: kevininstructor | last post by:
I found code on the web which takes data from an MS-Access table (my test table has three rows by five fields) copies it to the Clipboard then into a range within MS-Excel. Data is stored in a...
9
by: tym | last post by:
HELP!!! I'm going round the twist with this... I have a VB6 application which is using DAO to access a database (Please - no lectures on ADO, I know what I'm doing with DAO!!) Ok, problem...
1
by: tangus via DotNetMonster.com | last post by:
Hello all, I'm really struggling with getting some Active Directory code to work in ASP.NET. Can you please provide assistance? I am executing the following code: Dim enTry As DirectoryEntry =...
3
by: gaffar | last post by:
Sir, I am developing an application in vb.net and the backend database is ms-access my problem is i want delete one record from master table, that deleted record automatically deleted from child...
12
by: Light | last post by:
Hi all, I posted this question in the sqlserver.newusers group but I am not getting any response there so I am going to try it on the fine folks here:). I inherited some legacy ASP codes in my...
1
by: Alberto A. Villa | last post by:
Dear SQL MS-Access Programmers, can You help me? I must append a table in MS-Access 2000 to another, because the new table has new data with same formats imported from an excel file, that...
7
by: wade.wall | last post by:
Hi all, I am having a problem appending data to an existing table. I have two tables with identical fields and I want to append the data from one table (T2) to the first (T1). T1 has 136...
5
by: =?Utf-8?B?R1ROMTcwNzc3?= | last post by:
Hi Guys, It's been a while, I've got a small problem that I could do with your expertise on. As you know (I Think) I build websites for recruitment agencies, part of the website includes a job...
3
by: Salad | last post by:
I am using A2003, SP3. If I use the QueryBuilder and select a table and drag the fields to it and then select Query/Append from the menu as the type of query, the first table name (alphabetically)...
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...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

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.