Search results for query: *

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

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

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

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

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

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