Recent content by rexie

Hi all, I have three tables, 1. Part Masster (Contains the part Numbers) 2. Payable header (contains the Invoice date) 3. Payable Line (contains Invoice price), every line joins to Purc_order_line table) 4. Purc_order_line table (gets the Part Number join to Part table) I would like to run...

Thanks XLBO, here is the full logic below:- If Column A (When I say Column A, it should check Only for that cell, not for the whole Column A, for eg:- A1:B1 is called a cell)is not null then column C,D should be mandatory, if Column C or Column D is Blank then Error Message should popup...

Thanks guys I figured it out and it works fine except for a slight modification. There are 5 columns in the Excel sheet, and if A1 not empty or NOT NULL then D1 and E1 cannot be empty and the BeforeSave event should look only inot records where Column A is Not blank check only for those...

Thanks a Lot, I know this is a stupid question, please could you tell me how to paste this code inot the editor, I tried pasting it inot the visual basic editor, nothing works, please suggest

Hi all, Can someone please help me to write this macro Which shoudl activate always upon save of the Excel File. The macro should check A1:A100 (Range A1 to A100) and b1:b100(Range from B2 to B100), if there is any field in the range empty , the maco should tell that the range (specific) is...

Hi all, I am really very new to Access. Please help/suggest me after reading Below. Idonot want to use a Query but I would like to right a VB Function I have a Form (Employee), would like to compute the Salary of the Employee based on three other tables. Problem1 -------- 1. How do the...

Hi Blom0344, the example was just for explaination(not the best obe), yes u are right, I am moving in values(None zero computed values). What I figure is there are many IIF conditions, any suggestions

I have a query which is pretty cumbersome. I have 10 fields, Below give is juts an example FLD1 = (A*B)+C FLD2 = IF FLD 1 > 100 then 0 is added to FLD2 FLD3 = IF FLD 2 > 100 then 0 is added to FLD3and so on FLD4 FLD5 FLD6 FLD7 FLD8 FLD9 FLD10 But the problem is after populating FLD5, it is...

Hi, Thanks a Lot for that peice of Info. When I write in the criteria in the query, and try to run from the forms, as soon as the control is clicked an input box is popped out to enter values. But what I need is the value is already enetered in the form and it has to take the forma value and...

Hi, I Have a form and would like to pass a value from one form to the Query. Eg below. Employee Master =============== Emp No : 1 When on a Button click on form FRM1, I want to select more fields from table 2(same (EMP NO)PKEY) and compute and return back to form1 . How do I do this. Please...

Thanks a lot guys, it worked, you guys pulled me out of this one fast. Thanks to all. I appreciate it

But I have 20,000 records to do ,though(sorry I missed that one)

Hi all, Please help. I have an excel file with two columns. The firt colume Contains Item number and , the second column contains Total. But the problem is that it is not side by side, meaning to say like below Item # Total ABCD (This is a seperated Row)...

Hi Dreamboat, Thanks , when the value of the key changes I want the Line number reset. Meaning to say as below With Customer Number 100 ------------------------- Customer ID Order No Invoice ID Line No 1002 100 123 1 1002 100 233 2...

Hi all, I am pretty new to Oracle and Win2K. I have set up an Active Directory schema for all Win2K. Now I want to extent my Active Directory Schema to accomodate Oracle. Can some one guide me or give me a document how I can do the inclusion of Oracle into the Win2K active directory. My...