Search results

It's not the only reason I did it...

Understood but the people I'm building this for need that field to store the full string, i.e. "ABC-123456" not just the numeric part. It just needs to confirm to the pattern.

I can't post a copy of the DB but there really isn't much more to it than what I've described above? When I click into the textbox, ABC- appears, but also the 6 "placeholder" spaces and the cursor is at the end of them. I have to reposition the cursor or backspace through the spaces to start keying.

I'm trying to do something that seems very simple but can't quite get it to work as intended. I have a textbox (unbound) to which I want to apply an input mask. Basically, I want to restrict the user to only enter values of the form "ABC-099999" - in other words, it must be prefixed with the...

Understood Pat - and, again, agreed. That's specifically why I created the local staging table to bind to the subform. The query loads the table with the data relevant to the subform (i.e. relevant to the display) and edits are made to the staging table, not to the actual parent tables. I have a...

Aaargh - yup, have it now. It was actually displaying perfectly fine, forgot to remember the join that I lost when I switched from a non-updateable query to a staging table and omitted the name corresponding to the ID / key. Have corrected and now it's working perfectly. Thanks a million...

Yes, that did cross my mind; what's strange is, if I change it to Dynaset, the subform doesn't seem to load properly? It does show that records exist but all the fields are blank?

I have a form with a continuous subform. The subform uses a local staging table as its record source; that staging table is cleared and refilled when the main form is loaded such that the staging table only contains the records specific to the record for the main form. The idea being that I can...

I have four daughters, with only 5 years between the oldest and the youngest. You probably want to use a different analogy to get through to me! ;) (I do take your point...)

Excellent, thank you both Pat & arnelgp! Looks like you both have the same logic in play. Far more straightforward than what I ended up doing as I was concerned that updating the SortOrder field by looping through the recordset, while I had the recordset open, could potentially result in a...

I have a number of tables which include a SortOrder column (i.e. to allow the contents to be sorted in a query based on some attribute other than simple alphabetical or numerical order of a particular field or combination of fields) ID Value SortOrder 4 ABC 100 2 DEF 200 3 GHI 300 1...

Yes, see post #5 in this thread (pretty much what you're describing)

Sorry, yes... I guess so, yes. My original problem was providing an intuitive method to allow users to deselect an item in a listbox. As I explored options, I discovered that a continuous subform, as an alternative to the listbox, would solve a different set of problems that arose (nothing to...

Okay this seems to be working : In the subform : Option Compare Database Option Explicit Private frmParent As Form Private Sub Form_Load() Set frmParent = Me.Parent End Sub Private Sub cmdSelect_Click() With Me .txtCurrentID.Value = IIf(.txtCurrentID.Value = Me.txtID.Value...

Yup, totally accept that, and agree. What I'm saying is, there are situations where I want something bound to multiple rows and columns?

That's still firing code in the subform module, though, correct? I need to trigger a sub/function in the main form, somehow

Not working for some reason? This falls over : Set sfmMySubform = Forms("sfmMySubform") sfmMySubform.OnCurrent = "[DetectChange]" Public Sub DetectChange() 'Do Stuff End Sub With an error of : Microsoft Access cannot find the referenced form 'sfmMySubform' (The name is definitely...

No, agreed, and I do use custom classes elsewhere. In this particular case though, the restrictions of using a listbox control make a subform a better alternative. What I'm trying to do is create a kind of template for manipulation of "static data" within the DB. So a basic form that can be...

The end goal is that once the selection on the subform has changed, the main form manipulates its own controls to suit what has just been selected. There's a degree of complexity to this so the cleanest method is to use the subform purely as an alternative to a listbox (in order to allow the...

Fallover from question on this thread (related but not the same problem...) I have a continuous subform which lists a set of data from a query. In the header section I have a hidden textbox which holds the ID of the currently selected record. I have a button which updates the value in this...