Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mtabt
  • Order by date
  1. mtabt

    way to save data for revising later but read-only when completed

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

    way to save data for revising later but read-only when completed

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

    way to save data for revising later but read-only when completed

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

    Continuous subforms that display across not up and down

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

    Continuous subforms that display across not up and down

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

    Subreports show label instead of blank space when there is no data

    Thank you very much, you have been very helpful.
  7. mtabt

    Subreports show label instead of blank space when there is no data

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

    Subreports show label instead of blank space when there is no data

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

    Subreport shown something else when there is no data

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

    How to enter more than 255 characters in a field

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

    Restrict the users to insert an object from a existing file only?

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

    Restrict the users to insert an object from a existing file only?

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

    Populate a text field from a combo box

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

    Restrict the users to insert an object from a existing file only?

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

    Restrict the users to insert an object from a existing file only?

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

    Command button to insert object to bounded frame object box

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

    Refresh main form after activities in the subform

    ...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, , acMenuVer70 *DoCmd.requery etc. But, nothing works. However, if the command button is...
  18. mtabt

    Command button to insert object to bounded frame object box

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

    Can't savechanges to forms, reports, macros unless open exclusively

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

    help...query question

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

Part and Inventory Search

Back
Top