Search results

  1. R

    Set Textbox 'Control Source' to be a Query?

    Hi, Is it possible to set the 'Control Source' of a text field box to be a query? The text box is unbound (ie. not a physical field in the database tables). I've already got the query and it works fine when I execute the query by itself. But when I assign the query to the 'Control Source', I...
  2. R

    MS Word Form Letters - Mail Merge Data Source

    Hi, I'm currently setting up some form letters as mail merge documents which will link up with the Access database. I would like to know is there anyway to change the data source address of a mail merge document to be a 'relative' address and not an absolute address? Or does Microsoft Word only...
  3. R

    Multi User Access Problems!

    Hi, I have a problem with multiple users accessing the same MS Access 2000 database at the same time. The database is stored a directory under windows XP Professional which is set as a ‘shared folder’ enabling other users to edit the files. The database is stored on the server machine within a...
  4. R

    OLE Objects in a form

    Hi, I'm new to VB, and I'm trying to add a bit of VB code to automatically insert a OLE object into a form (via a button). However, when I try to compile the code, I get a error message "compile error: can't find project or library" and it highlights the 'OLE1' object. As I've never used OLE...
  5. R

    Reading data from Excel & inserting as records directly into Access?

    Hi, I'm helping a friend build an access database and have a problem. I currently have a list of hyperlinks contained within an excel file. At the moment, I have to insert each hyperlink one by one via a RunSQL statement using a macro. This method works but will be rather troublesome for my...
  6. R

    Reading data from Excel & inserting as records directly into Access?

    Hi, I'm helping a friend build an access database and have a problem. I currently have a list of hyperlinks contained within an excel file. At the moment, I have to insert each hyperlink one by one via a RunSQL statement using a macro. This method works but will be rather troublesome for my...
  7. R

    OLE Objects - Which OLE reference library do I need?

    Hi, I'm familar with Access but new to VB, and I'm trying to add a bit of VB code to automatically insert a OLE object into a form (via a button). However, when I try to compile the code, I get a error message "compile error: can't find project or library" and it highlights the 'OLE1' object...
  8. R

    Reading & inserting records directly from Excel into Access?

    Hi, I'm helping a friend build an access database and have a problem. I currently have a list of hyperlinks contained within an excel file. At the moment, I have to insert each hyperlink one by one via a RunSQL statement using a macro. This method works but will be rather troublesome for my...
  9. R

    Inserting records directly from Excel into Access?

    Hi, I'm helping a friend build an access database and have a problem. I currently have a list of hyperlinks contained within an excel file. At the moment, I have to insert each hyperlink one by one via a RunSQL statement using a macro. This method works but will be rather troublesome for my...
Back
Top Bottom