Recent content by fleury

thanks for your links!! I will study about it and get back to you.

sorry but can I know which query that I gotta append and where to append? To tblmain? I face some problem in appending the query. Thanks for ur time.

the user will just enter data on the form, then the data will be stored in the main table. Hope i not making you confused. Thanks lots!!

I have done some studies on the inventory database that was linked to the website u gave. I can get the result I want so far.However, when I tried to enter data through my form, I found that the form is messy for user. It contains Item In and Item Out details in the same form. It looked unorganized.

I added save record button into my form but the tblmain cant seem to be updated also(when i save record with transaction no.6) Thanks for your time！

I have attached my database here. When i insert a new record (record with transaction no.6) by using the form for Item In, why cant I see the updated information in InQuery1 and tblmain?? Thanks for your time.

Hi all!!! I m learning access 2007 by myself and doing a project which sounds like inventory system. I have encountered a problem here. My table will included all details which the stock will come in and go out from the storage. And now i wanna create a user interface from the table i mentioned...

but can i make all partNo named apple to be having partID=1? That means the third record has partID=1 too. It is due to I want to calculate the current apple on hand after that by sum quantity. Thanks very much!

attached is my file. Please have a look and you can correct me if anything i have done wrong. Thanks lots!!

Hi all!! I encounter a problem here. My component table will link to the transaction table as one component maybe have more than one transactions. When I key in the component name, I want to display the output like simplified version below: ID ComponentName DateTransaction 1 resistor...

1st I need create a textbox named texbox right? Then i insert the code given to AfterUpdate event of texbox? Thanks very much!!

Hello all!!! I need to hide navigation button in my form cuz i added search button with better functions on the form page. However, i wish to show the page number of every single pages in the form. How can i do that? Thx for help!!:):)

can i do tat without much coding?

HI all i'm new to access 2007 and learning all by myself. I would like to creating two tables, one with item in and the other wif item out. There are many different item numbers for the items in my tables. and I would like to know the current items on hand. I need some guidance to continue with...

sorry that i have bother you so much thechazm. I tried insert the latest code and it works on the first record that i wish to delete(for example, record A). However, if i continue to delete another record(record B), error will occur. I have attached the picture of the error here to let u...