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!

  • Congratulations Westi 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. jpkent

    footer subtotals with grand totals; use subreport?

    Thanks, I didn't think it would be that easy. I just made the report's record source handle all the totals instead of making an independent query. Works all the same.
  2. jpkent

    footer subtotals with grand totals; use subreport?

    I did plenty of searching on this topic here and didn't find anything helpful, or atleast anything I understood. My problem is, I have a report that displays records by doctor, and within each record for that doctor there are a series of checks. I was able to handle grand totals just fine, but...
  3. jpkent

    Listboxes, ItemSelected, Control Source, Multiple Fields...

    Ah ha, but the table will be closed. I was planning on adding a new field with another form (not bound to the table). How's it done? I haven't found any helpful information on this other than a cumbersome SQL statement that won't let me supply format parameters to my new field.
  4. jpkent

    Listboxes, ItemSelected, Control Source, Multiple Fields...

    Thank Neil, but actually I just realized I don't have a complete solution yet. What we've figured out so far is how to find and edit new fields in a table, but I realized that I need to be able to add a new field to my table, preferably through the use of a form and not through manually editing...
  5. jpkent

    Listboxes, ItemSelected, Control Source, Multiple Fields...

    This is exactly what was looking for, and for those who are interested, there's one little suggestion I would make so that the listbox can deal with a changing amount of checkboxes, as well as speed up this procedure a bit (should only matter if you have a massive amount of checkbox fields)...
  6. jpkent

    Listboxes, ItemSelected, Control Source, Multiple Fields...

    I have a table in which each row has several checkboxes (yes/no) fields. I thought that instead of modifying this data through using checkboxes on a form, it would be easier to modify this data using a listbox with it's multiselect property set to simple, so that if the user selects an item in...
  7. jpkent

    Ignoring Nulls in Query

    I have a query where my last argument uses the following criteria: IIf(IsNull([Query Compare]![OTHER/UNLISTED]),[Patient Information]![OTHER/UNLISTED],[Query Compare]![OTHER/UNLISTED]) [Patient Information]![OTHER/UNLISTED] is null (as far as I can tell, there is nothing in it and no spaces)...
  8. jpkent

    Multiple Select Listboxes saved to Table

    Hello - and I may as well get this out of the way, I'm painfully new to Access, sorry - but I'm taking on what I believe to be a simple project, and one of the problems I've run into is that I can't get any of the items in a multi selection listbox into a table. Now, I want to back up a step...

Part and Inventory Search

Back
Top