Search results

I have created access application for timebooking. I stored that file on server and all user access that file from server. It is running fine on almost all the PC's but 2 PC's giving problem. Problem on one PC I found very strange. It is throwing error that 'Method or data member not found' on...

I have created one access application which will reside on server and many users will access it from there local PC. But whenever we start the application on local PC, it displays worning message that "Code is unsafe , it may harm your PC do you still want to run the code?" and another message...

I have created one MS-Access application. This application will reside on server. The application will be used by many users from there local PC. I want to allow them access to only forms of application and they should not able to inerfere in database tables, queries form designing etc. How can...

How can we delete all items from list box? I tried using ListCount property in FOR LOOP but it flashes error after deleting some items... Please anybody tel me the solution...

I have created multi user access application. I have kept it on server and all users access that application from there desktop pc. Can I set time out for application? Means, Session of each user must be note more than 10 minutes. I want to add this functionality for avoiding the application...

I have created the time booking application in access. (Application will alow autherised user to enter daily work done) My Idea was to put this file on the server and ask each employee to log in and enter information. But whenever I try to run application from other than my pc(On which file is...

I have some queries in access. I have putted the button control from controls toolbar in another excel sheet. I want to do following_ Whenever I click the button on excel sheet, the query in access dabase should get fired and result should be put in same or different excel sheet. Please help!

I am running a query which uppends the record to one table from another table. My requirement is that, it should check one field of the destination table table before inserting the record. If that field matches, it should run Update query or else it should run Insert Query. How Can I do that...

I have placed one combo box on main form. It contains the primary kyes or record. I also added subform on this form which is bind to the query. I want to populate this subform on the basis of value selected in combo box. How can I do it? I have tried_ Binding the subform to combo box by setting...

I want to bind label control or textbox control with query returning single value. How can I achieve it? My query returns single value.

I have master table named Emp_Master with fields Emp_ID and Emp_Name. I want to bind the combo box with name in such a way that it will display the names of employee but I should be able to use Emp_ID in background so that I can query different table using this value in where condition. I have...

Can I use left and right outer join at a time? Means I want all records from both the table, and it should put 'null' whenever value is absent.

How can we use the single button on the form to run multiple queries? I want to run multiple upend queries on single button click, where should I write quries and code?

I have linked One of My access Table with Excel. I am running the upend Access query to insert record from this table(Table that is linked with Excel table) into another access table. Whenever I run this query I get error "Numeric Value Overflow" nsg box. I checked the data types of all fields...

I want to do the following task_ Obtain calander control on form. Whenever I will select the particular date, that date should be get copied into the Textbox placed on the same form. (I don't know weather calander control is there or not in access) Please Help me, It's urgent.

I am new to the Access. I want the procedure to do following thing to make my concept understanding clear_ Adding Button and textbox on form, On button click, text in textbox should be stored in table named Master (Name (Text)) in database? Please provide me step by step procedure to do this...