Recent content by jobo123

Hi, I am trying to insert a mean character in a field name e.g. x¯ Alkalinity mgl-1. The character should look like: x¯ but with the bar over the x rather than after it. I have searched MS Word fonts thoroughly - not found. I have also created the symbol in Word's equation editor (worked...

The problem is that for a better user experience, we want to export data and have it open directly in Excel with no csv step (or at least a completely hidden csv step) so that the user just sees Excel open with the appropriate file. Many thanks for your thoughts, John Davy-Bowker...

Hi, We are trying to find out if it is possible to export data in variables in a Fortran Program to an Excel Spreadsheet. Any thoughts welcome including comments that this is not possible. Many thanks, jobo123 John Davy-Bowker www.dbLetterWriter.com

Hi TSR, In Access 2000, if you go to tools, options, and then the tables/queries tab, there are default field size settings for text and number fields that you can adjust. All the best, jobo123 John Davy-Bowker www.dbLetterWriter.com

Hi Karl, I think you just need to add a couple of lines to turn the Echo Off and then On again around your action query, e.g. DoCmd.SetWarnings False DoCmd.Echo False, "" DoCmd.OpenQuery "Query1", acNormal, acEdit DoCmd.Echo True, "" DoCmd.SetWarnings True This...

Hi Leo, I have runtime in Access97 with table view. I give a toolbar with A-z and z-A buttons to get round this. Not sure if there is any other way. Hope this helps John Davy-Bowker www.dbLetterWriter.com

Hi docmeize, Yes I have used the Randomize statement in Access97 with good results. Randomize seems to get round the problem of the same number being generated on each first run of the rnd() function. Not sure how it works. but it really does seem to randomize. All the best, John Davy-Bowker...

Hi Neil, Yes, I don't think a whole raft of separate sites and domains is really a very good solution. You might get some benefit from local search engines that specialise in country specific domains but generally I would think that a single site that is carefully optimised for your target...

Hi, I would have thought that to target so specifically to these three countries, you might need three country specific url's. Just by looking on Google I quickly found a Latvian search engine: http://search.latnet.lv/ All the sites it lists seem to end in .lv so if you really only want to do...

Hi there, There certainly are version conflict issues. The best single web page I know of that discusses these is: http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q241/1/41.ASP&NoWebContent=1 I try to keep Access 97 and Access 2000 on...

Hi Jerome, If you have some macros already created you can view the vb easily by highlighting the macro in the database window and clicking Tools, Macro, Convert Macros to Visual Basic. This will create a visual basic module containing the corresponding code for the macro. Hope this helps...

Hi Paul, We are UK based and use PROTX. They have a product comparison page on their web site that we found very handy for comparing the various (ever changing) offers: http://www.protx.com/products/pricingvsp.asp#pricingcalc I would say however, that PROTX have recently changed their costing...

Hi, Does anyone know if it is possible to make the drop down list of a combo box anchor itself at the right edge of the combo box instead of the left edge? Here is the problem - I have a database with a combo box near the right hand edge of a form. The combo has 9 columns. When the list is...

Hello Jim, By the time I had figured this out you had already had some good responses but here it is anyway. I made a table with fields as you suggested: UserID User 2003_Days 2004_Days 1 Jo 22 36 2 Bob 29 31 3 Tim 88...

Hi RZFF, I built your tables and added the data. I made the following query (where I named your first table 'Table', and the second table 'convertaccount' as you indicated). In the SQL below, Table_1, Table_2 and Table_3 are not new tables, just the original table, linked 3 times in the same...