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 derfloh 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: *

  • Users: Harpz
  • Order by date
  1. Harpz

    IT "Odd Job" Web Sites

    All, As a VB, SQL and Access developer I am interested in working on contracts for building new database systems but I dont know of any good sites on the web for information. Has any got any ideas ? Regards, Harpz
  2. Harpz

    External Database Documentor

    All, I am trying to document an external database from my database via code and then place the results in a table. The information which I am after is the external databases function names within the module collection. Has any got any ideas ? Harps
  3. Harpz

    How Do I List All Routines In A Module

    All, I am currently looking at how to list all of the functions of a module via code and then store the results in a data table. Easy yes ? The second part to this problem is that I the database which the code is running is not the database I want to analyse automatically otherwise I would use...
  4. Harpz

    check if a recordset is open

    FirstAndGoal4, Point taken when considering it may not be a viable idea to trigger errors, however, error trapping and err handling is not and never will be an overhead. All industry standard systems must have error trapping when the code is written by a developer.
  5. Harpz

    open dialog with file selection ODBC Databases

    No real difference, they are basically just tools from which you can pull back a string value.
  6. Harpz

    File Sharing Lock Error Message,

    SteveCarey, I think your records are locked mate !
  7. Harpz

    check if a recordset is open

    You can also use the recordcount, if a value is returned then your set is open, if an error occurs then it is closed. There are four ways.
  8. Harpz

    Sending Report to Email

    CityLimit, Yes this is possible, I have replicated a system like this before. It depends alot on which type of email software you are using. Obviously, access is alot more helpful when using Outlook as opposed to Lotus Notes, but still possible with thanks to an add-in library file(cant...
  9. Harpz

    DriveListBox Control

    annsolomon, It is possible, however it takes alot of code as you have to use the list box control which is found on the tools bar under additional tools. You can also use the treeview control to replicate the windows explorer navigation.
  10. Harpz

    Parameters with DoCmd.OpenStoredProcedure

    Sid, Try using global variables for assigning variables to the @Get_Id.
  11. Harpz

    Benefits of Access 2000 over 97

    Herb, I agree that Access 2000 is far more superior than '97, but when we are talking about industrial strength application's, VB is far more superior than Access ! Harpz
  12. Harpz

    Format table

    Kate, The reason this is happening is due to the fact that the fields value is actually 0001 and not 90001. You have got to remember that the 9 is only a formatting prefix. Try this - in the field name type in FieldName : "9" & [FieldValue] This syntax will prefix all of...
  13. Harpz

    Making the current value in a field to be a value in the next

    Try storing the value in a string value within the form or as a global array. This will then mean that you when the user goes to the next record, you can append the stored value into the field. Harpz
  14. Harpz

    Format table

    Kate, If you are trying it in a query and want a 9 to appear before all numbers then place \90000 in the fields format field. We'll get it sorted mate ! Harpz
  15. Harpz

    Benefits of Access 2000 over 97

    Ed, I agree that Access is a much better RAD tool than Oracle or SQL Server. But as a data store, they both beat Access hands down when considering performance and data magnitude capabilities. Harpz
  16. Harpz

    Benefits of Access 2000 over 97

    Ed, I agree that Access is a much better RAD tool then Oracle or SQL Server. But as a data store, they both beat Access hands down when considering performance and data magnitude capabilities. Harpz
  17. Harpz

    Benefits of Access 2000 over 97

    Ed, This will probaly start off a new thread but 'SQL Server' and so is 'Oracle 8i' is pretty good at that sort of thing ! Harpz
  18. Harpz

    File size bloats when importing text files

    When you compact a system, Access takes a copy of the current database and then compacts that one. Once the copy has been completed the compaction, then the copy becomes the live version and the old version is deleed. So, when compacting, there will only be a duplicate of data on the network for...
  19. Harpz

    Benefits of Access 2000 over 97

    Lachlan, In answer to your question, 2000 can handle a hell of a lot more data than '97. So as far as a data store goes and performance, its alot better(but not the best) ! Harpz
  20. Harpz

    Event between 2 forms

    Justin, You will not be able to execute the code behind the button on the second form. However, just place the code behind the second form on the OPEN event. Then, when you run the code which opens the second form, the B1 routine will execute automatically. Harpz

Part and Inventory Search

Back
Top