Search results

You don't have [Y-1_Approved] field in the qMT_Project_E. ;)

Ok, then. Thank you very much for your suggestions. I hope you don't mind if i return back with question about normalization my db after i learn the normalization subject. Thank you for the link , I'll take a look of it. Hope you don't mind if i've question about this subject later.

it's ok. I'm sure you're right. i'm just starting to learn. can you tell me which part i need to fix it? of course i need to know what is your mean by the word "messy" :D . I learn Access just by doing, from this forum and of course. from google.

Yes, I think that i've created something like you said, and that's mean when there is a transaction like sewing order for two product, A and B, and for each product, there's the order for size: S = 2, M=2,...Cus=2 . This mean that i have to type 12 record (row) on the sewing order form for only...

Hello all, I'm trying to database clothing process. From material purchasing to clothing sales. But now i'm in doubt how to create table structure for the Product. Each product will have six different size : S, M, L, XL, XLL, and CuS. if you have Product A, it will have these six size, say AS...

It's really good John, perhaps i will use it for me.. :)

I think you're right. Dlookup function return single value, not a recordset. You could do it by creating a dialog form with a listbox control on it. Set simple SELECT query for listbox row source on the form load event. The query could be: Private Sub Form_Load()...

I'm sure that you've found the answer on the site Mr. B..

have you requery the dropdown location from customer dropdown afterupdate?

Thank you for the reply. i found this code: http://blogs.msdn.com/b/access/archive/2009/05/21/how-to-create-a-shortcut-menu-for-a-form-form-control-or-report.aspx And I try to use it for my database. I post the database in attachment. It can work on mouseup,mousedown, and click event but...

Hello, I have shortcut menu that show on right click event...Is there anyway to change, so that the menu appear on mouse move? I'm using Access 2007..and how to set up it on the subform control like textbox? Thanks

I assume that Urn field is string datatype, Private Sub Command2_Click() Dim Urn_String As String Dim vSuffix As String Urn_String = Nz(DLookup("Urn", "[tbl_y]", "[Urn]='" & Me.txtUrn.Value & "'"), vbNullString) If Not Urn_String = vbNullString Then If...

yes, that's the case..

Yes, it will be used frequently. I' ve create code so that it will be uniqe. Later, it will be printed and stamped on the product. And maybe someday it will be use for creating bar code. That's the plan.. In my case, like John said, form is linked to the subform. and setting required field...

The situation is after some field in main form is filled, focus must move to subform.Because product number need values from sub form before it generate through procedur and function. And if it happen, that's mean property me.newrecord will be False..and also will run beforeupdate event... and...

I'm sory, i don't mean that i store record in query. I mean through function and query, product number can be generated. So actually, i've an option, store product number in a table or just retrieve it from function and query. But that's not the problem now. Btw, if i set required property=true...

Hello, I've some question about form validation.., hope you can help me. I have form which contain a subform. Main form bound to tbl_Product and subform bound to tbl_Componen_Product. I need to create product number (part number) base on some textbox value from main form and subform..To do...

As Access said, have you tried to divide this query into two separate query ?

It's work here when i use that function in northwind database. the only error that i found is when id produk has null value. But sometimes the error like that happen when you have large enough data to process...it also depend on the query and index in the table that related in your inventory...

try this in ur textbox controlsource: =dlookup("[Your level inventori field]","[YourqryInvLevel]","[Your ID Produk in query]=" & yourcontrolidprodukinsubform)