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

    Select and Union result into Crosstab-type in one query

    r937 I have tried your subquery but I am getting a synta error around the following: select custid,yearid , sum(amount) as T1sum , 0 as T2sum I can't seem to trace the source of this error. Any ideas JDRoss
  2. JDRoss

    Select and Union result into Crosstab-type in one query

    create temporary table t select "T1" as source,Custid,yearid,amount from table1; insert into t select "T2" as source,Custid,yearid,amount from table2; insert into t "T3" as source,Custid,yearid,amount from table3; insert into t "T4" as source,Custid,yearid,amount from table4; select...
  3. JDRoss

    Select and Union result into Crosstab-type in one query

    thanks r937, I will try your subquery solution too. In response to the error 1064 syntax question, I have traced the problem to one of the tables. Possibly some blank DataTimeStamp fields. Mysqlfront was able to show me were it was stopping. I have reimported the data for this table, I will...
  4. JDRoss

    Select and Union result into Crosstab-type in one query

    I was not using MySQLFront, I was using something similar, I imagine, it is DBManager from DBTools Software. But I have downloaded MySQLFront since your message When I run the code in this, I get the error message. ERROR 1064 (You have an error in your SQL syntax. I have tried it with...
  5. JDRoss

    Select and Union result into Crosstab-type in one query

    Thanks hvass, This is very helpful. I cut and pasted the solution you suggested but I am getting a MySQL error around the first semi-colon. I notice there are semi-colons after each Select, or Insert Into, I am sure they are all necessary? Regards John
  6. JDRoss

    Select and Union result into Crosstab-type in one query

    Maybe this is impossible? I have four tables of identical structure but not related. I am running a Select on four tables with three Union All. I would like the result from the Select and Unions (which work fine) to be routed into a Crosstab-type query to gvie the result from each table in...
  7. JDRoss

    Multihoming issue - LAN cards will not work

    With reference to thread779-631277 regarding problems with XP and multi-homing, I am wondering if this problem extends to having no traffic on LAN cards, i.e. no detectable network settings in Windows XP Home edition? I installed a Linksys wireless LAN card on a Dell Dimension, which already...
  8. JDRoss

    Union All and Relationship issue

    Based on ideas from thread705-760513 I developed a Union All sql query to extract data from four tables all with a common yearid field. I was able to know which table the data came from thanks to an idea from TonyJollans (Programmer) in the above thread to add a marker to each table. It works...
  9. JDRoss

    Access printer driver not printing image or currency formatting on Bro

    Thanks Onoski I have installed updated drivers for the printer, as I say, it prints fine from Word. John
  10. JDRoss

    Access printer driver not printing image or currency formatting on Bro

    I have a client using a Brother MFC-890 printer. Whenever they print from Access the amounts on the report formatted for currency will not print or show, i.e. they are blank. (they show in the preview but not on the page). If I take away the currency formatting the amounts print fine as...
  11. JDRoss

    Commandbarscontrol and right mouse click

    Thanks Zameer Great article! John
  12. JDRoss

    Commandbarscontrol and right mouse click

    Zameer "...also make sure that it customized only in this database by opening another database." I did the shortcut menu thing you suggested but I wasn't quite sure what the following meant "then drag the commands that you don't want to the dialog." I right clicked the deleted the menus and...
  13. JDRoss

    Commandbarscontrol and right mouse click

    Thanks Zameer and VBSlammer, I will implement your suggestion Zameer for now but I am also interested in VBSlammer's approach, can you give me some idea how to go about creating custom menus? And is it possible to save these and have them for other databases as well? John
  14. JDRoss

    Commandbarscontrol and right mouse click

    I have security concerns for a backend database. Though it requires user-level logon access, I would still need to disable Access menu items. I don't have any custom menu bars, but I would like to disable "Export" features and other database utilites from the curious. So far when I run this code...
  15. JDRoss

    Default Value=Now(), datediff not giving resutls

    >=(Date()-90) & " " & #00:00:00# Thanks Bob, I tried this again and it works perfectly. Thank you so much. Regards John
  16. JDRoss

    Default Value=Now(), datediff not giving resutls

    Thanks Bob & Bob None of those suggestions seem to work for me, though I now have a better understanding of what datediff is doing. The datediff function works well on other date fields I have, but not on the default value=Now() one. I am wondering if I set the default=date() rather than...
  17. JDRoss

    Default Value=Now(), datediff not giving resutls

    I have a datetimestamp field of type Date/Time in a table, which is updated with the default value, Now() from the system clock when a record is created. I want to show in query and report when a record was created or entered. I have tried the following datediff statement to show entries that...
  18. JDRoss

    Insert Into - error 3073

    Thanks vbajock This works fine for me too when I preview it in a query in design view. But when I go to run the query I still get the error 3073 the same as when I run it in the code. Insert into tblchngeCustomers Select Customers.* From Customers WHERE Customers.customersID In (2224) Could...
  19. JDRoss

    Insert Into - error 3073

    vbajock Thanks for your response. The result of Stopping the code and interrogating strsql is as below. ?strsql Insert into tblchngecustomers Select * From customers WHERE CustomersID In (2422) CustomersId is type number (long integer) Regards John
  20. JDRoss

    Insert Into - error 3073

    Dear Tek Tips I am getting error 3073 (operations must use an updateable query) when I run this code to insert into a table from another table. strsql = "Insert into tblchngecustomers Select * From customers WHERE customersID In (" & Criteria & ")" db.Execute strsql Criteria is a...

Part and Inventory Search

Back
Top