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: *

  • Users: af390
  • Order by date
  1. af390

    dynamically alter position of subreports on main report

    Thanks. That should do it. I do it for fields....forgot you can do it for reports also!
  2. af390

    Count records in descending order

    a loop that decrements should give you what you want. Dim rst as recordset Dim i as integer i = 0 for i = (rst.recordcount) to i = 0 rst.[record_number_field].value = i i = i - 1 Next Hope this helps
  3. af390

    How to delete the link from a linked table?

    The best way I know of to remove a link is to import the source table into your database and then delete the link icon. To remove tables from the qbe, right click on the table and select remove table. Hope this helps.
  4. af390

    dynamically alter position of subreports on main report

    my main report has 10 sub reports - each reporting differeing data for a specific account. Occasionally, some of the subreports have no data. Is there a way to cause the NO DATA report to hide (I know the HasData and NoData) while causing a report WITH data to be displayed in the hidden (no...
  5. af390

    Subform visibility

    you can use DCount to check for "no records" on your subform if DCount (SELECT DISTINCTROW [W-Order].[W-Order], [W-Order].Qty, [W-Order].Status, [BOM].Qty, [BOM].Parent, [Parts].[Part No] FROM [W-Order] LEFT JOIN ([BOM] LEFT JOIN [Parts] ON [BOM].Parts = [Parts].[Part No]) ON [W-Order].Product...
  6. af390

    Apply a filter to a form onopen

    What code have you tried so far? i.e. DoCmd.ApplyFilter [fieldname] = False There's a good example in the Litwin, Getz Access Desktop programming book.
  7. af390

    MS Query won't open MS Access database for import to Excel

    That's kinda what I thought. Just wanted to toss it out there and see if someone had an easier solution. I've inherited someone else's program......sigh. Thanks
  8. af390

    MS Query won't open MS Access database for import to Excel

    I am trying to import MS Access data into a very complicated multi sheet Excel spreadsheet. The data is back end protected by a workgroup secrity login protocal that MS Query is not able to process. Any suggestions on how to program MS Query to accept the login protocal. This is the security...
  9. af390

    Recordset/SQL problem - not returning correct record or returns an err

    Thanks for all the valuable insights. I found my answer by actually paying attention to the arguments for the OpenReport method. All I have to do is pass a WHERE clause and Access applies it to my underlying query. Works like a charm. Thanks again all!
  10. af390

    Recordset/SQL problem - not returning correct record or returns an err

    Thank you. I do have it as a string literal, in my haste I left out the quotes in my post. Silly me. I would love to use ADO, but am stuck trying to fix clients old database.
  11. af390

    Recordset/SQL problem - not returning correct record or returns an err

    I have the following simple code to create a recordset (rst) that I then need to re-query based on entries from a user. Set rst = db.OpenRecordset(SELECT * FROM tablename) when this line executes I get 1 record. When I execute Set rst = db.OpenRecordset(SELECT DISTINCT * FROM tablename) I get...
  12. af390

    how to force page on non-sorted/grouped report

    I have to build a report that has text boxes as "headings" followed by tabulated data and a "can grow" memo of undetermined size. I need to force page breaks so that a one title is not left at the bottom of a page and the data is at the top of the next. The data tabulation is not orgranized in...

Part and Inventory Search

Back
Top