Search results for query: *

I need a way to allow restricted users to save their partially inputted data into a form to be revised at a later date. However, once the input is completed and confirmed, they cannot make changes anymore, thus the data become read-only for them. Is there a simple way to implement this...

I need a way to allow restricted users to save their partially inputted data into a form to be revised at a later date. However, once the input is completed and confirmed, they cannot make changes anymore, thus the data become read-only for them. Is there a simple way to implement this...

I need a way to allow restricted users to save their partially inputted data into a form to be revised at a later date. However, once the input is completed and confirmed, they cannot make changes anymore, thus the data become read-only for them. Is there a simple way to implement this...

I have a form that contains a continuous subform with many records. Normally the continuous subform display vertical (up to down) with the 1st record on top, then 2nd record, etc. Is there a way to display the continuous subform horizontally with each records display next to each other across...

I have a form that contains a continuous subform with many records. Normally the continuous subform display vertical (up to down) with the 1st record on top, then 2nd record, etc. Is there a way to display the continuous subform horizontally with each records display next to each other across...

I have a report with about 6 subreports. In some cases, some subreports do not have any data. In those situations, I would like to replace the subreports with a label showing "No Data". I would like the labels to be in the same space where the subreports are. Basically, instead of...

I have a report with about 6 subreports. In some cases, the some subreports do not have any data. In those situations, I would like to replace the subreports with a label showing "No Data". I would like the labels to be in the same space where the subreports are. Basically, instead...

I need to allow users to enter more than 255 characters in a field. I know this is a stupid way but my boss doesn't want me to change the procedure. Is there a way to input lots of text in a field? I know I can use an MS Word attachment or something, but I am trying to avoid that. Anything...

My table contains a field that is a bounded frame object. I have a command button that users can click to insert any object they like. However, is there a way to restrict the users to insert an object only from a file rather than new..?? By default, a dialog comes up asking if you want to...

I have a form that contains a combo box (RCNAME) and a text field (RC#). A RCNAME uniquely corresponds to a RC#. I want my users to choose a RCNAME from the combo box and automatically get the corresponding RC# in the RC# field. How do I do this.??? Please help. Thank you very much in advance.

My table contains a field that is a bounded frame object. I have a command button that users can click to insert any object they like. However, is there a way to restrict the users to insert an object from a file rather than new..?? By default, a dialog comes up asking if you want to insert...

I have a command button in the subform of main form to bring up another form (form1) to enter data. After the form1 is closed, I need to refresh the main form and subform to reflect the changes. I tried the normal way such as *DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ...

My table contains a field that is a bounded frame object. It is shown on my form, I would like to add command button so users can insert any object into the bounded frame object at will. Currently, users have to right-click on the bounded frame object box and insert the object that way. I...

I inherited a database from an employee that went to another company. When I tried to modify the design of the forms, reports, macros, and modules, I get the following message: "You do not have exclusive access to the database at this time. If you process to make changes, you may not be...

Is there a simple way to capitalize only the 1st letter of words (names) that are being entered through a form..?? Also, is there a simple way to capitalize only the 1st letter of a SENTENCE... I am not an expert in MS Access and not too familar with modules, please can you suggest a simple...

I am creating a query with 3 fields for selection criteria: (discipline), (keyword), and (facility). I am using combo boxes in a form to select the records. Is there a simple query that can do the following: * select (discipline), (keyword), and (facility) and get records the satisfy ALL 3...