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 TouchToneTommy 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: sdavid74
  • Content: Threads
  • Order by date
  1. sdavid74

    Math Operations with DCount Results

    I have this line in a control box to count a number in a specific field =DCount("[LastName]","OrientationMain","[Session 1] = True") Now, on the same form, I am trying to multiply the result of this DCount by different numbers. I know this should probably be...
  2. sdavid74

    Lotus Notes Help

    I have looked over the history of this forum, but I wasn't able to glean the information that I needed. I have a db with contacts to whom I would like to be able to send emails (both individually and group). I view all the contact info on a form where I would like to have a button or two that...
  3. sdavid74

    print only selected records or send selected records to a temp db?

    Is it possible to set up a temp. database with the fields from my main db without rebuilding the db? Or is it possible to send selected records to a temp db? If so, can I use the same reports that I use with the main database? The reason is that I need to print about 200 labels, but I know I...
  4. sdavid74

    form filter

    Is there any way to put a filter on a DCount function so that it will only count records that meet certain criteria? My goal is to count the number of records marked "true" that are contained in "MyTable" and record that number on "MyForm" Any ideas?
  5. sdavid74

    display the number of not null fields

    I want to display the number of fields that contain "not null" values. I can do it on a report...in a roundabout way...what I did was a DCount function on one field, then the other..in two separate control boxes, and then added them together in another control box(TotalParent).....I'm...
  6. sdavid74

    count not null values in two fields

    I would like to display the number of "not null" values that exist in two separate fields. Fields "Parent_1" and "Parent_2" hold parents names, and I simply need to know the total number of parents. Will the Count function do this? If so, can anyone help me on the...
  7. sdavid74

    Record count from a query available on a form

    Is there a way that I can display the record count in a certain query on a main form page? I have a main page that I use to navigate among query results, forms, and reports, and, from that form, I would like to display how many records are in each query.
  8. sdavid74

    Query count on a form?

    Is there a way that I can display the record count in a certain query on a main form page? I have a main page that I use to navigate among query results, forms, and reports, and, from that form, I would like to display how many records are in each query.
  9. sdavid74

    View all records after opening in "add new record" format

    I have a form set to open up to a blank record by inserting this script, (from this forum), DoCmd.OpenForm "OrientationMain", , , , acFormAdd and from this page I can't see any of the old records, which I'm OK with, but when I try to insert a command button that will open up the...
  10. sdavid74

    Date function on print button?

    I have an input form that I also use to view data. On the form is a button that prints out a report using the current record's data. Is there any way to view the date that the report was last printed?

Part and Inventory Search

Back
Top