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, 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...

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, 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

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...

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.

Hi, I need to run 2 batch files in MSDOS when the user run the macro in Access. The first runapp will copy all the files (at least 2 files) from floppy to a directory in c: drive. The second will decrypt the information and move it to a second location. However the seond runapp (decrypt)...

Hi, I am using the combo box in a form for selecting a report to be printed out. The source is a table with all the report names stored. I would like to prevent users from changing the data and yet they can can click on 1 single report they need. I cannot disable the allowedits in the combo box...

Hi, I have two tables created and link in a one-to-many relationship. I have created a tab form (for table 1) and in one of the tab pages, I have a subform with a second tab control in it (for table 2). So far it is displaying the correct data from these 2 tables. Now when I were to click a...

Hi, I would like to display a graph in a form along with the fields from a table. The user will be allow to update the table and the graph will be updated. So far I am able to display the graph on the report but I cannot find a way to display the graph on the form. Can somebody help? Thanks in...

Hi, I have design a form using the tab control. I need to add in color to make it more professional. Is there a way I can do it. I realised the filled /Back color icon is faded in color in design view. Appreciate any help in this. Thanks.