Search results

yes thanks for tips, but like in my previous message, there is another 18 tables i hav not included here which is solely related to the category table, size tables and material tables, which is why u do get that error in the relationship, otherwise in my actual orginal file all of the...

will try that too, thanks for the tip

thank you i will go thru and see if it suits the requirements!!!!

YESS all of those has been done and repeat data is been entered using other tables and theres no need to worry as the only way data is entered to this table is via a form which has all the necessary features to prevent duplications and enter repeated data using dropdowns, i jst didnt want to add...

heres the sample

yes two different fields, ill share the sample file i made shortly. and yes i am having a hard time with my own ID which is created to identify each record created when a new stock is added to inventory

the s erial number would be a number generated by the system which is in sequncial order 1 to 100 and so on

yes my plan was t use a continous form, but it shows me all the old records aswell, i want jus the records only, the ref doc is a printed paper from the factory

hi guys, So the item code is a hardcodes id from the factory itself, the serial unique id case comes up only when stock is added to the shelve, in the sense that when a new stock arrives that record is entered to the system, THAT RECORD IS HAVING A UNIQUE CODE, which is the one that must be...

I do hav another issue though, so I'm created a stock tbl in away u add stock details like product and quantity and date to a table thru a form which was a single form only. But now the guys want me to fix it so that it can be bulk import stock problem, So I'm using a continuous forms and now it...

hi guys, really sry for the late responce, i just got my pc fixed. so i did find a solution to my problem, which was i inserted another sub from with just only stock related stuff and then had a separate sub form for order dtls that way access allows me to edit order dtl table and keep stock...

hi guys maybe if there is any way i could count the number of items. In the order using a text field with control source "=count(*)" i ge the full amount of items, but to get the other one is the problem im having, tht is the count of how many items are in stock form the other. i cant count it...

i have a order form with a sub form orderdtl, we got the option to change the status of the order from processing to shipping, only if the desired items in the order are all in stock or in other words if the quantity is less than or equal to the available stock, but for this to happen i hav to...

yes tht has been done, where u get to delete the order only if order is completed or returned, but before those steps there is pending, processing and shipping, so i will speak with the staff and see their opinions too!

will look into tht too! thanx again!

yes ill get back soon as i think of a way to use the flag option and get back on wht i cooked up! Thanx guys!

so i have a main form called orders, and subform called order dtls, they are linked so that if order is deleted the sub dtls also delete, but i want to do this in the form of buttons. save- lets u save ur progress only if all the details are entered till then can't save record, delete- deletes...

i was able to bypass the error with a timer event, it works as desired!

So I tried do what you said, but i encountered a new problem,the if statment uses the condition "StockOnHand<Quantity", here the Quantity is a stored value, but the "StockOnHand" is a dlookup value which is also not saved, what do ido then? For this form i use a query(orderdtl) as a record...

i wanna use tht value in another calculation