Search results

Hi, I would like to know how to display or change the value in crosstab query to text instead of numbers. I understand that the value must be numeric. Is there another method? I would like to create in the folliwng format. e.g. Robert Jame Lee Form1 Read Full Denied...

Hi, Thanks for the reply. I would like to know which part of the database I should put the code that prevent the SHIFT key from bypassing the startup options? In addition I would like to have administrator to access it. This code I got it from the Microsft website. Function...

Hi, My access database is currently stored in a shared folder in a network environment. I would like to implement multiple users logins and password using the user security wizard. My plan is, I will be setting up on 1 PCs and then I would like to copy the secure mdw to the rest of the other...

Thanks for the reply. Will give it a try. It seem like this is the only way to do it.

Hi, I am using a text box to add to memo field of a table. Now I would like to delete a particular row from the memo. SI there a way to do it. My code fro ading is below (Note. AddtoMemo is a textbox, YourMemo is a memo field). Thanks Code (to add text to memo) =====================...

Hi, I am using MS Access which has a ODBC link to a sql database. I find that the linked table can be edited in Access. I would like to prevent editing in this Linked table. IS there a way? Thanks

Hi, Thanks for the prompt reply. Glad to hear that. I would like to know how to create 2 loops to create multiple columns in te detail section? The details section have serial numbers and also the component used. They have to be separated in multiple columns. Thanks.

Hi, I am looking to create a report like this in excel S(ee attached). Is it possible in Access?

Hi, I would like to know which report writer/creator is best to be used with MS Access, Report maker, crystal report etc? I am basically looking for a report creator/writer that vcan create header, can create columns (2 or more) under the detail section with boxes/lines and also create another...

Hi, I would like to export to excel the data stored in a table in Ms Access in Excel format (see attached). Is there a way I can do it? This excel file will be send to email later. The serial numbers and part nos will be expandable. All the data in the boxes and underline will be stored in MS...

Hi, How do I stored a previous value of a field when the record updates (e.g. Date delivered changed from 01-April-07 to 01 May 07) in a form. I would like to prompt the user after change like "Your Date has been changed from 01-April-07 to 01 May 07" after pressing the enter key or tab key on...

Hi, How do I disbale forms so that existing records will not scroll to next record. Thanks

Thanks Oldsoftboss. It works! I'm missing the "&" in my dcount function. I was about to give up dcount() function. lol.

Hi, I'm trying to use 2 criterias for this dcount function but I get "type mismatch" error. What I want to do here is, if the model (from model and to model) is not existing, activate a new form). Any help will be appreciated. Other alternative methods are welcome as well. Thank you. Private...

nice. BTW, where can I get the complete programmer guide for Access?

Hi, I am using a update query to update a table from another table. This query however will works only if I set the allowzerolength to yes in the table design otherwise validation error message will appear. This means that I cannot use the "Is Null " anymore because this empty space " " can...

Hi, I would like to convert zero if enter into null value during the data entry phase in a form. This means that zero values will be stored as null values. Is there a way? I am not able to do it in the input mask somehow. Thanks for any help in advance.

I have found a solution to my problem. Basically u need to use the wrkgadm.exe to join this secured.mdw when u copied the secured database and the secured.mdw into another PC and u can use the database after u login. I am trying to get a desktop icon to point to the secured.mdw instead of using...

Hi, I have created a secured database (using the user level security wizard). I would like to backup this secured database and use it in another pc (not networked). However I cannot accessed the database in the other PC. What are the things that I should copied (I have copied the secured.mdw...

Just my input on this (those who uses the user-level security wizard). U can allow user to change the password in Access 2000 by letting user have administration right in database only using tools->security->user and group permission. They will be able to change their own password but still...