Recent content by Annabelle

  1. A

    How do I set print order for report?

    Is there a way to tell a subreport (printing on a report) to print in a particular order. FYI - it is being told to print in alphabetical order but there are a couple of the items we need to print at the top, then we want the rest to print in alphabetical order. Can this be done?
  2. A

    Syntax Error in From Clause

    Now a Join Error Appears I made a few changes and now I get the error "Syntax Error in JOIN Operation": SELECT [tbl_Join_Model&StandardFeature].[ModelID], [tbl_Reference_StandardFeatures].[Feature], [tbl_Reference_PackageItemCC].[Item], [tbl_Reference_UniqueChaparral].[UniqueItem] FROM...
  3. A

    Syntax Error in From Clause

    Can someone please help me with the answer to the error "Syntax Error in FROM Clause": SELECT [tbl_Join_Model&StandardFeature].[ModelID], [tbl_Reference_StandardFeatures].[Feature], [tbl_Reference_PackageItemCC].[Item], [tbl_Reference_UniqueChaparral].[UniqueItem] FROM...
  4. A

    Speed Enhancer

    I am not familiar with a built in analyzer.
  5. A

    Join Error in Record Source for Report

    Answer found Hi, I found the answer to my question over the holidays. Thanks so much for responding.
  6. A

    Speed Enhancer

    Does anyone know of a speed enhancer for Access. I have split the database. It has been compiled. And I often Compact and Repair the Database. Is there a way to speed enhance the database.
  7. A

    Join Error in Record Source for Report

    I get the error "Syntax Error in Join Operation". The record source reads SELECT [tbl_Reference_StandardFeatures].[Feature], [tbl_Reference_PackageItemCC].[Item], [tbl_Join_Model&StandardFeature] FROM tbl_Reference_StandardFeatures INNER JOIN ((tbl_Reference_StandardFeatures LEFT JOIN...
  8. A

    Line Break

    Thanks Anyway. Once again I fixed my problem.
  9. A

    Line Break

    Is there a way to list several items in one field, but to get the list to print on separate lines in a report? Example in field in table: Fishing Seat w/ Pedestal, Tackle Organizer, Trolling Motor Example to Print in Report: Fishing Seat w/ Pedestal Tackle Organizer...
  10. A

    Select Case Problem

    Thank you so much for all the help. My problem has been fixed.
  11. A

    Select Case Problem

    FYI - The brand is selected from a combox box and all data selected in the form is sent to a table called tbl_Inventory_Main.
  12. A

    Select Case Problem

    Does this mean I should not be using a Select Case statement? All I need to do is get the right report to preview based on which Brand is selected on the form.
  13. A

    Select Case Problem

    Please know I am not real knowledgeable on select case statements but I believe this is a way to achieve what I need.
  14. A

    Select Case Problem

    I have a form which previews a report at the end by clicking a command button. I need the report being previewed to be determined by a choice during completion of the form. Example: If Brand = Harris Flotebote Report to Preview = rpt_WindowSticker If Brand - Nautic Star Report to Preview =...
  15. A

    Trouble Populating Form

    There are tables and querires set up which are also involved in the process. I'm sorry for not being better at explaining this. But it is a little difficult.
Back
Top Bottom