Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Grieg
  • Content: Threads
  • Order by date
  1. Grieg

    Opening database gives error

    Hi, I have a database which is split to give two files (a front end file with the forms / code and a back end file with the tables). I have copied these files from one server to another and re-linked the tables, however now whenever I open the database I get a message stating that Access...
  2. Grieg

    Disabling close box buttons in Word

    Hi, I have an automated Word letter template where the user has to use a custom icon\menu item to save and close the document (so that code behind the template can carry out various checks on the content and decide where the document is to be saved to). What I need to know is, is there anyway...
  3. Grieg

    Loading bookmarked text from a word doc to vba

    Hi, I have a word template where I want the code behind it to import a section of bookmarked text from another word document and load it into a string\form property. I can't use the open the document as a text stream as its a word doc - could anyone point me in the right direction. Any help...
  4. Grieg

    Editing data in a form based on a recordset

    Hi, I have a form on an Access 2000 database which displays a record from a table and on the form the controls (combo\text boxes) are locked to prevent the data being changed. When a button is pressed the controls are unlocked and the following code is used to take a copy of the record, load it...
  5. Grieg

    How to connect excel to an access database

    HI, I'm fairly new to excel and looking for some help. I have a spreadsheet where I need to send data captured via a dialog box to a table in an Access database. How can I connect to the database and append the data to the relevant table. I've been trying the code suggested in the excel...
  6. Grieg

    Procedure declaration error

    I have various bits of code attached to buttons/labels as events however when these buttons/labels are clicked I get the following error message; "The expression *(event name)* you entered as the event property setting produced the following error: Procedure declaration does not match...
  7. Grieg

    Select data from list box

    I have a form with a combo box (cmbUser) and two text boxes (txtUser & txtBranch). The combo box has 2 columns. When an item is highlighted in the combo box and the user clicks a select button I need to set txtUser to the data in column 1 and set txtBranch to the data in column 2. The data from...
  8. Grieg

    requerying subform gives 'object invalid' error

    Good afternoon, I'm hoping someone can see where I'm going wrong! I have a form where you can enter criteria into text boxes to search for clients records. The details of the clients records then appear in a subform (subClientSearch) on the form. The subform data is provided from a simple SQL...
  9. Grieg

    Set a field on a form based on value from another form

    Hi, I have 2 forms ('client' & 'review'). Both forms are based on seperate tables however both have a field 'policy' which links the two. When I click on a button ('addreview') on the client form I need this to open a new record on the review form. I also need the field 'policy' to be set to...
  10. Grieg

    Opening form based on combo box in other form

    Hi, I have a form (select_client) where I have a combo box (clients) showing certain fields from a table. When a record has been selected from the combo box and the user clicks on an item (select) I want another form to open up showing all the fields from this record. The code I am using is...

Part and Inventory Search

Back
Top