Search results

Hello when i import data from excel into access 2003 i give nothing means not import data and no error seen like process finished but nothing happend what is the prob. how can i solve it

Thanks but i can't Understand solutions Can u give me detail as step by step and code...

Hello i want to create a append query in access 2003 to insert data into an existing table from Excel workbook My Table name is TokenDetail in Access 2003 and Excel File is TokenCreation i want to create query with msg box and requered file path for data becuase my excel files have various...

Thanks but i think i cant tell what is exactly prob i want to check which id has more than one values which are diffrent not same now i give an other example S.No EMPID Name Month Year AC 1 1 Anil Nov 2011 123 2 2 Ashish Nov...

the prob is EMPID ,which is Uniuqe ID but when i filter some ID i got diffrent Values like two employee get Same EMPID so i want to know how many ID having this contradiction and how can i got this

Dears i Have a database which contains EmpId EmpId is a Unique Id and Primary Key I have a problem that With this id a have some diffrent Values like Name,Account no I Want to search that Which ID have Diffrent Values and what are these Values How Can i got Pls help i can't Upload this...

hello I have a Database in Access 2003 Named "A",which Contains Table Tr in Excel 2007 , i Create Same data base in WorkBook "B", worksheet"W" with same format and fields i want to create a query to import data from workbook B to Table A in that process i can do two process First, Delete all...

it shows "wrong number of arguments"

how can i use this creteria in select query i have two forms 1-emp 2-income detail on both forms (text17) is same i want to set creteria is value of [forms]![emp]![text17] is null then set creteria is [forms]![income detail]![text17] if both are null then shows 0 i use this formula but it...

i have n text box on main form which contain sum of diff.fields.. i want to set maximum value as 1000 or sum of diffrent fileds how can i do it

i can use report but this time i m working on a form which show an employee data for editing so i want that solution

i have a subform Named(SUBSAL) when i set its view in continous form it lost title or field header lebal while it shows in datasheet view how can i solve this problem pls help

i have a subform name(SUBSAL) in this subform i get reocrds for some employee as select combobox Name(CMBEMP) some employee having 2 record or some having 6 record as their transaction my problem is that i have sum of transaction at subform footer field but when only 2 records shows in subform...

Dear Mihail first thanks for your suggestion i think my question is not clear i want minimum requirement of both criteria i want to use first textbox1 ,but if textbox1 is blank or not selected then value of textbox2 is use as criteria

sorry but it is my nature to call someone as sir if dont know personally as your question it works as "apr" but how can replace mar, apr as labelname and 1 more question how can i use "or" function in select query.. as textbox1 or textbox2 can i use it if they are on diffrent forms or...

i m a begeinner in access pls tell me how can set creteria in select query as Textbox1 or textbox 2 textbox 1 and textbox 2 are field on diffrent forms some time it may be on same form pls tell me

sir i solved this prob.as Me.Text43 = DLookup("Basicpay", "Salaryall", "[EMPID]='" & Me.Text17 & "' And [Salmonth]= 'Mar'") but now i have a problem same how can i replace 'Mar' with lebal48 value and how can i sum multi dlookup values

sir i have a form with combo box named "TEXT17" i have an another text box named(Basic Pay) pls tell me how can i use dloolup creteria with two condition EMPID= text17 value and month in lbl9 value="mar" i also paste my code here but show error Me.Text43 = DLookup("Basicpay", "Salaryall"...

Sir i am also doing as one textbox named (PAN) PAN value updated on a combo box i want to update value of another textbox named(DOB) on change or update value of text box (PAN) how can i do it source of textbox PAN and DOB in same table named(Allname) pls give m solution

Thanks Sir pls tell me how can adjust autoheight of a sub form based on record show as datasheet