Search results

Hi all, i still have another problem which is related to Access Query parameter ' Between [Pdate1] And [Pdate2] ' When i converted it to DataAccessPage, it succeeded and came up with parameter box asking Pdate1 and Pdate2. But, when i create a textbox on the DataAccessPage to remark the date...

Dear all, I was having a problem whereby I don't know how to write a VBA code to facilitate my sales detail records. For your info. my company is dealing with bottle selling. Usually we got one sale order and that could produce many time of shipment. My problem is like this : Relationship 1...

Hi, all. I was wondering how to finetune below code to allow to my inbound combox box named 'code' to show query 's return value on my main form's textbox ? I did it by using Code_afterUpdate event . I got 1 main form called frm_itemRequestHead which is link up to subform called...

Hi, all. I was wondering how to finetune below code to allow to my inbound combox box named 'code' to show query 's return value on my main form's textbox ? I did it by using Code_afterUpdate event . I got 1 main form called frm_itemRequestHead which is link up to subform called...

Hi, all. I need to know if i can add a control inside a form which is having 1 to many relationship with a subform. The control should prevent the subform from adding new record once the subform have been filled in. Eg, Tbl_request / Main form Doc Date 1 - 12/5/4 Tbl_RequestDetail / Subform...

Hi, all. I need to know if i can add a control inside a form which is having 1 to many relationship with a subform. The control should prevent the subform from adding new record once the parent and subform have been filled in. Eg, Frm_Request Doc Date 1 - 12/5/4 Frm_RequestDetail ID Doc Code...

More understanding on the terms Thanks for those replied above. In my scenario, can i make the reorder qty and safety level different meaning based on below : ItemA Stock balance : 10 Safety Level : 5 ItemA ordered : 20 reorder qty = absolute (10 - 20) + 5 = 15 onhand qty = stock balance...

How would u understand these words? Can somebody explain to me what actually are meant by Reorder QTY , Safety Level and backorder ? I need to make clear of these words before i use them in my stock control access. Thanks.

Thanks giving Thanks Hartman. U have inspired me how to do solve problem.

Hi, all. I used below after_update code to dlookup particular data on my parent form. It did what i want. Me!Material = DLookup("imdsc1", "tbl_itemmaster", "IMLitm = forms![frm_itemRequestDetail]![ILcode]") Eg, i choose dept code and it auto show dept name in my unbound field on the parent...

Thank you. 1st of all, I need that date to be in Julian format then i'll add year number to make it unique for numbering. That was requested by my customer instead of using autonumber. Thanks

Hi, all. I have inserted a new module as following : Option Explicit ' RETURNS: A three digit Julian day as a string. Function Date2Julian(MyDate As Date) As String Date2Julian = Format(MyDate - DateSerial(Year(MyDate) - 1, 12, 31), "000") End Function This module is to turn my date into 3...

Copy inbound control A into inbound control B Thanks for ur post. Sorry it 's not what i want. i don't want to change the figure itself from the exact figure to negative. I want duplicate it into next field as negative value. in fact i need that field in to do some calculation by having...

Dear all, I was wondering is there a way to copy ActualQTY into another StoreQTY field as negative value for whatever figure has been keyed in on my form? For instance, itemA RequestedQTY ActualQTY StoreQTY ABC........... 10............ 8 ............ -8 ..... Meaning to say when i have...

New Control - Locking record after entered Thanks anyway. My code has finally worked out. Private Sub Form_Current() DoCmd.RunCommand acCmdSaveRecord If QTY <> 0# Then QTY.Locked = True Else QTY.Locked = False End If End Sub

Hi, Does anybody know how to set a control whereby it can restrict users from editing the previous record line once entered, the particular column will be locked; no editing is allowed. But the next new record will be unlocked again for entry. I tried to do myself but i have found an error...

Thanks for your concern Thanks anyway. What i did can lead to denormalization. Trust me i would use it wisely. Thanks again

Dear all, It's about the copy calculated field from a form into another table. I know it 's not recommended becoz of denormalization. In fact, i need to learn it anyhow. Someone taught me to use update query : Balance_afterupdate() If not isnull(balance) then docmd.runSQL "put my sql here"...

Hi, there. Finally, i have worked out my 1st db, stock control. This db contains item master, location, costing table and pricing table, stock card, monthly stock summary reports. going to be more.... Now, i need your ideas what are the other essential reports required for users in general...

Hi, there. Finally, i have worked out my 1st db, stock control. This db contains item master, location, costing table and pricing table, stock card, monthly stock summary reports. going to be more.... Now, i need your ideas what are the other essential reports required for users in general...