Search results

For sure. I'm grateful for your help! Although it's a Small world Unc' I'm in Parkway at the moment. Will do when I get back home.:)

Hi Rob! I will give it a try!

Hi Unc' The Popup forms purpose is a breakdown of lines (and their totals) so the value I'd like to pass back is a Grand total of all lines, and do so on the form unload Event. Before the Popup opens, on the tabbed form the user types in a Grand total, so what I'd like to be able to do is...

Hi Guys. I will try to explain as best as I can so please bare with me. I have two subforms in a tab formation sitting on a main form. They can both open up a single popup form (via a button) and that popup form is opened via openargs with the autoID field. What I need to do is pass back a...

Thanks guys. As always... But I've reverted back to VBA to setfocus to the page in question. Private Sub lblSearch_Click() DoCmd.OpenForm "MyPage" Forms!MyPage!TabbedForm.SetFocus End Sub Sad thing is, to keep consistency - I've lost the pointy hand.

I've set hyperlinks to a couple of forms using the hyperlink address in properties. All works fine, and I've done it this way because the cursor changes to pointy hand when hovering over. However, I need to navigate to a tabbed form in a main form. Is there a way of doing this? I've been...

have a look here... this may help... http://www.access-programmers.co.uk/forums/showthread.php?t=275582

Hi Guys. Many thanks for your replies. Both work now, in each case both in different scenarios. PB, I did check for null values, and just put in an If IsNull(Me.OpenArgs) Then Else Me.cboAccountSelect = Me.OpenArgs cboAccountSelect_AfterUpdate End If Perfect! Uncle Gizmo, your method...

Hi Guys. Is there a way to simulate the afterupdate event when a form loads using openargs ? Basically, I have a form which is controlled by a combobox. It can either be opened from another form with the combobox value being pulled from another form, or it can be opened as it's own entity...

I Cronk. Thanks for your reply. What I'm after is trying to simulate split forms. But it can't be a split form for other reasons. Main form on Top (with tabbed forms), but a datasheet form (Sub form) underneath. When entering data, Say, for payables, The "Credits" tab is clicked on the main...

Hi everyone. How do I reference a subform DS field to open up a tabbed form on another subform. Here's what I have. field one on the Sub DS opens up tab one on another form, as does field two on DS open tab two on another form. but.. how can I click on "any" field on the DS, run an IF...

Hello all. Many thanks for you input on this. As a result of your help, I managed to figure out what I needed. I'm very impressed by your knowledge, and appreciate your replies, despite knowing how busy you are. Again, Super thanks.

Maybe an odd one this. But here goes... Is there any way I can record to a table, what tab the data was entered under (I'm just experimenting here). So. I have one table. two queries... One for credits and One for debits based on said table. One tab is labelled Credits, and the other Debits...

Here's a question for the experts. How do you write complex nested IF THEN ELSE END IF statements, so you don't get mixed up or confused with what happens first, next, last and so on. I'm trying to write just this, and I'd like to try to figure this out for myself. How do you start? How do...

JHB Thank you. I am currently looking into how this will work.

Thanks for that. Please don't think I've not tried searching for a solution to this. I'd much rather do so, than come straight here asking you guys. I appreciate how busy you all are. I already use a method like this in other forms. However, like a "split" form, I'd like the bottom...

Hi guys. I was wondering if there was a way to mimic a split form view, using my own design. In other words.. I have one form with 2 subforms. The top subform is used to enter data. The bottom subform shows ALL records, based on a query. What I have set up so far is... On the bottom sub...

Sometimes the answer is right in front of you. Seeing in this instance I've already updated the table the popup is referring to, I just used the mycombobox.text as the means of filtering it. Ignorance in this instance is not bliss!...:rolleyes::) Thank you for your time!

Ok, so been having a play with this, and have now managed to pass the value from the subform to the popup form, but.. the only thing is, it's always the previous value.. not this one... so in other words, if I've had to use this method before, it's always the last one I used, not the one I'm...

Yes. The source is a combobox [cboSubCategory] a subform (but the code is generated on after update of the subform control hence me.cboSubCategory. The destination is a popup.. frmCategoriesSub (I've NOW changed to frmCategoriesSub) and the field within that popup form is a textbox...