Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jobo123

    Mean character in Access field name

    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...
  2. jobo123

    Fortran Export to Excel

    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...
  3. jobo123

    Fortran Export to Excel

    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
  4. jobo123

    Text field size defaults to 255

    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
  5. jobo123

    Hi I have a button that runs an

    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...
  6. jobo123

    Right Click in Runtime version?

    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
  7. jobo123

    Access Randomize statement

    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...
  8. jobo123

    how to get top listings on country specific search engines

    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...
  9. jobo123

    how to get top listings on country specific search engines

    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...
  10. jobo123

    Access Crushed

    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...
  11. jobo123

    Viewing Macro Code

    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...
  12. jobo123

    Need UK Credit Card Payment Processor

    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...
  13. jobo123

    Combo Box Right Align Drop Down List

    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...
  14. jobo123

    Build Dynamic Query SQL with Variables

    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...
  15. jobo123

    Select from where

    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...
  16. jobo123

    DATASHEET COLUMNS

    Hi, I just had a go at this and came up with a form (displaying in datasheet view) with 5 fields each of which has the following vb on the Enter() event: Private Sub Field1_Enter() Field1.ColumnWidth = 500 Field2.ColumnWidth = 500 Field3.ColumnWidth = 500 Field4.ColumnWidth = 500...
  17. jobo123

    Command button to insert a folder-need help with error msg.

    Hi, This is a bit of a fudge but you could hide a second command button under the one you already have. On the click event you could pass the focus to the second command button and hide the first. The second button could then just give a message like "Folder already created". All the...
  18. jobo123

    Relationships in Query Design View not the same as Relationship window

    Hi there, In relationships have you tried the 'Show All Relationships' button. You may find that the unwanted relationships appearing in your queries are revealed by this and can then be deleted. Hope this helps, Jobo123 www.dbLetterWriter.com
  19. jobo123

    Cross tab querry

    Hi there, My solution to this would be actually store the data in a 3 column table rather than a matrix. e.g. 1 300 2 2 300 3 3 300 4 4 300 [5] 5 300 6 6 300 7 7 300 8 1 200 3 2 200 4 3 200 5 4 200 6 5 200 7 6 200 8 7 200 9 To get the [5] out in a query result, you...
  20. jobo123

    On line help problems in Microsoft Access 97.

    We have developed a package that we wish to sell on line. We would like to provide 'upgradeable help files' on line from our web site, so that we can simply control the content, without having to ship (to users),(or they download the whole thing again). Our chosen 'technopath', new word I just...

Part and Inventory Search

Back
Top