Search results

Hey guys I am trying to test something in relation to a thread in a previous section and just wondering is there a way of upgrading the version of odbc on a windows xp machine?

I dont know if this helps but i ran a trace with odbc on the query and these are the lines that get the error message. x macroSTARTUP 8c04-8c4c ENTER SQLExecDirectW HSTMT 07CE3528 WCHAR * 0x0E2F2790 [ -3] "SELECT "HTRXTBL"."HTRX_TRX_DATE" FROM...

Gemma thanks for looking at it but i figured it out in the end:) just changed the join type on a query of mine thanks again

Gemma, totally agree with you. However I am working with a db that my company didnt develop (Just trying to write reports from it) it was developed in firebird and trust me when I say that dba isnt going to rework the database :( Unfortunatley he only stores a total balance which isnt really...

Hey guys I have the following problem hope some1 can help I am trying to write an account statement. I am ok with everything except one thing, I need a field called “OUTSTANDING BALANCE” which is a value of the balance remaning from a previous amount “Balance BForward” (I am fine on this part)...

George, thanks all working must have had a typo in there somewhere

georgedwilkinson I get a circular reference error and how do i check wether the label is bound or unbound?

Ok now I am sure this is pretty easy as I have done it with records off forms but for some reason when i try and combine some custom text with a record from a query I get an error ="ABN" & [STORE_ABN] that is the line i am typing in the label but with no luck any help would be appreciated.

Did you ever find the solution to this as I am having the exact same issue? Some computers works fine others have this error

never mind sorry bout that one guys all sorted :) thank you so much for your help and patience

attached is a copy of the report as is currently

Paul thanks for that but now for some reason instead of totalling that field it is returning the account balance field (ACMF_CURR_BALANCE) even though it is saying its summing the right field :(

btw this is the error msg i am getting

Alisa spot on thanks for that :) :) one last one I am now trying to dynamically change my group totals option Private Sub Report_Open(Cancel As Integer) Dim i As Integer Dim j As Integer Set db = CurrentDb Set qdf = db.QueryDefs("crstabACCTRX")...

Paul thanks I am now past that error but I am getting the following Runtime error 3265 Item not found in this collection on the following code If qdf.Fields(i).Name Like _ "ACCOUNT" Or "STORE" Or "AREA" _ Or "TILL" Or "SYSC_COMPANY" Or "TRX_DATE" Or _...

Ok guys i have had a look online and cant seem to figure out what is wrong with this. On opening my cross tab report I get this error Too Few parameters. Expected 0. Attached is my sql for that query and the code on the report HELP please :) PARAMETERS [Forms]![frmACCTRX]![txtDATEFROM]...

ok and now to top it off i have tried it on a second customers site. working fine the only difference is the first site is windows 2003 server the second is xp pro

Wayne, yeah so I dont get what is wrong Grrrrr geez I hate when something works in one place and not somewhere else.

Thanks Wayne but pc is in Australia settings which includes dd/mm/yy the one thing that i am thinking is that I know firebird stores dates as mm/dd/yyyy but i can see how it would be working here and not on the customers :(

Ok the code is now as follows Function CreateRecordset(rstdata As ADODB.Recordset, _ rstcount As ADODB.Recordset, _ strsql As String) As Boolean Dim rst As ADODB.Recordset Dim count As Integer On Error GoTo CreateRecordset_Err1 'Create recordset that contains count of...