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

    Need Help with Search Form

    Depends a little on the field types of Recid, PID, PIDO, Pewd. Also depends on what fields you want to display. For instance, let’s assume these are all text fields, and you want to find the first and last names for records that match the search. You could try this, where “btnSearch” is a...
  2. EndoDoc

    webbrowser activex access2002 question

    I've got a label-hyperlink in my Access form (Access 2002) that seems to be set properly. When I click the label however, Internet Explorer (version 6.0) opens but I get a "Page cannot be displayed" error. If I click the refresh button on Internet Explorer, the page then displays...
  3. EndoDoc

    need help with web browser in form

    I've got a label-hyperlink in my Access form (Access 2002) that seems to be set properly. When I click the label however, Internet Explorer (version 6.0) opens but I get a "Page cannot be displayed" error. If I click the refresh button on Internet Explorer, the page then displays...
  4. EndoDoc

    option group filter in subform

    I've set up a filter in a form (subform actually) based on an option group. It is set up as such: Private Sub OptionGrpMedFilter_AfterUpdate() If OptionGrpMedFilter = 2 Then DoCmd.ApplyFilter , "DC = 0" Else: DoCmd.ShowAllRecords End If End Sub This works fine when I open this...
  5. EndoDoc

    able to create multiple item popup list?

    I understand your comment about it not being good database design, but this is simply a memo field for narrative text entry, and the combo (or list) box simply contains common words and phrases that may be entered quickly. The list box would work, but the problem is that it doesn't disappear...
  6. EndoDoc

    able to create multiple item popup list?

    Hi all, It's been farily easy to have a single combobox value added to a text field. However, what I would really like is to have the combobox open, choose several items from it, and then have all the chosen items added to a text field. Is this possible (and simple) to achieve? Thanks for any...
  7. EndoDoc

    save copy of report

    Sounds like just what I need. By an image folder, I guess you just mean a directory designated for SNP files. Thanks for the help! Len
  8. EndoDoc

    Calculate a value from 2 fields to a 3rd field in same table.

    you can't make calculated fields in tables, but you can in Queries! Create a query based on your table, and in a blank field, just type "=(wage1 + wage2)/2" (or something like that. The field will automatically be named Expr1:.... You can then rename Expr1 to whatever you wish...
  9. EndoDoc

    save copy of report

    When I create and print a report, is it possible to save a copy of the report saved as a separate field in a table? For instance, have a table with fields: [reportdate] and [reportcontent], where [reportcontent] is essentially a large memo field (or .pdf or .doc file or whatever). Then when a...
  10. EndoDoc

    help with medication database

    Thanks for your response. The way I have it now, I have a main "Chart Form" with two subforms -- one for "Visits" and one for "Medications". It is easy to enter medication data this way. Now your suggestion would also work. However, the medication list often...
  11. EndoDoc

    help with medication database

    Maybe someone can help with the structure of my medication database. I have 3 tables: (1) Charts -- with name, address, etc; (2) Visits -- with information specific to each time a patient comes to the office; (3) Medications -- with drug name, dose, etc. "Charts" is the parent table...
  12. EndoDoc

    help with links to subforms

    Hope someone can help. I have (using Access97) a parent table (call it table A, for example) with several child tables (call them A1, A2, A3) for example. The relationships are set as one-to-many. I now have a main form with some data from the parent table near the top, and then three tabs on...

Part and Inventory Search

Back
Top