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

    Put Access on a Diet?

    I have an application that is complete. The tables are linked to another MDB, but the forms, queries, and code are included in the applciation MDB. The size of this single file is in excess of 70Mb when compressed. Upon exiting the MDB is compressed each time. On slower PCs this takes about...
  2. bgv

    Multi-Select Paired ListBoxes

    I have downloaded an example for paired listboxes from http://www.helenfeddema.com/pub/Controls 2000.mdb. It works well for a single selection, but I want to implement it as a pair of multi-select listboxes. I have changed the listbox parameters as extended multi-select fields and have gotten...
  3. bgv

    Query for Highly Custom Report

    I have a report to be created will need to look like: Date Hours Date Hours Date Hours Training Course #1 02/01 2 05/20 2 08/20 2 Training Course #1 04/01 1 05/10 1 04/20 1 The data comes out of an activity table in sequential record format by...
  4. bgv

    dual list box form

    I want to build a form using two listboxes. The list box on the left would contain all of the records from a query of a lookup table, but without the records either previously selected or moved from the left list box to the right. The intent here is to use the left listbox as the master list...
  5. bgv

    ListBox multiple selection from table query

    I've seen the threads for allowing a multiple selection in a listbox. How would you select multiple records in a listbox of 200 records based upon a table query? This should display a list of records with multiple selections previously saved in the database table. For example: Dim qualList As...
  6. bgv

    Loop between two dates

    I have a form that has a starting date (txtStartDate) and a stop date (txtStopDate). How do I set up a for next loop to enter each date as a value into a table?
  7. bgv

    sim-Requery in an unbound tabbed form

    I have a tabbed form with four forms attached; Employees, Station Manifest, Daily Roster, and Activities. The Daily Roster form is unbound but are populated currently from a query. All but one of the fields on the Daily Roster form are locked, since they are read from the table query. I have...
  8. bgv

    Continuous subforms and combo boxes

    How do you make combo boxes in a continuous form operate independently for each record in a subform? I have a combo box that is populated using a query. When I pick a value from the list, EVERY combo box for each record changes simultaneously rather than being able to select a different...
  9. bgv

    Copy a Record with a Mask in Place

    I want to duplicate a record (but leave one field empty to be modified before saving the record). By following the non-programming methods for duplicating a record, either using the Duplicate Record button or by highlighting the record on the left, copying and then pasting, it duplicates...
  10. bgv

    Button switches subform Datasheet --> Form view

    How can I set up a button on a master form to switch a subform from datasheet view to form view and then back again?
  11. bgv

    Passing args: One form to subform of opened form

    I want to pass a date from a calendar-based form to a subform of a master form: e.g. calendar form --> activity form --> activity subform I am already passing the OpenArgs variable from the calendar form in the OpenForm command to the activity form. How do I get the activity form to pass...

Part and Inventory Search

Back
Top