Recent content by jensonchandy

The link is very helpful and it clear my problem. Now there is a new issue The reports are not printing properly. It is showing an error message "The OpenReport action was cancelled"

Our company is using an A2000 Database. Now all our PC's are having A2003 except mine. The database is working fine. But for others, they are not able to get the data properly in the combo box. Eg:If there is a list of employees which contains name,No,Desig,..the numbers are available in the...

hi i am having a login form. where i have only two users..may be 3 suppose it is admin and guest then i have a main form where i have 5 tabs,...where each tab contains 7 or more command buttons which will open some forms what i need is when the admin is login he should be able to edit add...

hi friends i had gone thru the record locking first i'll tell u what i need i'm having a form for timesheet entry there r two persons going thru the form first one person enter the data and the second one cross check it what i need is whatever the second person had checked that should be...

thankz for the reply ur report is the same as i need but the probs is that there should be 2 parameter values starting and ending date when we enter the dates only the days between that should be displayd regards jenson

hai i had done the crosstab query.... it's working thankz for that now i need another help on that i need the date as my labels in headings eg: empno total_hrs 1jan 2jan 3jan........31jan 1feb.... 1001 8 2 2 4 it's going like this but what i need is there...

I need a report to be created as the same in the excel sheet how to do this

Runtime error 3265 Item not found in this collection This error i'm getting when i'm running a report in ms access And the code is like below Public Function WhatSQL() Dim ftext As String Dim myqry As QueryDef Set myqry = CurrentDb.QueryDefs(MQRY) WhatSQL = myqry.SQL End Function regards...

hi friends when i run an access form ...in the status bar it's showing this recordset is not updateable.... when i enter the data directly to the database then also i'm not able to enter it first i was able to enter the data... later i add one more field to the database..then all these happens...

hi friend i'm new user could u tell me how to put the images on forms... using the database path how to give tha path what changes should i made in the database regards jenson

when i'm entering the picture thru insert option only the file name is displaying on the object..the picture is not coming

hi friend... i need my database like an exe file i have two .mdb files with me one my database and other contains forms and reports when i open the .mdb file(reports&forms) the autoexec will come. now what i want is when i close the mainform the entire .mdb should be closed. how to do that jenson

hi friends help needed in entering image into an access form. plz tell me how to do it and to save it to the database one more thing i need is i want to make my .mdb file to .mde how to do that. i'm using access2000 whenever i'm making the file to .mdb , it's showing an error that access...

ok i agreed with u and i had removed it from the table and the id is getting stored in the table. now what i need is using this i'm creating a report...in the report it's sorting according to the employee .in the details section i need the employee details and the jobtitle details form the...

help needed now i made some changes in the table and forms in the table i add job title also in the form when jobtitle id combo should contain the id and should be stored in the jobtitleid. when i select the id the corresponding jobtitle should be displayed in the textbox and should be saved...