User Profile

inte · Jul 6 '18, 04:29 AM

I appreciate all of the help you guys have offered me. I am proud to inform you that, after a bit of tweaking here and there, I have had take worry taken away, thanks you guys.

inte · Jul 4 '18, 02:34 PM

Guys, I would very much love to have fresh ideas from any one. I have tried the about suggestion but it isn't good enough for my purpose, since the portion of my project in discussion here belongs a very big project, I am finding it difficult integrating it with the other parts of the project

if anyone could at least show me how to get my model to work I would be very grateful.
Thank you all in advance

inte · Jul 4 '18, 01:42 PM

I agree. Ok let me try to relate the two table with an OrderID. I will let you guys know of the outcome.

Thanks a lot to you all

inte · Jul 4 '18, 01:14 PM

I honestly would love to give your suggestion a try. But I do not understand you well enough. Also I am very limited with regards to vba

inte · Jul 4 '18, 01:04 PM

Yes tblSalesMAIN1 is suppose to be a record of all sales

inte · Jul 4 '18, 12:12 PM

Are you saying that you have a Sales entry form? Yes

a resume of the past sales entries? No

When you press a Command Button on your main form after entering a new sale, you want that entry to show up on the continuous form, and have a blank Sales Entry form, ready for the next entry? Yes but i have done that already.

what i want to have all of the individual sales have added and are already showing in the table...

inte · Jul 4 '18, 11:51 AM

How to append data from one table to another table upon the deletion of the firt data

Thanks a lot Phill. I have commented some adjustment I have made to the code, but I am still not getting it right. I hope code I have added and the zipped copy of the portion of my project will give you guys some clarification to be able to assist me.

Private Sub cmdClear_Click( )
'Dim dbs As DAO.Database
'set dbs...

User Profile

Profile Sidebar

You tried to execute a query that does not include the specified expression 'salesID'

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

How to append data from one table to a another table upon the deletion of the first t