Search results for query: *

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

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

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.

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

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

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.

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

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

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!

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.

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

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