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

    bound check box - floating based on a condition

    Any help would be appreciated. I would like to add a check box to my form that relies on the following condition; however, I can't seem to get the syntax right. Iif([tblbib].[ISSN]=[tblprior].[ISSN], TRUE) Many thanks, jessica
  2. jlmeek

    Appending Records

    Thank you, Thank you, Thank you. I started to ask how would I write the SQL, but I figured it out during the typing process. UPDATE tblbib, tblcoverage SET tblbib.EstimatedVolumes = tblcoverage.EstimatedVolumes WHERE tblbib.ISSN = tblcoverage.ISSN; Thanks again, jessica
  3. jlmeek

    Appending Records

    I have two tables: tblbib tblcoverage I want to apphend a column (estimatedvolumes) from tblcoverage to tblbib where tblbib.issn = tblcoverage.issn. I created the column in tblbib prior to running the append query. I dropped column estimatedvolumes into the append query - click run (because...
  4. jlmeek

    Custom Query Interface

    Jeff - Thank you for pointing me in the right direction! -j
  5. jlmeek

    Custom Query Interface

    Is there a way to create a custom query interface for users where they can select multiple criteria to run a query just by selecting say, radio buttons or the like?
  6. jlmeek

    Referential Integ & Linked tables

    Is there any way to set referential integrity for a relationship between a linked and nonlinked table? Thanks, jessica
  7. jlmeek

    Printing results of a list box (which are tied to combo boxes)

    Thanks Terry, Below see my SQL statement, combo box names, and the vba code for the combo boxes. SQL Statement: SELECT DISTINCT [qrycombo1].[ISSN], [qrycombo1].[Title], [qrycombo1].[Provider], [qrycombo1].[Frequency], [qrycombo1].[LC], [qrycombo1].[Authoritative], [qrycombo1].[Content] FROM...
  8. jlmeek

    Printing results of a list box (which are tied to combo boxes)

    Terry, Thanks for the suggestion but I tried that last week and it doesn't work. It's as though the query never changes except on the form. Even though the user is making choices it is not updating the query to reflect the criteria (if that makes any sense at all). -jess
  9. jlmeek

    Printing results of a list box (which are tied to combo boxes)

    Any help would be much appreciated. I have a form with two combo boxes (campus and provider) and a list box. The user chooses his/her criteria from the combo boxes and after update displays the results in a list box. How can I, if it's even possible, print the results displayed in a list box?
  10. jlmeek

    HideDuplicates property in Reports

    Kathryn - Thank you, Thank you, Thank you!!! Your fix worked and it was so easy. Regards, jess
  11. jlmeek

    Command button: turn on/off edit mode

    Hi Jerry, Thank you for your suggestion; however, by deleting 'Me.Requery' from the event my edit on/off command button I created doesn't work properly. For example, my user is browsing the database she comes upon a record that needs to be updated so she clicks the button to turn on the edit...
  12. jlmeek

    Command button: turn on/off edit mode

    Is there any way to stop Access from returning to the first record when a command button turning on the edit mode is clicked? For example, if a user is browsing the database via the form and comes upon a record that needs to be updated and clicks on the turn on edit mode button she invariably...
  13. jlmeek

    HideDuplicates property in Reports

    I have duplicate data in a table, but when I run a report I would like to hide the duplicate data. When I click Yes to HideDuplicates in the text field property and run my report - a blank space remains where the duplicate data is hidden. How can I both hide the duplicate records and remove...

Part and Inventory Search

Back
Top