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...

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.

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...

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...

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...

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...

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...

Dear all, My question is to know how to copy a unbound textbox named balance " =nz([Total Deposits])-nz([Total Withdrawals]) " which is located in my form control and paste into another master table once the field get updated? Any trick will do? Thanks in advance.... Regards, YEONG

would like to implement in the grafic a cumulative function in one collumn like for one field "value" : value + (value+1) + (value+2) + .....+ (value+n) where he sums the value and the folowing one until the end.... How can I do this? can you help me on this simple question Thanks in...

Hi, there. This has been bothering me a lot since 2 weeks ago. Does anyone has ever encountered this problem ; My HP E50 server has been running well with APC powerchute progam and it can power off and power on accordingly . But somehow someday it stoped powering off even though most of the...

Hi, there. I'd like to enquire is there a way to call upon a something like dropdown floating window showing table's particular fields when i execute the report. THe report i call will contain parameter like "Enter product". The floating window aims to serve the parameter prompt purpose. Ur...

Dear all, Just wonder is it workable that I insert another column into crosstab to calculate percentage formula instead of the sum ? My scenario is: Category total B-100ml B-500ml B-1l Cap28mm Cap33m bottle 100 50 50 0 cap 50 10 40 The above is created from the crosstab wizard that can give...

Hi, all my dear friends. Long time didn't email u for helps. Hope u won't mind answering me once again. This time around i got a request if this is feasible or not...It happens that I used Access query to change the 6 digit string field to date format by using formula, like this ShipDate...