Search results for 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

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

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

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

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

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

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

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

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

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

Thanks Zameer Great article! John

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

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

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

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

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

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

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

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

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