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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by cr84net2

  1. cr84net2

    Reload div after form submission success

    I have a classic asp site that is being partially updated to html5 and responsive design. There is a poll in an iframe that I am trying to move to a div. To do this I used $.get('Poll/poll.asp', function(data) { $('#poll').html(data); }); This loads the page/content into the div without...
  2. cr84net2

    Create recordset from 5 tables with identical fields then reference the records by table

    Sorry, still no luck. I am going to step away from this and reevaluate how I have this set up. Perhaps I should merge the tables and add a field that identifies each as either apparatus, department etc. I truly appreciate your help, and you sticking with me on this. I will post again if I...
  3. cr84net2

    Create recordset from 5 tables with identical fields then reference the records by table

    I changed table to Menu2 with the same result.
  4. cr84net2

    Create recordset from 5 tables with identical fields then reference the records by table

    Sorry posting at the same time again.
  5. cr84net2

    Create recordset from 5 tables with identical fields then reference the records by table

    O.K. Maybe I need to start from scratch. I have five tables that are identical. apparatus, department, news, public_inf and training_center. I need to create a recordset with the following fields from each table. ID, title, sorder and display. display needs to ='1' and I need to sort each table...
  6. cr84net2

    Create recordset from 5 tables with identical fields then reference the records by table

    When I run your sample it says I am using a reserved word. When I bracket the word [Table] that error goes away and I am back to the error: You tried to execute a query that does not include the specified expression 'ID' as part of an aggregate function.
  7. cr84net2

    Create recordset from 5 tables with identical fields then reference the records by table

    Skip, we must have been posting at the same time. I will give your query a try.
  8. cr84net2

    Create recordset from 5 tables with identical fields then reference the records by table

    I also tried this: select 'table1' AS app from(Select Count(app.ID) AS Acnt, app.ID, app.title, app.sorder, app.display From apparatus AS app WHERE app.display='1' ORDER BY IIF(ISNULL(app.sorder), 999999, app.sorder), app.ID) UNION ALL select 'table2' AS dept from(Select Count(dept.ID) AS...
  9. cr84net2

    Create recordset from 5 tables with identical fields then reference the records by table

    I tried it like this: select 'table1' AS app from(Select Count(*) AS Acnt, ID, title, sorder From apparatus WHERE display='1' ORDER BY IIF(ISNULL(sorder), 999999, sorder), ID) UNION ALL...
  10. cr84net2

    Create recordset from 5 tables with identical fields then reference the records by table

    After making the changes my select looks like below and is returning the same result. select 1 AS menu from(Select Count(*) AS Acnt, 'table1' AS app, ID, title, sorder From apparatus WHERE display='1' ORDER BY IIF(ISNULL(sorder), 999999, sorder), ID) UNION ALL select 2 from(Select Count(*) AS...
  11. cr84net2

    Create recordset from 5 tables with identical fields then reference the records by table

    Currently, I am not getting a resultset. This version is of the query is generating this browser error: You tried to execute a query that does not include the specified expression 'ID' as part of an aggregate function. Sorry I am not skilled at using the query tools in Access. Almost everything...
  12. cr84net2

    Create recordset from 5 tables with identical fields then reference the records by table

    I need to create a recordset from 5 tables with identical fields then reference the records by table. I also need the record count for each table. I am using this for a menu and I have been banging my head against the wall. Any help would be appreciated. This is the select statement I am...
  13. cr84net2

    I need to join 5 tables with identical fields then reference the records by table

    I need to join 5 tables with identical fields then reference the records by table for a menu on a website. The database is access (I know). I have tried literally hundreds of different approaches with no luck. Here is the Select statement that I am currently trying. dSQL="select 1 AS menu...
  14. cr84net2

    Multiple table select query

    You know, I am wondering the same thing now. This is one of those things that just got out of hand. First the client wanted one misc page to use as they wished, whenever they needed it. Later, after I was done with the bulk of the site, they said let's make it two...still later , how about 5...
  15. cr84net2

    Multiple table select query

    Hello, I have five access tables each with the same fields named misc1, misc2, misc3, misc4, misc5. There is a number field in each table named display. If there is a 1 in the display field, I need to display a linked image to a page where the content from the table can be shown. I have done...
See more

Part and Inventory Search

Back
Top