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: *

  1. PamelaD

    Copy value from field in one form to field in another form

    It worked like a charm! Can't thank you enough!
  2. PamelaD

    Copy value from field in one form to field in another form

    In Access 2000, I am working with two tables: tblContacts lngContactID [PK] strNameLast strNameFirst strAddress strCity tblMemberships lngMembershipID [PK] dtmDateJoined strMembershipName strMembershipType lngContactID [FK] Two forms: frmPersons [record source = tblContacts] frmAddMembership...
  3. PamelaD

    Cascading Combo Boxes: Only for unbound forms?

    Thank you both, Rolliee and Rick, for your suggestions/offers of help. I am still slugging away at this, and while I've made progress, I've still not got it right. So I’m wondering if you might be able to see what I’m doing wrong here: I have tblPersons, fields as follows: PersonID NameLast...
  4. PamelaD

    Cascading Combo Boxes: Only for unbound forms?

    From what I've read (KB97624 and KB98660)at http://support.microsoft.com/, the instructions to synchronize combo boxes call for putting two unbound combo boxes on unbound form. I'm trying to put a pair of synchronized combo boxes on a bound form. I'm having no success with this and wonder if...
  5. PamelaD

    Need code to create a single title for multiple reports

    cghoga: Thanks very much for the help! Best regards,Pamela
  6. PamelaD

    Need code to create a single title for multiple reports

    I have created a database of which I must make two dozen copies; this app will be used to house details of a legal cases.The application has several reports, each of which requires an identical text/title label, to identify the title of the case e.g. "US EPA v Toxic Chemical Co." or...
  7. PamelaD

    Need Combo Not in List event to open to a new record

    When I said I was a newbie, I wasn't kidding. I cannot seem to make this thing work. I have put a copy of it here: http://www.iserv.net/~plucas/access. Any chance you could take a look and see what I'm doing wrong? Will be much indebted, and I sincerely thank you for all of your help to this...
  8. PamelaD

    Need Combo Not in List event to open to a new record

    Thank you very much for taking the time to respond to my query. Upon reading your suggestions, I think that I might not have made myself clear in my initial description, as your solution mentions FormName(1) and FormName(2). If it is possible, I would like to do this using only one form, my...
  9. PamelaD

    Need Combo Not in List event to open to a new record

    From a newbie (using Access97) Table source is [tblBuildings], which has three fields, [BuildingID], [BuildingName], and [BuildingDetails]. My data entry form is [frmBuildings] (control source is [tblBuildings]). On [frmBuildings], I have placed an unbound combo box [cboFindBuilding] to use to...
  10. PamelaD

    Properties of subform controls: Color text in datasheet view?

    Bill, I do need the subform in a datasheet format, so I will just live with it for the time being. The person for whom I am making this may be upgrading to Access 2002 in the near future, so I can update it with your suggestion when she does. Thanks again for your responses. It is much appreciated!
  11. PamelaD

    Properties of subform controls: Color text in datasheet view?

    Thanks very much for your speedy reply, Bill. Upon attempting your suggestion, I realized I left out an important detail in my initial query: I'm using Access 97. My menu bar doesn't offer the option of conditional formatting. Any chance you have a "Plan B" up your sleeve?
  12. PamelaD

    Properties of subform controls: Color text in datasheet view?

    I am working with a main form (frmCases) on which I have placed a tab control with a subform (fsubCaseProgress) thereon. The subform displays in datasheet view. One of the fields in the datasheet view is a date field [TargetDate]. What I want to do is have the TargetDate field in this subform...

Part and Inventory Search

Back
Top