Search results

  1. S

    TextBox Width in Report

    Is it possible to adjust the width of a textbox based on the number of charaters in it? Specifically, I have two textboxes on a letter, one for the first name and a second for the last name. Is it possible to adjust the textbox width on each letter so that the spacing for the names ([FName]...
  2. S

    Using Combo Box linked to subform

    Hello, I have a "Pop-up" form that asks the user to selected a Participant from a combo box list. The user then hits SUBMIT button, and opens a form. The problem I am having, is that the participant is a field in a subform that is one the form that the user is trying to open. I can not get...
  3. S

    How to Hide Field when null on form

    Will this work on a report Will the above code work on a report? I have a field that if 'IS Null' I don't want to be visible when the report is printed. Thanks
  4. S

    Subreport totals

    This solution did not work, I ended up with an error asking for the Parameter value [TotalLoans] Any other suggestions?
  5. S

    Subreport totals

    Hello, I have searched previous postings, and can't seem to find the solution to my particular problem. I have a report sorted first by year then by soc. sec #. I have a subreport that lists the various loans made to a person over the course of a year (each person can have numerous loans). In...
  6. S

    Option Group Value to Text

    Works great ! Thanks
  7. S

    Option Group Value to Text

    On a form I have an Option Group consisting of two choices, "Day" and "Evening". In a report, I would like to have the Text "D" & "E" replaces the values (1, 2). What would be the best way to accomplish this. Thanks,
  8. S

    SubForms and Tabs

    Good Morning All, I have tried to search previous posts, but can not find one that addresses my problem. I have a form with Student information, I then have four subforms(Request, Loans, Grants, Awards) each one is on a seperate tab. All the subforms are linking using a student ID. What I...
  9. S

    Sql Insert

    Pat, Is it possible to make the text box bound if the table resides in a seperate database?
  10. S

    Sql Insert

    I have hit a road block. I have created a "Front End" data entry DB. The user will select a "Goal" from an unbound list box linked to tblGoal in another Main_DB. The user will then enter into an unbound text box ways that they will "meet" [Action] the Goal selected. I have successfully been...
  11. S

    Automate Importing Text file into a table

    Hello, Is it possible to automate the importing of a text document into a table, then once the table is populated, run a query? I would like to have both actions completed with a push of a button. Any help would be greatly appreciated. Thank you in advance Svnty7
  12. S

    Add Record to a table

    Hello, I have data (test scores) saved in a text file format that I would like to import into a student table based on specific social security numbers. What would be the best way to do this. Thank you:
  13. S

    Linking Subform

    Is it possible to have a subform1 linked to the main table, then to have subform2 linked to subform1? If so, how ? Thank You 77
  14. S

    Archiving text Field

    I am trying to create an archive table for a text field that would capture the data prior to a change/update to the field. example: ["Acquire CIHE accreditation..."] has been changed to ["Maintain CIHE accreditation..."]. I have tried to create an append query, that runs when there is a...
  15. S

    Page Numbers

    Is is possible to set the page numbers on a report to look similar to this: Page 1 of "..report section name.."? Thanks
  16. S

    Don't print field when value is Null

    In a report, I want a specific field label/caption in the detail section to not print if the field value is Null. This field is the only field in the detail section. Any hints?
Back
Top Bottom