Recent content by Alhousani

User is having read and write permission on that folder in addition if user login to another PC in the network he will be able to work in the database. Along with that in the same PC which has problem if another user login he will be able also to use and open the database, only for some...

I have a database created by access 2003, this database is in share folder but now for some user a popup message is appearing (Run-time error '2501': The OpenForm action was cancelled). This error is only appear for some user which they could not open some forms in the database. In the same PC...

Greeting, I have a database with feils contained date/time. Currently I used Now() function as a default value and I want the date to be stored as dd-mm-yy hh:mm which I use it in format but if I click on the feilds the date shows dd-mmm-yy hh:mm:ss. I want it to save as 20-11-08 10:12 even...

Whenever i used any type of format, (Now(), "dd-mmm-yy hh:nn") or format(Now(), "dd-mm-yy hh:nn") the result is 22-Feb-08 09:57 but I want it to be 22-02-08 09:57. If anyone can help me with example db it will be great.

Hi, In my database I have feild for date and the default value of it is taken from know function so the date in the feild is showing 22-feb-08 21:55 but I want it to be in dd-mm-yy hh:mm. I tried to used this format in the table but whenever I click on the feild the date shows in 22-feb-08 21:55...

Thank you for taking time to read my thread what I mean is I want to search in the table similar if you open the table and go to find and search in all fields but I want the desire value to be taken from text box or combo.

Hi everybody, How I can set a query to search in all table fields. In my table I have around 48 fields and I want to search for particular value from combo box if this value exists in any of those fields.

I download the database from this thread http://www.access-programmers.co.uk/forums/showthread.php?t=103278 and I copy the table, form, macro and module to my database but and error is appearing showing that missing shutdownform. Pls can any one help me.

This is good but I want to disable print not print blank becasue i want to save the consumption of printer ink so if they print only in report that will be good.In addition some form I want to print since the colur of it is white and I want to allow them to print it. Long time I saw this code...

Hi everybody, I create a database and I want to add code to disable print in some form and enable in report and some other form so is there any way to do it since I need it to stop staff printing from form and enforce them to print from report.

Hi everybody, Recently I created a database for staff details in my company and I used OLE Object in Data type to make it. The problem now there are more than 500 employees in the company so it is very difficult to scan one by one photo. Is there any way that once I click on command button photo...

Hi everybody, I have an access database which is around 40 MB after compacting it and I feel that it is slow especially when I open cross table form. Is there any way to speedup the databse. Note: my databse is on the share drive in my work.

Is there any way of adding export fuction to the toolbar using modules or macro or how I can build my own toolbar when will appear in all workstation in the company

Thanks for the reply If I can do that is there any way to force user to close the database by any command

Hi, Recently I created a database using MS Access for the company and I am the Admin for it. The database is in the share folder and many employees are using it but if I want to take backup or modify any thing a message is appearing saying that one user open the database. Is there any method...