Hello,
Wondered if you could help me with a little issue I'm having. I'm exporting some data from Access to Excel and converting into some fancy graphs. The number of series' ranges from 2 to 5. Below isa copy of the code I am using to format the graph in terms of series names, layout, colours of lines, etc. When the full 5 series are there to be charted there is no problem with the code, however, when I try to convert less the...
JonathanParker
Last Activity: Jul 19 '06, 07:16 AM
Joined: Jul 11 '06
Location:
-
Excel Vba Help Required
-
Date Lookup in VB
Another quick one!
Trying to search for records by both accounting period and by year in two seperate queries actioned by option buttons. I've sorted the formatting so it's in a UK format but I keep getting the same error
'(3122) you tried to execute a query that does not include the specific expression 'tblAccounting. Period=0406 And tblProduction.D epartmentID=1 ?And tblUtility.Util ityID=1' as part of an aggregate function.'... -
You'll have to excuse me, I'm new to all this programming stuff, I've manged to go from having no knowledge at all 4 weeks ago to writing that stuff I posted. I'm getting the hang of it but the basics keep tripping me up, need some good programming etiquette!! Thanks for the help here, really appreciated!!Leave a comment:
-
Thanks for that, all those tables are in the database and they are all in the SQL too. when the error message comes up it's not for a ", it's for ' ' with no space between them. I've been through the code a number of times now and the only way I can make it work is by doing the following:
outputpath = "d:\mpl\Utiliti es\Database(2)\ Database\Depart ment\charts.xls "
Sheet = "Results"
DoCmd.TransferS preadsheet...Leave a comment:
-
Urgent VB SQL help!!!
Looking for some help urgently with some VB SQL Access stuff. You'll have to excuse the messiness of the code, I'm a newbie at all this. I'm running this code with a selection of check boxes to select extra fields for my table that is then exported to Excel. there are 3 fields that are always part of the SQL, when these are selected it works fine, however when I select any of the optional fields I get a Runtime Error '3011' saying:
...
No activity results to display
Leave a comment: