Recent content by chrisbrookeanna

  1. C

    Extracting a sub string from a main string

    I have a field with data type string such as "[25] Example" I just want to extract any number that appears within the [] brackets. Any Ideas?
  2. C

    Importing OLE objects from excel

    Hi, I have a spreadsheet that contains VISIO OLE Objects. However, when you embed them into excel they do not reside within a cell - is this correct? Is there anyway of embedding OLE objects within a cell such that access can 'see it' and allow it to be transferred into an access table...
  3. C

    Getting windows login details (Windows 2000)

    Thank you very much indeed.
  4. C

    Getting windows login details (Windows 2000)

    Hi, When the database is loaded up I want to capture and store the Windows 2000 logon details. Is there a way this can be done? Thanks.
  5. C

    Trapping the cancel of OutputTo

    That works a treat, thanks alot!
  6. C

    Trapping the cancel of OutputTo

    Im using the OutputTo function to generate a file, which works OK. However, if the user quits cancel in the file dialog box you get an error saying the OutputTo action was cancelled. How do you trap this error, so no error box is displayed. Thanks.
  7. C

    The quickest way of determining if a field is null

    Hi, Im using DLOOKUP to determine whether a field is null. Is there a quicker way in VB? I cant just use SQL because I need to identify the name of the null field to show to the user. Thanks.
  8. C

    Finding the missing values

    Hi, When you do a join it pulls in information where the linked data item is the same...right...how do you display the data where it does not match??
  9. C

    Programatically changing the table that DLOOKUP Uses

    It alright, sussed it. Thought i'd already tried that...Doh!
  10. C

    Programatically changing the table that DLOOKUP Uses

    Hi, In the DLOOKUP function you specify the table name as a string. How can substitute this string for a variable, that I can set programatically to search different tables. Also for the field names? Thanks.
  11. C

    Passing the form reference to an undo function

    Me.Undo Hi Rich, When I change data it loads another form to sanction the change with a change number, you can either hit ok or cancel on this new form. Upon hitting cancel I tried Forms![Name of form].undo I cant use me, because im not currently on the form to change back to original data.
  12. C

    Passing the form reference to an undo function

    Thanks Rich Me.Undo wont work for some reason, do you know how to correct my original coding?
  13. C

    Passing the form reference to an undo function

    Hi Ive got this code:- Function Old_values(Object As Form) Dim ctlTextbox As Control For Each ctlTextbox In Object.Controls If ctlTextbox.ControlType = acTextBox Then ctlTextbox.Value = ctlTextbox.OldValue End If Next ctlTextbox End Function I want to pass into it...
  14. C

    Accessing a variables in two or more forms

    How do you declare a variable so that it can be seen by all the modules in each form? Thanks.
See more
Back
Top Bottom