Copy Current Form data into New open Form

[UberMonk]

Hello
I am trying to create a Library Database. and i want to copy Current Form data ( which retrieved through query from main database) to New table(actually, Table for records of issued books) and also display in new open form. (Form for Issued Books)
Thank you.

 

[HiTechCoach]

Welcome to AWF!

A simple method would be to add a status field to the books table. You could then create two forms using the books table. For the issues books form, you would filter the books table in the query to only show issue books. By simpling changing the value in a field, the data move move between forms by using a filter, not by actually moving the data.

I normally would create a transaction record to show the movement of the book.

 

[UberMonk]

Hello
Thanks to ur response , HiTechCoach.I dot want only search/or find Issued books or to show in to separate Form, but my problem is exactly that.
i created a Query to retrieved records from Book Ttable and show in to Book From, here (In this form) i put a command button to show a new Form (Issuing Form) which has issuer name, his/her id, address, book title, and some extra information, so what i want is that, through command button ( which is on Book form) not only display issuing form but automatically copy book title, Author Name,serial no., from Book Form to Issuing form.

ie

Copy "Book title" Data (From Book Form) TO Book Title (Issuing Form)
Copy "Author Name" Data (From Book Form) To Author (Issuing Form)
etc. etc.

So i do only type issuer name and his/her id manually in Issuing Form.
thanks

 

[FREDDY67]

UberMonk

I am not an expert but this is how i would do it, behind your command button do something like this;

DoCmd.OpenForm "Issuing Form" - Opens Issuing Form.
Forms!Issuing Form!Book Title = Me.Book Title - Places Book Form - Book Title data in Issuing Form.
DoCmd.Close acForm, "Book Form" - Closes Book Form.

You just have to repeat the middle section to duplicate any data from Book Form to Issuing Form.

Hope it helps you.

Freddy

 

[UberMonk]

Hello
FREDDY67 Thanks for help, But When i put these code behind my command button and click on button an error message was displayed

"The expression On Click you entered as the event property setting produced the following error: A
problem occurred while Library was communicating with the OLE server or ActiveX Control."
So now what should i do for correct this problem.

 

[FREDDY67]

UberMonk

The error is nothing to do with the code, you could have a look at http://bytes.com/topic/access/answers/451336-problem-occured-while-microsoft-access-communicating-ole-server-activex-control.

I have attached a small db with working code.

Freddy

 

[UberMonk]

Hello
FREDDY67 thank u very much for ur help.ur given database is run absolutely fine. So i am looking into my database and try to solve it.

 

[HiTechCoach]

Hello
FREDDY67 thank u very much for ur help.ur given database is run absolutely fine. So i am looking into my database and try to solve it.

****>>>> WARNING <<<<****
While FREDDY67's example may work, it really is violating the rules of data normalization. It is a not based on a sound relational database design. It is based more on how you might do it in a spreadsheet, but not in a properly normalized database.


I would urge you to learn to learn how to do it based on the rules of data normalization. You will be glad you do!

 

[boblarson]

I would urge you to learn to learn how to do it based on the rules of data normalization. You will be glad you do!

I SECOND that assessment.

 

[FREDDY67]

Hello

I am also learning, could someone please take a look at the attached db & see if it follows the rules of data normalization & if it does not could you comment as to where I am going wrong.

UberMonk my apologies for misleading you.

Thanks

Freddy

 

[HiTechCoach]

I will be glad to take a look as soon as I get back to my computer.

I am taking a break from dancing so I am not at my computer. I sure love my Palm Pre!