Search results

Afternoon. :) I have a combo box, 'Type' that has two values - "Instrument" and "Equipment". Another combo box control, 'Criticality', has an Enabled = False value set OnCurrent. When the user selects "Equipment", Criticality goes Enabled = True and when OnUpdate to "Instrument", Criticality...

Thanks! I managed to solve it myself eventually, I finally twigged what you said above about the JOINs and so figured out that I had to simplify it and then add a criteria and it worked. :)

I have a big table, EquipmentDetails and separately I have job plans. Job plans can have many pieces of equipment. I store the relationship in EquipmentDetails_JobPlanDetails, but am feeling frustrated as I can't seem to get Access to build the SQL query from this in the way I want. I am...

That's actually very helpful, thank you. Part of my problem is that this is really just a document generating system, it doesn't really get used as a planning tool, other than peripherally. I think I've solved the specific problem I was wrestling with on one level, but your solution does sound...

I've browsed this a lot, but can't see a solution that fits my need. I have a Job Plan form containing a selector that chooses a system number from another table. I want to (inside the same form) look in a third table that ties system numbers to equipment items (one system has multiple items of...

Ha! That's all it takes, lol. Thanks so much. :banghead: :D

Thanks for your efforts, really appreciated. :D I tried the same thing and it works fine, so yes, the basic macro code is fine. Evidently the problem is some property or other on the form. I have some macro code already running on the target form that does things like making some fields...

Set to "Yes". :) These are the Data properties from EditEquipment. Record Source EquipmentDetails Recordset Type Dynaset Fetch Defaults Yes Filter (blank) Filter On Load No Order By (blank) Order By On Load Yes Wait for Post Processing No Data Entry Yes Allow Additions Yes Allow...

Further to this, I just built a really simple test form which only has the ItemID plus another field and tried the same code with that and it works fine. I presume some property setting in my complicated big form is blocking it from opening with the correct ItemID selected. Any ideas which...

Ah - good point. I've changed it, it was an autonumber type. Nothing has changed unfortunately though - the form opens with no error, but no record is showing. The only code I have at the moment in the destination form is a do.command maximise. The record controls below show it on 'record 1...

Morning all. :) I have a list box, List3, in a form, which is populated from a query. The list populates correctly. I added a command button which I want to open a new edit form with the selected record from the List3 control. I used this code on the DoubleClick event - it opens the form...

Ahh, thanks, yeah, I was beginning to realise it was something like that. The InnerJoin shows up in the SQL when I do a select of the two rows in the related table. I suppose in a way it's quite neat, because it means it only stores a reference to the combo box value in the main table, but it...

No, doing that has no effect and anyway in the List box I want 6 selected columns. Strangely, the only one that was a lookup in the original table displays correctly! One thing I do notice is that the query on which the list box is drawing also shows the combo box options for each field. I...

This is odd. :confused: I have a table x where the field value is selected via a combo box in a form that is populated from another table z. When I look in x, it appears to have correctly stored the text from z, not the ID number. I then built a Query, qX, which looks in x and grabs the...

That video was excellent, thanks a lot for the link. I find the Microsoft help pages rather challenging. :rolleyes:

Just a general query about the best approach to take for an editing form. I want to have two separate forms, one for adding a new record (have completed this) and one for choosing and then editing a selected record. In general terms, what is the best design approach for this type of problem...

Hmm, yes, I thought of doing that, but I was a bit hesitant because I wasn't sure about some things. Does it copy over any VBA macro code as well? Also, I tried it, but some of the formatting seemed to go, am I missing something about how you copy elements from one form to another?

Haha, I think it died but the ghost lingers on. :) No, it isn't selectable, so it has no properties, no matter what you try and do in that part of the sheet, all you see is empty cells.

Afternoon, I have an annoying issue. An old label, previously attached to a combo box, will not delete. I can't select it or move it. I've attached a print screen - it's the one in the lower left of the form called "DeviceTypeDescription". I've tried things like repairing the DB and also...

Oh, OK, I will, thanks for the tip. :) Copying it and then copying it back worked. Just somewhat annoying I suppose. :(