Search results

  1. C

    custom deletes

    hi, im trying to build a more user friendly interface for the deleting of records. I would like to be able to pass a string value (gsecond) based on a persons surname from a form to a global module. The module would carry out the delete and give a user friendly message. The code is working...
  2. C

    Option box grow

    Hi, I have an option box that only displays some records if a certain radio button is clicked. What i would like to do is have the option box grow if that particular selection is chosen. I guess its something along the line of Private Sub optChoice_AfterUpdate() Me!optChoice.Height -3.4 =...
  3. C

    Report preview on a form

    Hi, just a thought i have just come up with, is is possible to have a print preview of a report on a form? I was just wondering if it was possible to have record information on one side of the from and then a screen shot/ scaled down view of a report on the other. Would it involve the bound...
  4. C

    Mouse move error handling

    unfortunatly error resume causes it to loop back to the beginning and restart when you move the mouse again!!! any ideas
  5. C

    Mouse move error handling

    Hi, i have inherited a database to do some development on. the previous developer had written some code in to it that works when the mouse moves over the detail or particular buttons, an example is below. Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As...
  6. C

    Insert string to table with sql statement

    yeah that recordset method works, cheers for your help
  7. C

    Insert string to table with sql statement

    With regards to the sql method i have written this sql = "INSERT INTO Error_handling_table (Error_Number,Error_Description,Error_Location ) VALUES (lngErrNum, '" & strErrDesc & "', '" & strWhereFrom & "') " DoCmd.RunSQL (sql) The code compiles fine, it brings up a syntax error...
  8. C

    Insert string to table with sql statement

    Now trying both sql and record set methods placing quotes around error table has corrected that error but i now have one on the .add the error states "method or data memeber not found"
  9. C

    Insert string to table with sql statement

    i have entered the code you have suggested and it brings up an error on this line Set rsttmp = CurrentDb.OpenRecordset([Error_handling_table], dbOpenTable) The error says external name not defined? How can i get around this?
  10. C

    Insert string to table with sql statement

    Hi, im building myself a error handler and part of it is to record the error details in a logging table. I have a function that flags up error number, description and location in a message box. How do i take these strings and long ints and record them into a table. Below is a snippet of code ive...
  11. C

    Insert string to table with sql statement

    Hi, im building myself a error handler and part of it is to record the error details in a logging table. I have a function that flags up error number, description and location in a message box. How do i take these strings and long ints and record them into a table. Below is a snippet of code ive...
View older results
Back
Top Bottom