Recent content by Harpz

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

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

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

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.

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

SteveCarey, I think your records are locked mate !

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.

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

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.

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

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

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

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

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

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