Search results

Hi CJ, You're quite right - I am trying to use the Calculated field function in a table. Out of interest - why is it a bad idea to store calculated fields in a table? many thanks Chris

Good afternoon all, I am working on my DB and have 2 tables that I want to work with but I just cant work out the correct syntax for an expression… Table1: TransactionLogISSUE – this contains the following fields (Amongst others that are not relevant for this question): · PartID ·...

Thank you so much for this - thank you! Thanks also for putting the explanation in the code of what it all does - that is a great help in my learning! Kind regards chris

Good morning all, Please find attached a version of my DB. frmIssue is where my focus is and on the Issued From combo box called cboWarehouseLocat. Fields after that can be ignored as they are later things for me to work on. As you will see, when a part number is selected from the first...

Hi DB guy, thanks for getting in touch - I will but not until I am back in work tomorrow im afraid... dont have a copy here at home. Thanks Chris

Hi Arnelgp Thank you again for the sample, it works, but not in the way I am looking for im afraid. It appears in yours that I select the part, then select a warehouse to look at what stock is available. What I need is that I select the part, all the locations that contain that part then...

great - thank you, I will have a look :)

I have had a little bit of a result - in so much as with the following code, I can get the first record showing in my cboWarehouseLocat, but no other records. =[InventoryQuerysubformISSUE].[Form]![WHLocatID]

Thank you :) I keep getting an error message appear to say that the syntax is incorrect; = select * from [Inventory] Where [PartID] Like Nz([Forms]!frmIssue!cboPartID, "*") And [WHLocatID] Like Nz([Forms]!frmIssue![cboWarehouseLocat], "*") I thought I had substituted the correct terms into...

Hi Arnelgp, yes I do use a query to get the information - qryInventoryQuery. Thank you for the code. forgive me - what does "*" and "Nz" denote in this case? i.e. - what do they do?

Hi everyone, I'm gradually getting to grips with my database but now I need to display the results of the second column of a subform in a combobox on the main form. Basically, users enter a PartID in a text box on the main form. The subform then displays the corresponding PartID, WHLocatID...

Well I would say that I have achieved (sort of) what I want - certainly good enough to be able to move on with the project! So thanks once again to all for the help! Watch this space for the next cry for help... working out how to do a query to show for a given partID (entered in a text...

Hi Pat, You're correct about the checkbox; it is simply to show whether "that" line has a PDF - but now you highlight it, I guess it is redundant. The checkbox is never updated from within the form - it is simply there as an instant visual aid to whether there is a file or not. Forgive my...

thank you all - I have got the text box to be active/not-active based on the tick box value; but is there a way to make the greyed out, non active text boxes completely invisible?

Hi Arnelgp, I will give that a try - thank you :) I guess that would get around not being able to apply formatting to a button... make something else look like a button instead. thank you

Hi Colin, Thanks, at least that stops me going round in circles for hours ha ha. Conditional Formatting is greyed out for buttons, so I'm presuming that simply some controls can not have formatting applied? thanks PS - names changed now :)

Ok, so I have now got a working image database that works a charm. I have successfully added various check boxes and search (filter) criteria using what I learnt so far from help on this forum so I'm very happy! My next task is to have a button appear if a check box on a row is checked; there...

excellent, thanks very much for your help. solved!

You Sir, are a genius. thank you! So for my understanding, for this type of thing (i.e. updating of fields) would it always (or at least most of the time) need to be done through an event procedure? it works perfectly - thank you again. Chris

DB now a "better" size and attached!:)