Search results for query: *

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

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

I changed table to Menu2 with the same result.

Sorry posting at the same time again.

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

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.

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

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

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

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

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

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

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

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

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

I have an swf that plays a video (toobplayer component) and has two dynamic txt fields. The video and both txt fields are "fed" from an xml file. I also have a movie clip that loads an image on another layer and is set to an alpha of 0. Is there a way to use a conditional statement to check the...

RobertC22, Thanks for the help, I found similar information and made the corrections but help is always appreciated. Thanks

Thanks for your help, that generated a result without an error. It still opens another hta file though..any thoughts..

PHV, Thanks for bearing with me here. I am now getting an error on the following line: strOut=wshShell.Run(RC4(Document.Forms("form1").Item("t2").Value, Document.Forms("form1").Item("t1").Value)) The error is: line 44 char 1 The system cannot find the file specified Then the hta asks me...

I have made several modifications to the hta and now i don't get an error until I click the button. The error i get is: Object Required: t2 This is on the line: strOut=wshShell.Run(RC4(t2.value, t1.value)) t2 is a txt input box-how would I make it an object?? Here is the entire code...