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!

Register Log in
  • Congratulations derfloh 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: *

  1. stuarta

    RE: Trouble using DLookup

    Yeah. That is exactly what I have been working on. Trying to get an update query to work when I click the button. And unfortunately, I cannot find the original post. I don't really want the data to be duplicated into both tables, I just want the data to be added to the main job database...
  2. stuarta

    RE: Trouble using DLookup

    I am actually thinking now, that it must be simple enough to create a button which runs a macro or whatever to look at the job name, which looks at another table, and if it matches, fill in the relevant information from that table.<br> <br> But I don't know how.
  3. stuarta

    RE: Trouble using DLookup

    I am close. I have actually decided to use a button which the user clicks after typing the job name. The button runs an update query, which looks at the table abd updates the figures. I have got to the stage that it tells me that is going to update 5 rows, but doesn't. <br> <br> I just need...
  4. stuarta

    RE: Trouble using DLookup

    Sorry, like I said I haven't used the column count property before so I am not really sure what I am doing with it, and where I have to put the expressions and such like.
  5. stuarta

    RE: Trouble using DLookup

    Yes I think this might do it, but I haven't looked at the columncount property that much.<br> <br> Will my Print Run box have to be a combo box or can I leave it as a straight text box like it is at the moment.<br> <br> Sorry to be a pain.
  6. stuarta

    RE: Trouble using DLookup

    Thanks, I can use this for something else I am looking at, but basically what I want the main item to do is for creating weekly reports.<br> <br> What we do is every week, we create reports on what jobs we have. Most of the jobs are consistent, regular jobs. At the moment, the only way I have...
  7. stuarta

    RE: Trouble using DLookup

    What I would like it to do is basically have the jobs which are regular weekly jobs automatically fill-in certain information, to save the user having to re-input all the data. If need be I could just have a button or something for the user to click when they want the information to be filled in.
  8. stuarta

    RE: Trouble using DLookup

    What I have is a database that logs all print jobs. I have a couple of fields which I would like to fill in automatically. These fields are called (just to get started):-<br> <br> Print Run<br> Size of Paper<br> <br> I also have a field called &quot;Job&quot;.<br> <br> When the user enters the...

Part and Inventory Search

Back
Top