Search results

hello guys i have values in two unbound textboxes and now i would like to assign the sum to a bound textbox. Also need AfterUpdate event too. Can any expert help? Thank you

Hello guys I have one small quick question. How can get blank or new record after saving Cheers

Hello guys First of all am sorry Mr. Ruralguy for that. Now my question is i have Combo Box and i want to SetFocus OnEnter event to move to next field. Please help me how to do this Thank you

Hello guys I had developed report which, pop up form and i have StartDate and EndDate in form the MiniCalendar is use to input date in these. Now i want to validate both dates StartDate should noot be Null EndDate should not be Null and less than StartDate I searched for similar information...

Hi guys i had developed report which, pops up form to pass on info to generate report. in that pop up box i have StartDate and EndDate. The start date should not be Null The end date should not be Null and greater than start date. otherwise through message. Can anyone help me Thank you

hey guys I want to creat something like 1. list of all countries, with one Bogus "All" representing all countries 2. When i select a Country from drop down list, i should get list of States in that Country. Again with one Bogus "All" representing all States in that Country 3. When i select a...

Hello guys i want to prepare User level security for accessing database/tables/fors and reports. So can anyone have step wise procedure? I am using wizard, but am not able to set up. Thank very much:)

Hello experts good morning. here comes my doubt. i use =CurrentUser() in text box of form. but when am testing, the user name is not there in database. i am using Access 2003 and Access security. Can anyone tell how to resolve this Thanks you:)

I had prepared three queries SELECT DepartmentID, DepartmentName FROM Departments UNION Select Null as AllChoice , "All Departments" as Bogus From Departments ORDER BY DepartmentID; --- From Departments table SELECT DepartmentID, EmployeeName FROM Employees UNION Select Null as AllChoice ...

Hello guys How can i get the Log-in User name into text box in a form Thank you

Hello Guys I am looking for procedure to pop up records in a combo box in form like All ---- James Peter Mathew Can anyone help me? Thanks:)

hello guys i want to implement pop up calendar available on this discussion forum. i match all the propoerties of 'MyDate' in my form with 'MyDate' in "Frm Trial" form of Popup Calender.mdb. copied 'zsFromCalender' in Popup Calender.mdb. now the problem is when ever i run the code, i am...

Hello guys Here i am again with another problem. I have date field in my table (MyDate) and used that in form. I downloaded PopupCalendar file, which, i saw here in this discussion forum. i had implemented all properties of 'Text3' of "Frm Trial" form in popupCalendar.mdb. Now when i run...

How can i deactivate mouse second button click on form? Can anyone help me please?:)

How can i deactivate mouse second button click on form? Can anyone help me pleae? :)

Hello guys How can get blank fields on opening or loading my form?. I don't want to prevent data entry option. Please help me Thanks:)

SELECT (Max(ReferenceDescription.ReferenceID)) FROM (ReferenceDescription) WHERE (ReferenceDescription.ReferenceID >= (ReferenceDescription.CategoryID * ReferenceDescription.DepartmentID) AND ReferenceDescription.ReferenceID <= (INT(ReferenceDescription.CategoryID *...

SELECT (Max(ReferenceDescription.ReferenceID)) FROM (ReferenceDescription) WHERE (ReferenceDescription.ReferenceID >= (ReferenceDescription.CategoryID * ReferenceDescription.DepartmentID) AND ReferenceDescription.ReferenceID <= (INT(ReferenceDescription.CategoryID *...

hello everyone i created 4 tables Departments (DepartmentName as prime key), Employees (EmployeeCode as prime key, as prime key field can't have duplicates as it occuring in case of EmployeeName), ErrorReference (ErrorCode as prime key) and ErrorCategory I built onemore table...

Hello folks am working on report generation on performance of my department. I need help to develop in Access. If anyone can help me in developing it? i had started with tables. If u have some spare time, please mail me at nrmarthi@hotmail.ca. Thank you Marthi