Search results for query: *

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...

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.

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...

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.

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.

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...

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.

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...