Recent content by Mike Leigh

Just some little pointers required here... Instead of typing all the erros available into each form is it possible to use an error function ? Is this the best way to trap errors ? I am asking because I have lots of On Error Goto's all over the place and it would be easier to have the common...

Hi there. Yes I have tried the way you suggest and it does work. However I want to be able to do everthing in code so I can reuse the form. I am using msgid = 100 in a global error table which can also accept user defined variables. e.g. where V1 or %1 is pull this from somewhere else. This...

Thanks Drew I will try this and let youse know how I get on

Axis - your right access does not accept %1 as avariable - however in a string it works. I have changed %1 to V1 and %2 to V2. KDg - that is exactly what I am attempting to do. I have no idea how to read a text string and look for the instance of V1 and replace with another value and then...

just a note on the previous post... If a declare %1 and %2 as variables and then set them to ABC and DEF respectively in Mike Gurmans example I would receive the correct result. However I want to have %1 and %2 in the msgtext and let vb include this alltogether for me. This way I can use the...

thanks for the reply. However it is not as simple as that - I wish it was :-) If I do what you suggest the message box simply takes it as a string (which is what it is supposed to do I think). I have also tried having the following in the field " & %1 & "message Access 97 seems to ignore...

Hi, I have a requirement to open a msgbox and display a text string when a record will be duplicated. This is all done in VBA and it all works. However I want to be able to reuse the code for other forms and the problem is this. I have a table called tbl_error_message in this there are 2...

thanks for the help... no doubt I will post some more soon :-) [This message has been edited by Mike Leigh (edited 07-22-2001).] [This message has been edited by Mike Leigh (edited 07-22-2001).]

Hi, This must be really simple to do. I am trying to run an insert into from vba while taking the values from a form. DoCmd.RunSQL "INSERT INTO company_categories (company_name_id,category_name_id) SELECT '2','3'", -1 The above code works however the text 2 and 3 I have to place manually in...

Thanks Pat... But :-) This works great for selecting a table and creating a link. Thanks. However I would like to do more than this. What I would like to do is have a table in my db. e.g. tblAttachTables which stores the following :- UID,PWD,DATABASE,TABLENAME Then have some code that when...

Hi, I am slightly stuck here... I have a DB which I install onto a client workstation. As the db only includes linked tables to a SQL Server I don't use a frontend / backend access database solution. What I am having problems with is the linked table manager. I do not want to use it. I...