473,324 Members | 2,541 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Generic Forms for Use in New Navigation Control

zmbd
5,501 Expert Mod 4TB
Question first: Is there the equivalent [ME]![SomeControlName] that can be used in the form control’s recordsource parameter such as in a combo-box?

Ok, now for some context:
I’m Playing with the new “Navigation Control” that MS has so happily supplied to replace the “outdated” switchboard and yet they have only provided the psionic version of the information as to how to exactly use this control… and a few short adhoc pieces (( Build navigation UI with Access 2010 )) that make it seem like a seamless drag and drop.

I like the design, I don’t like some features, and transferring information from one form to the other sucks as the forms are closed and reopened (sort-of late opening forms in a tabbed parent to speed loading) so referring to the calling form’s controls is not possible; however, that’s another issue that might be solved.

So……. I’ve run in to a bit of a nuisance (as alluded to in the question): in order to get the forms (or reports) into the new Navigation Control… it appears that you have to build the form (report) first then drag-n-drop onto the new control!

Thus, I go thru all of the trouble to design a form that works nicely as a stand-alone implementation. In that form are several cascading combo-boxes. Nothing unusual about this, I’m sure many of us have done so… and I drag this form into the new “Navigation Form.” However, all of these little CBO have as a record source a query that has a parameter like this [forms]![frm_customeraccounts]![zcbo_newcustomer] that goes in the WHERE clause so as to set-up the record source based on the prior CBO. and ofcourse, as with any sub, these now require that I go in and change them to something like this: [forms]![NavigationForm]![NavigationSubform].[Form]![zcbo_newcustomer] once the form is dropped onto the “Navigation Control.”

This gets even worse if there is a subform on the form that I just dropped onto the Navigation Form….

Now the VBA in this form works just as I have programed… no issues. The reason the code works is that most of it either deals with the recordsets or has things like me.z_somecontrol.value = z_some_data_for_control so no problems with the VBA side of things… yet.

In anycase we're back to the question: Is there the equivalent [ME]![SomeControlName] that can be used in the form control’s recordsource parameter such as in a combo-box?
Nov 7 '12 #1

✓ answered by NeoPa

I tend to avoid that approach for that same reason (Lack of portability) Z. However, in your position I'd try referencing the control name directly and on its own. I don't have any 2010 exerience yet, nor 2007 (happily) so I'm unable to test it for you here.

5 5488
NeoPa
32,556 Expert Mod 16PB
I tend to avoid that approach for that same reason (Lack of portability) Z. However, in your position I'd try referencing the control name directly and on its own. I don't have any 2010 exerience yet, nor 2007 (happily) so I'm unable to test it for you here.
Nov 7 '12 #2
zmbd
5,501 Expert Mod 4TB
That worked!
Always the simple things I miss :(

SO.. [forms]![NavigationForm]![NavigationSubform].[Form]![zcbo_newcustomer] in the WHERE clause of the record source for the CBO became just: [zcbo_newcustomer]
The form now works when opened directly and when opened from within the Navigation Control. Everything I had read about this new navigation control type had the entire parent/subformcontainer/form/control reference in the examples and in the explanations!

argh!
Nov 7 '12 #3
TheSmileyCoder
2,322 Expert Mod 2GB
I love alot of the layout of Access 2010, and I often find myself thinking that the team whom developed access are pure genius. The amount of flexibility astounds me time and time again.

That said however, it seems they they asked an untrained brain damaged chimp who couldn't find his glasses to write the new html style online help files. The context sensitive help in AC2003 was great and quite comprehensive with good examples. Most of the time I try context sensitive help in AC2007 or 2010 I simply get the frontpage of the help, and other times there is so little information its ridiculous. Thank god for online sites and communities.
Nov 7 '12 #4
zmbd
5,501 Expert Mod 4TB
TheSmileyCoder,

Isn't that the truth!

As for the help... I too often find myseld very disapointed and at that stupid frontpage. However, I've found that if I [F1] go to the search box at the top, enter my terms, use the dropdown list next to the magnifying glass and select one of the options under the "on this computer" I actually get some information! I don't understand why the default isn't to return information from both on and offline resources.

Oh... I.... just... got... it...

What would we be doing if the help file actually worked again? ;-)
Nov 7 '12 #5
NeoPa
32,556 Expert Mod 16PB
Zmbd:
What would we be doing if the help file actually worked again? ;-)
Nah. There'd still be plenty of traffic here Z. Remember when it worked before, and we still had loads of questions that it already answered. No worries on that score I expect :-D
Nov 7 '12 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: KY | last post by:
Hi, Is there any open source navigation control available for download that can be used for windows application? Please provide links if anyone knows. Thanks in advance, KY
0
by: Sebastian Dau | last post by:
Hi, I'm trying to display a web site (help file) in a user control located in my managed c++ assambly. Unfortunately, I couln't find any generic HTML View Control so I decided to use the...
5
by: dominique | last post by:
Hi, I want to write code to manage standard (or generic) forms in Windows Forms (i don't know the correct word) like that : - a base form in a class : frmBase with some controls inside it :...
2
by: Ryan Liu | last post by:
Hi, Can someone give me a hlep on inherited user control? I try to inherite windows forms user control, like ListView. From Visual studio 2003, I right click a folder and selct "Add...
1
by: bli2001 | last post by:
Hi All, it's not uncommon to have the main menu control on the left-hand side of a page and another menu across, say, the top of the page. Is it possible to have one navigation control...
1
by: david | last post by:
When I read a white paper about web application, it said that they developed a component built as Windows forms user control, and embedded it inside a web form. So the web form page can fully use...
4
by: clintonG | last post by:
Boy that's a helluva subject heh? But that's what I'm looking for. A navigation control that has a series of rectangles (each representing a star in the pattern) where each rectangle is connected...
0
by: Reddy4All | last post by:
Hi- Is there any possiblity to make Datagrid control (Winforms) column header sort arrow more prominent in .net 2003. In Windows forms Datagrid control, when user click on the column header, default...
0
by: Reddy4All | last post by:
Hi- Is there any possiblity to make Datagrid control (Winforms) column header sort arrow more prominent in .net 2003. In Windows forms Datagrid control, when user click on the column header, default...
1
by: Luke | last post by:
Scenario - There's a file called TEST.TXT Pagebreak characters in the TEXT.TXT will be used to split the content of text file into multiple pages. A Navigation control (...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.