Search results for query: *

Oops! The whole thing was my fault--in copying code just before the 'offending' code, I cleared the wrong internal table, so I merely added each new search's results to the old one. As they used to say on Laugh-In, "Never mind!

I have 3 tables that I use temporarily to display search results in a DataGridView. At the start of each search, I delete all of the rows and then save the search results. For the first 2 tables, this process works entirely as expected, but for the 3rd table, the delete only works the first...

Hi, again, cheerio. I have so far tried the UNION statement with just this piece of the query, and it works great! Next, I will put the UNION at the tail of my long SQL statement in the full search query and test that out. I'll try to reply again as soon as I've had a chance to break away...

Thanks, cheerio. I will try the UNION query. I'm not really working in Access. I'm programming VB 2005, but in order to do cross-db queries I'm using an Access DB to link tables from several sources--some SQL server and some Access. I'm also cross-testing directly in the Access linked DB to...

I have a Visual Basic application with a very complex search page, most of which works exactly as planned. One piece of the SELECT statement, simplified for testing, reads thus: [SELECT #1] SELECT STRUC_ID, DRWG_NO, STRUC_NM, STRUC_TYP_CD FROM dbo_STRUC WHERE (dbo_STRUC.STRUC_ID IN (SELECT...

Short story: Sometimes the ReportViewer displays fewer pages than it has formatted from the underlying table, often starting on "Page 2 of 5" (navigation controls say "1 of 4") or "3 of 5" (navigation controls say "1 of 1"). Clicking on the Refresh button displays all of the pages. The...

VB 2005 is version 8. .NET was version 7. When you build your project, it creates both a debug version in the bin\debug folder, and a release version in the bin\release folder. You don't have to choose as we did with previous versions of Visual Studio.

It is quite simple. Set the Dock property in the ReportViewer control to "Fill", then when you resize the form, the report automatically resizes itself.

Hello! I have a simple Access report with a group header that repeats across pages in Print Preview, but when I actually print the form, Access resets the RepeatSection property to FALSE, and it cannot be set by a simple assignment statement in VBA (i.e., it generates an error message), though...

Hello! I have a simple Access report with a group header that repeats across pages in Print Preview, but when I actually print the form, Access resets the RepeatSection property to FALSE, and it cannot be set by a simple assignment statement in VBA (i.e., it generates an error message), though...

I can't wait to try it. Thanks for your help!

Interestingly, Boolean algebra tells us that when combining one condition that is always TRUE with another condition that varies, you only need test the second condition. What I mean is, that if you have chosen ALL for the warehouse area, you can word your query to select for the current value...

If you have typed it exactly as presented, the first problem is that the "Then" has to be on the same line as the "If". Second, the "Then" has no verbs. Third, the "Then" line has "Or", which is only relevant in the "If" condition, unless you intend to use it as a bit-wise OR operator, which...

I'm new to the group, and haven't crafted a search intelligently enough to find what I'm looking for, and haven't the time to look at all of the threads in this forum. Here's what I'm after: I save an Access report as an .RTF file, intend to copy a macro from Normal.DOT into it, and then run...