Search results

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

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

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