Search results

And here is the strsql line SELECT QRYCOMPARISON1.DAY, QRYCOMPARISON2.PERIOD2 FROM QRYCOMPARISON1, QRYCOMPARISON2 WHERE QRYCOMPARISON1.DAY = QRYCOMPARISON2.DAY

The problem line is this rstcount.Open strsql Well i am thinking it is this based on the following code and the fact i get a an error saying RECORDSET ERROR1 and this is the only line of code that is running before my other error codes come into play. Function CreateRecordset(rstdata As...

Leigh, what I dont get is how come it works perfectly everytime I run it on my computer but when I test it on a clients I have problems, I have now tested it with the SET command put it in and now what happens if i try one period to graph on it works but displays data from days before my start...

Wayne to be honest grabbed the code out of a text book I have been reading still learning most of this stuff so just followed the example and then edited it. Any better ideas would be appreciated.

Wayne I have narrowed it down to Function CreateRecordset(rstdata As ADODB.Recordset, _ rstcount As ADODB.Recordset, _ strsql As String) Dim rst As ADODB.Recordset ' On Error GoTo CreateRecordset_Err 'Create recordset that contains count of records in query...

ok guys I have figured that out :) only problem is when i install the packaged software on a client's pc i am getting the following error error -2147467259: odbc--call failed i know it is in the following code due to my error messages but I can't figure out what would be getting this error...

Hey every1 sorry bout this but cant seem to figure out how to do this atm. I have the below code referenced to Excel 12.0 reference and as different customer have different version of Excel I think it would be a good idea to change to latebinding. Does any1 know any easy way of changing my...

Hey john thanks for ur advice i will look at that but i have tested my code and the exporting to excel is the fast part like 5 secs tops the query parts can take up to 5 minutes which is my problem

also the excel part isnt the problem that is working fine and quickly the problem occurs speed wise running the 2nd query to combine all the totals.

John the reason I didnt do it in access is i just dont think it looks as good. But if you can show me how to make it look more presentable that would work

Ok I have a form "frmCOMPARISON" that allows the user to enter various options to report on sales for a date range this is then stored in a seperate query for each period that is set. After this I then run a query to combine all periods into 1 query so i can export to an excel spreadsheet and a...

Stupid DBA :( Nermind guys found the problem. Note to self or others. It is a pain in the ar$e working on a database someone else developed and you arent allowed to modify :(

I have written the below code which access a query to obtain a list of email address and a certain store for those email addresses as the criteria for my report then automatically emails this report to those users. When I run this on my computer everything works perfectly but i have since...

nevermind nevermind guys seems like it was keeping some sort of lock on the file so when i then set the form to close after each option chosen all was fine :)

Hey guys i have the following code where depending on an option i choose off a form exports a report to various options. All works ok until i try to use option 4 first then repeat using option 3 at which point i geta runtime 2501 error So any ideas why would be great. Select Case rpttype...

i have a report that i need to say if a queryexists (qrySUB) then match the values in this "ISDP_DESC" to "ISDP_DESC" in the report query. I am just not sure how to go through this queries records to add to my report criteria. Any help would be appreciated. Jason

Pat i did try that but using the date as a date variable unformatted but it still causes the same problems with month vs day and my windows default is set to dd/mm/yyyy Thanks for your help and time and patience on this but i think i might just have to stay with the current solution atm :(

Thanks pat i think i am starting to get how dates work in access the problem is the database i am accessing for reports is an interbase database and i think what is happening is when i get the user entering the date as dd/mm/yyyy and the interbase db is storing its dates as mm/dd/yyyy it doesnt...

pat thanks but i tried that and it isnt formmating it into mm/dd/yyyy which is how the database i am accessing is stored in mm/dd/yyyy format whereas most users are used to dd/mm/yyyy format so thanks for the info but do u know how i can still send my date fields to the database in the right...

thanks again bob it was for obtaining a subject header for an email :) pity i cant add more reputation to ur name till i add to other lol