Search results

  1. C

    Common Dialog problems

    Hi all, I'm using a common dialog to store the path of a document store on a local drive but after a week or so of blissfully easy browsing and hyperlinking it screwed up and I can't see why...any suggestions, this is what happens; 1) The common dialog suddenly started failing. Saying that the...
  2. C

    Call functions

    Dear all, I've created a button on all my forms that will update all the controls, subforms and list boxes on a form. What I'd like to do is call that function from outside the form, ie I need to update one form when something is changed on an unrelated form. I've made the button a "public sub"...
  3. C

    Funny errors

    Dear All, I wonder if you can help me. On one of my forms I get an intermittent error message telling me that a value I have entered is of the wrong type. I've checked all the values in the underlying tables and as far as I can tell everything is ok, its mostly text/memo fields anyway. The...
  4. C

    Left joins and is nulls

    Dear Fellow Accessers, Hi, I'm making a database to store the sales data from our sales departments. I have a very large table with all the staff past and present and a query that shows me which of these staff are actually working for us now. My problem is that not all of these staff have...
  5. C

    Mail merging programmatically

    Dear Accessers, I'm trying to merge the names and addresses of customers out to word. I decided that I'd use a query and then use a button to call the merge wizard. The trouble is I don't know how to do it programmatically. Another small thing is, how do I do a carriage return?? I've tried |...
  6. C

    Sub form filtering, dates between * and *

    Dear Accessers, Hi, I've a small problem that I'm not sure how to solve. I'm making a staff/department performance database and I have a form that allows me to select a department. This is linked to a subform which shows me the staff in that department. I then noticed that of course staff...
  7. C

    Tab controls

    Dear Access-ers, I am trying to update the names and number of pages in a tab control so that only current departments (things are likely to change quickly) are shown to the user. I would like to have it so that when the form is started the tab control looks to see which departments exist...
  8. C

    Silly question

    Dear fellow developers, I know this is going to sound like a really low brain question so I'm sorry. How can I call a function from within an event proceedure? What I have is a form that is based upon the date of the records kept ie each new date brings up a whole new set of records. I have...
  9. C

    Tabs

    Dear fellow users, I hope you can help me and I'm not convinced that I have posted this in the right place. I want to have a form that will allow the end-user to input daily data about salespeople by department. So I decided to have a tab for each department and then as that department was...
Top Bottom