Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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