Recent content by tpickles1984

Yes, that's a very good point. I've just recently had a query that didn't work because I wasn't updating the form properly; it's so easy to do if you're not on the ball!

Thanks Tony, that seems to have done the trick! Definitely a big improvement on the manual entry I had to use before. Also thanks to Pat, above and beyond the call of duty yet again I see!

Hi, just wondering whether anyone can help me with this. I have a simple form that contains details for a component, and a subform showing what harnesses contain this component. What I'd like to be able to do is click on a button on the form, and for it to print a report showing the data on the...

I'm sorry, I didn't mean to undermine your post in any way. Your indication of where I should be heading was right on the money! The problem was that I was already thinking along these lines, but hit a stumbling block with the last bit. I'm learning as I go with Access, and I couldn't quite...

I think that the "available" field has been misinterpreted here. When a batch of stock is allocated to a harness, this does not mean that it cannot be used again. The idea is that that batches of components can be used multiple times for different harnesses, but when the batch of components is...

If you want to send a database back to me, please use the address: TP46673@trurocollege.ac.uk Thanks a lot!

I've given this a go, but it seems very willing to include the items in the other query, and very unwilling to exclude them. I've attached a cut down sample of my database into this reply, maybe if some context is brought in, it may help in solving the problem. There are three forms in the...

I'm now writing a query to show all of the values in a table, but only if one of the fields does not match any of the values in another specified query. My coding so far goes like so: <> ([QryDisplayAllocated]![GI Number]) However, this just throws up a parameter entry box, instead of looking...

Solved! I wasn't using brackets before, I knew it would be something simple like that! Thanks a lot, I've been baffled by this for hours!

I have a query that reads a value from a form, and then displays all of the records from a table that match this value. The code goes something like this: [Forms]![FrmForm]![Text Box] This is all well and good, but is the inverse to what I want. I'd like a query that displays all the records...

Quite an old thread, but I have a suggestion if it's still wanted. I would use the .Recalc command at the end of the expression. This seems to do what you're wanting!

Right, I think I understand what you're saying! I think what I'm trying to do with the form is a bit too complicated, I don't think I can get Access to do it! I'm going to have to tackle the problem in a slightly different way I think. Thanks for the help, I'll try and bare it all in mind!

I'm having two problems in on really, so here goes! I'm trying to create a button to disable another button in a subform, but it does not seem to recognise the subform in the expression. The code is as follows: [Forms]![FrmHarnessSetup]![SfrmHarnessSetup]![Command12].Enabled = No I simply...

Solved! Thanks a lot! I used the following code instead: =DLookUp("Expr1","QryMaxSerial+1") This did the job nicely. I might be able to tidy it up a bit by doing some of the calculations I need in the Dlookup rather than in a seperate query, but it worked like a charm! Thanks again

I have a query in my database that returns a single value. Is there any way to set up a text box in a form that will simply display this value? So far I've tried creating an unbound text box, and then using expression builder to refer to the query for the control source, which produces this...