 Megalog  378
Recognized Expert Contributor
Hello all! This is my first posting here, although I've been lurking here for months and getting lots of help & tips from the past posts here.
I'm in the process of updating our company's Access 2003 database to 2007, and while we're finding some of the new perks to be neat, I'm having a problem getting some of them to behave as we've envisioned. For starters, we're using the new Split Form feature. When the split form datasheet shows up at the bottom of the form, it's enabled to expand linked data from another subform/subdatasheet that's on the main form (most of our forms have a tab control with multiple tabs, each usually containing list boxes or subforms).
My question is:
a) is it possible to enable/disable that expansion option alltogether, only showing the data relevant to the main form, and
b) in the case when we want to use it, and we have multiple subforms on a main form, how do we select -which- subform is shown on the split form datasheet? It appears to only show one linked datasheet, and it's rarely the one we would want.
Thanks for your time guys, hope this was stated as clearly as possible.
-Lee
Nov 12 '07
10 26056 
If you just put a me.refresh it will make the changes appear.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Ira Solomon |
last post by:
Hi:
Any quick opinions on Access 2007?
Has anyone got this to coexist with Access 2003?
Thanks
Ira
|
by: Jasperuk |
last post by:
Ok a real and i mean real complete novice to most things in access so please be patient i know very little about scripts and code.
Trying to recreate a database at home based on practice during lunch at work.
What i have is a database at work (Access 2003) which using a form with 2 list boxes on it, the first box gets its data from query1 about the product code and the second list box recovers the description from the same query1 based on...
|
by: ARC |
last post by:
Hello,
I like the split forms in access 2007, because you can still do the header,
and any tool buttons, yet have the datasheet look without the need for 2
forms (main form / subform). However, if you add a button for "New Record",
and try to set focus to the first field, it will set the focus to the top
detail of the split form (even if you have this hidden with the splitter
bar). Does anyone know how to get the focus to go to the...
|
by: ARC |
last post by:
I posted this before, but no response. Hopefully the MVP folks will know the
answer.
I'm not sure how other's are using the new split form, but what I like about
it is I can design the header part of the form with buttons, graphics, etc.,
then use the lower half as a datasheet. I move the splitter bar to
completely hide the detail of the record, and only show the datasheet. This
is nice, because I don't have to have a main form for the...
|
by: Shaun |
last post by:
Hi all
I have converted an accress XP data file to access 2007. The problem I now
have is I cant add any data to the subforms. I have enabled all the allow
options but still no go! Please help this is quite urgent. My Email address
is shaunfish@gmail.com
Ta
Shaun Fisher
| | |
by: Wayne |
last post by:
This is probably simple but: when using tabbed forms in A2007, is
there a simple way to prevent the user from right-clicking on a form
tab and choosing "Design View" other than disabling default shortcut
menus?
|
by: avtuvy |
last post by:
My Access 2007 access application includes a split form, The user updates or enters data to the top part of the form (text boxes) and than click a button to save the data. with thedefault settings of the form the data ism saved if the user exits the form and I need to change prevent that how can I do that?. With
I wrote a similar app with Access 2003 and did all the work with VBA and it worked well but it did not have the split form feature...
|
by: stevenblanc |
last post by:
I've been hunting for a while. Since they've removed the show in taskbar option after 2003 I figure the quick way is out, but, surely there is still a VBA method of getting it done. I've done searches on a few forums, asked some experts, and browsed microsofts database.
Anyone here have any ideas?
|
by: Nej Sanerkin |
last post by:
In Access 2007 I have encountered instances where Me.Filter = "... " fails to operate for a split form. Using a reference set to the form object e.g. frmObj.Filter = "...." also fails to operate.
(In both these cases .Filter = " ... " is followed by .FilterOn = True. and in both cases a debug statement shows that the Filter and FilterOn have been updated as entered. However, using Forms!!.form.Filter = ".." works. I am already using...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
