Search results

Anybuddy ?

I've discovered the reason for this problem but haven't an idea of how to fix it. In the form, when none of the fields in a certain table have any fields entered, it doesn't get updated in the table. Only when all 3 tables are updated for a certain primary key, is when the new record is...

I used the form wizard to create a new form, with the same fields from the same tables, and this one has the same problem; only old records show; new records in the table are not shown.

There is no filter criteria in the underlying query. All relationship joins are good. (primary key joined to foreign keys. There are similarities in the new records against the old one (obviously) but there aren't any duplicates. The record source is my main table and the form has 3 tables...

It's already set to no. No, the form record count increases as I add records, then once I close the form and re-open it, the record count resets to the number before I added any new records. It's as if the records didn't save, but they did (in the table). This is a new problem btw. It never...

When I add new records to the form and close the form, the tables are updated with the new records, but the new records don't show in the form (navigation).

How would I say this: If ctl.Visible = False Then Set ctl to "ilovepizza" So later, I can call it saying: ilovepizza.Visible = False

Thanks, I realised that and had already changed it and added these lines. If ctl.ControlType = acTextBox Then If ctl.TabStop = True Then But is there a way to determine if the control has a tabindex property? That would be much more efficient then specifying what type...

Ok I tried this. Why doesn't it work? I'm confident that there's a problem in the tabindex line (red). I don't think access recognizes this code, at least in my case. If InStr(1, Me.ActiveControl.Tag, "ExpandCollapseSection1") <> 0 Then For Each ctl In Me.Controls If...

Is there any way to say any of these? I'm sure there must be. "last control in tab index" "if ctl is after activecontrol" "first visible tab index after the activecontrol" Because then I can alter it to suit my specs.

I just wrote the following: If InStr(1, Me.ActiveControl.Tag, "ExpandCollapseSection1") <> 0 Then For Each ctl In Me.Controls If Not InStr(1, ctl.Tag, "ExpandCollapseSection1") <> 0 Then If ctl.Visible = True Then ctl.SetFocus...

I thought of that approach, but what if it's not +1; what if it's +2 or 3 or vice versa. I understand that your code says "next tab stop", but is there a way to say "first visible tab index after the activecontrol"

I wasn't asking you to adapt my code. I was asking how is it that I can "adapt what I said in post #3 using tag properties". My underlying question is How do I say "next visible control in tab order"? or even just "next control in tab order". If not that, how can I say "last control in tab...

Thanks. How can I adapt what I said in post #3 using tag properties then? Dw, if you see my code in the db I linked to, you'll see I can have multiple tags because I use the If InStr function rather than If ctl.Tag = "tag" You can download my db form example from post #3 if it helps. Thank you.

I've got an expand/collapse section of my form set up. When you click the expand/collapse button, if the focus is on anything that is about to collapse, currently the focus changes to the next field in the tab order ('txtAddress' which I had to specify). If I decide to change the layout of...

How do I get VBA to say: Go to the first control in the tab index after the current active control (that is visible atm), except such and such controls (because they will lose visibility in a moment).

Thanks. And why were you hoping I was going to teach you when you said "creating an expand/collapse scenario is probably too complicated for me".

Not teach you lol. Just saying this is what I put together as a result of this thread; might come in handy in the future for you - as I see - a regular poster. See the example db attachment in the link if you'd like

This is a neat way to expand/collapse a subform or a section of your page (or any page control for that matter), whilst moving everything below it down/up respectively. NOTE: Example/Preview database is attached to this post (below). or Click Here STEP 1) Open your form in design view. STEP...

I thought I'd share my learnings. Here's how to make an Expand/Collapse system for a Section of your page or a Subform