Zwoker
Last Activity: Jul 30 '08, 03:59 AM
Joined: Jul 1 '07
Location: Melbourne, Australia
-
For this one particular issue, that of doing code-selective totalling based on fields in the the detail section, I think it would be very hard to be sure you can get it correct 100% of the time. I actually tried putting some "undo" code in the Retreat event and found that wasn't as reliable as the help made it sound. Perhaps its just an Access 2003 issue and is fixed in later versions, or perhaps I just can't think of a way to code a solution... -
Hi,
A quick question on this:
Which version of Oracle are you using, and do you have the latest ODBC drivers for it?
I found something similar happened to me a while ago, and upgrading to the latest ODBC drivers from Oracle for my version fixed it.
Regards,
Zwoker.Leave a comment:
-
Greetings,
A slightly belated and related follow up on this topic.
I had thought that I was all done writing reports in MS Access, but last week I was asked to do just one more... After producing a prototype I received the now expected "can you just make this one little change to the way it does its totalling".
What they asked for had me jumping into the VBA code in the report, and doing selective...Leave a comment:
-
Hi,
If you use a "connection string" approach to get to your SQL data, rather than static linked tables, then you can give it a usercode and password once, and not have it prompt you again.
The downside to this is that you probably need to rewrite some of your solution to use a connection object rather than a named table.
Or, if you are wanting to keep the static query approach then you can dynamically...Leave a comment:
-
Landscape and Portrait in the same report?
Hi all,
In MS Access 2003 I'm trying to produce a report that has the some sections (the header section for the first sort item) in Landscape, and the rest in Portrait.
I tried using code like Me.Printer.Orie ntation = "n" (where n is 2 for portrait and 1 for landscape), but found that it seems whatever the last "format change" code executed by the report is what I get for the whole report, not just... -
Hi,
As a general background FYI on the last comment - my reports run in two modes.
1) Just extract data for the users own location.
In this situation, all the currency data read from the backend database is in the users own units, but was (until yesterday) showing with a leading dollar symbol on all the printed reports, regardless of the users true currency symbol.
In this situation no conversion...Leave a comment:
-
Thanks ADezii,
That works great. I had already manually typed in the manual format code for all the currency fields for one of my smaller reports, and it worked fine.
I just tried your code in one of the larger reports after multi-selecting all the currency fields and giving them the tag, all in one big go, and it all worked just the same, but with a lot less effort.
I'll be able to convert all my reports...Leave a comment:
-
Hi,
It sounds like you have everything in place already to do what you want.
If you have set up the tables from your SQL repository as external linked tables in MS Access, then you should be able to open them directly in VBA code as if they are local tables.
Alternatively you can reference them in SQL code as if they are local tables. You seem to have the basics covered already in your example SQL code...Leave a comment:
-
Thanks Lysander.
I had googled for an answer but not found anything meaningful.
That link explains my problem exactly. I'll try the suggested work around and see how it goes.
Regards,
Zwoker.Leave a comment:
-
Hi,
If you wanted to code something using VBA in MS Access that connected to the Teradata database, via ODBC, and retreived whatever data you wanted, then that should be reasonably simple.
If you want to try this then let me know and I can give you an example of a connection string and code that should work, assuming you already have the ODBC stuff setup for your Teradata database on your PC.
Regards,...Leave a comment:
-
The LogFile declaration will work as coded above, it just always bothered me that I couldn't discover what type it should actually be.
I'm glad this is what you were looking for. I wondered if you needed something a bit more sophisticated.
Regards,
Zwoker....Leave a comment:
-
Hi,
It may be a little simplistic, but rather than trying to use any sort of MS Access report, you could just write the status of each activity that your program performs to a text file. You could use code something like the following:
...Code:Dim fs As Object Dim LogFile Set fs = CreateObject("Scripting.FileSystemObject") Set LogFile = fs.CreateTextFile("ResultsLog.txt", True)Leave a comment:
-
It is the Currency format, chosen from the pick list that appears when you click on the end of the format field in the textbox properties. I haven't defined my own format or anything.
Is there some sort of environment-override that I have accidently turned on that would force the "$" to always be displayed instead on the users PC regional settings currency symbol?
Thanks....Leave a comment:
-
Currency Symbols on MS Access Reports
Hello everyone,
I have an MS Access 2003 application that is distributed as an MDE.
All the users around the Asia/Pacific region that use it are running Windows XP.
Many of them have different currency symbols in use, and these are declared on their regional settings in the control panel on their PCs. But despite this all the currency fields on the reports are appearing with a leading dollar symbol - which... -
Hi,
Are you asking how you can use your Form based selected department in your query criteria automatically?
If so, if you add the following to the criteria field in your query, it should work:
Forms!<FormName >!<ControlNam e>
E.g. Forms!MyForm!Se lectDept
If you have spaces in the name in your form or control then you would need to use square brackets, like:
[Forms]![My Form]![Select...Leave a comment:
-
Hi Stewart,
Perhaps I was a bit unclear...
My break points are triggered Ok when the report runs initially - its just when it has displayed the "good" result in the print preview window, and I click the Print button in MS Access, that it doesn't trigger any break points when it creates the "bad" physical printout.
Are you finding that you do get the code breaking in both situations?...Leave a comment:
-
Hi Stewart,
Thanks for the response.
My selective accumulation code in those events is already in a condition of PrintCount=1 and I have set up initialisation for my accumulated values. Both at the beginning and end of the processing – in case MS Access doesn't initialise when you click the print button.
If the initial Print Preview result was wrong I'd be looking for a simple coding error. But it is...Leave a comment:
-
Access Report - Weird Result
Greetings everyone,
I have a report in MS Access 2003 that looks fine in print preview mode. When I click the print button the data on the printed output, in the first footer changes. Some of the values have the same last few digits as the preview but different preceding digits, some are completely different.
I know this is probably hard to answer without seeing the result and the report code (which does some selective... -
Thanks FishVal. That works great!
And removing the scroll bars was good too - it looks nasty with them present.
I also like the Tiger animation, even if it does have a sad ending. :(
Zwoker.Leave a comment:
-
Thanks ADezii, but I really need an option that doesn't require any sort of installation of any "extra" things like the DLL. The environment that the final MDE will run in is very tightly controlled - putting things in the windows directories is not allowed.
Do you have any other options?
Thanks,
Zwoker....Leave a comment:
No activity results to display
Leave a comment: