Replies

Hans
Stupid of me that I didnt check.(not my database by the way)
I think I’m there now – thnks to John and yourself for your help
Steve

Following on from help by Hans and John, I attach a cut down version of the database.
Two major tables: STKB which holds data relating to Stock and DAVEID which holds the list of GROUPS.
The ChooseGroupsForm is designed to allow you to choose one, several or All Groups. This process is working fine (after much confusion on my part !!). However I want to apply the results of this query to the query qryProductProfitabilitySearch and have no idea how to do this.
Any help appreciated
TIA
Steve

Sorry Hans – totally lost -put the criteria where
Steve

Thank you very much – looks like a corrupted normal.dot and seems OK now
Much appreciated
Steve

Thank you yet again for your incredible depth of knowledge – how are you with fixing ride on mowers.
Some would say I have enough trouble with English – especially the Australian version but you’re right, its good fun writing databases where you have to count down the menus because you know add a new query is the third item on the list – at least I have an excuse for being slow now
Thanks again
Steve
PS I assume I cannot add the MUI to an exisiting Chinese language server but have to install in English then add the MUI

Hans thanks for the quick response
As you probably know by now I do not know VB but let me tell you what I did so you may be able to point out the error of my ways.
By background, my current process is that I have a series of Make Table queries that are run by calling the queries up sequentially in a macro linked to a button on my Switchboard. No VB is used.
I tried to do what you suggested but got an error:
First I went into VB and created the following
Option Compare Database

Dim strSQL As String
strSQL = “UPDATE tblUpdate SET dtmUpdate=Now()”
CurrentDb.Execute strSQL
Me.Recalc

This appeared to be saved as Module 2

I then created the text box on the switchboard with control source
=DLookUp(“dtmUpdated”,”tblUpdated”)

When I click on the text box on the Switchboard I get

Compile error
Invalid outside procedure with the words
“UPDATE tblUpdate SET dtmUpdate = Now()”
highlighted

Help
Steve

Perfect – thanks John
Steve

More impressive than I wanted actually – well done.
I can do the calculations OK with a query but it is the presentation of the results that I am having trouble with. I envisage an Excel like Table with 3 columns and maybe 20 rows.
The columns would be Amount, Local Currency and Foreign Currency.
The rows would be preselected amounts (I dont expect this to cover all conversions (which yours does admirably) but be more of a simple ready reckoner until the user gets used to the local currency. Thus it would have a row for 1, a row for 10, 20,30,40,50,60,70,80,90,100,150,500,1000,10000 and 100000. You would look along the 10 row for example and see that 10 Local currency is .2345 A$. the same row would show that 10A$ is 67.89 local currency (ignore the accuracy of the numbers, its just an example
Hope attachment a) works and makes it clearer
Steve

Perfect – Thank you
Steve

Some clarification:
1 I can use a program called Web Mail to read my emails direct from IExplorer on any machine connected to the internet, effectively reading directly from my ISPs mail server. It shows 10 emails, all of which can be read. Some would probably be classified as Spam but I have had my ISP turn off spam assasin to ensure they all get to my inbox and the missing emails are not all spam. I have also set Outlook so it leaves a copy on the server for 10 days
2 Outlook using POP3 on an XP desktop machine says receiving x of 10 emails but does not receive them all. I cannot discern a pattern to what it decides to receive. It then tells me send/receive is complete but I may have only received 6 of the 10 emails. Note I just did a test of one it consistently did not receive. Using Web Mail, I forwarded it to myself and this was received on both the XP and SBS machine
3 Outlook on a Small Business server (still using POP3 , not Exchange) receives all email. All settings in Outlook same on both the XP and SBS machine, all antivirus and spam settings the same also
Steve

Happy new year Hans
No the antivirus is not configured that way and when I have been able to get the mail, by directly downloading from the server, no virii were found
No, the spam filters have been removed from both machines, just in case that was the problem.
Do I need to reinstall Outlook and if so is there a link you know of to the most effective way of doing this

Certainly sounds flasher than the MYOB tech told me couple of months back

Thanks for the response
re MYOB – yes this is the program. I have the read only ODBC and in talking to MYOB, the read -write is not terribly flash as all it does is create a text file that can then be manually imported. Not practical or necessary for what I am trying to do which is primarily after the fact reporting
Steve

Wendell,
Your suggestion re Unicode worked. Thank you very much – what does that tell me eg if I then produce reports using differnt fonts, will I screw it up again

BTW this gets wierder (or is that more wierderest). Exactly the same MakeTable query run using the same ODBC on the same Accounting File but in XP rather than SBS2003 works fine

The accounting package is called MYOB, used to be reasonably popular in the States (I am in Australia) but the American version was sold to Quicken a couple of years ago and I think it is no longer available there. One of the main reasons for buying this particular package was the ODBC link as the clients business is too complex for most other reasonably priced accounting packages (eg Quick Books) to handle. I have managed to design workarounds in conjunction with the ODBC and Access to handle complex consignment stock/foreign currency issues and overcome reporting limitations in the base package

I would be really interested in speeding up the ODBC as I could then be using “live” data so appreciate any suggestions. The make table process was a dumb Accountants (me) way of overcoming the speed limitations and, while it requires some time investment when updating the file, I do actually get a fairly useable result
TIA
Steve

Thanks for the advice – The fonts are not changed (by me) in any way.
I ran your suggested query and got an Ascii code of 63.
BTW this gets wierder. Exactly the same MakeTable query run using the same ODBC on the same Accounting File but in XP rather than SBS2003 works fine
Thanks again
Steve