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

Thank you very much, you have been very helpful.

Thanks for your reply, In your report, is the Label in the subreport or in the main report on top of the subreport box? Also, is it the NO DATA Event in the subreport or the main report? I tried this solution before with every possible combinations, and I can't seem to get it to work...

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

That's I have, a dialog box pops up asking my users to choose between creating a new object or attach one from a file. I don't want my users to have this choice. I only want my users to attach an object from a file and they can choose the type of file and location where the file is...

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.

Thank you for help. However, your suggestions do not help me. I want the user to determine the location and type of file he/she wants to attach. Using your method I have the specify the "SourceDoc" and "Class" of the attachment. I want to open the option to the user. If...

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

Thank you for your help, LonnieJohnson. Everything works fine. 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 an object by "create new" or "create from file". I...

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

Thank you again RickSpr. However, it did not work. The query still returns as if all criteria have to be satisfied. If I only select one of the three, I get nothing. If I only select two of the three, I still get nothing. If I select all three then I get the records that meet all three...