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

    DataTable Delete() method inconsistent

    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!
  2. DENewkirk

    DataTable Delete() method inconsistent

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

    SELECT with complex WHERE bombs with error code 0xc0000005

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

    SELECT with complex WHERE bombs with error code 0xc0000005

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

    SELECT with complex WHERE bombs with error code 0xc0000005

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

    ReportViewer (local report) sometimes skips some pages on initial view

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

    How to create a basic .exe

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

    Resize Report in Windows Form

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

    Repeat Group Header during printing

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

    Repeat Group Header when Printing

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

    Copy a macro from a Word .DOT into an .RTF file.

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

    Syntax Error on IF_THEN_ELSE statement

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

    Syntax Error on IF_THEN_ELSE statement

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

    Copy a macro from a Word .DOT into an .RTF file.

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

Part and Inventory Search

Back
Top