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 buttons, looks,
etc., then use a subform for the datasheet, and when you maximize, the
datasheet will automatically fill the screen.
Problem is this: if you have a button that says "New Customer" or something
to that affect, and you do a newrecord command, followed by a .setfocus
command (to set the focus to the first field), Access will try to set focus
to the detail field (which is hidden by the splitter bar), and not to the
datasheet field. How on Earth does one set focus to the datasheet portion
of a slit form??? There has to be a way, but I've had no luck.
Thanks!
--
Andy
P.S. As one aside: If only the footer would show on a split form with
datasheet, then us developer's would really have it made! You could do one
form (w/ no subforms) that would have a header area, nice looking w/
buttons, graphics, etc., then a datasheet that would adjust to the
resolution of the monitor, then a set footer area where you could place
formatted totals, other functions, etc. As of now, split forms will only
show your form header, but anything in the form footer will not be visible. 0 2081 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: 'bonehead |
last post by:
Greetings,
I'm still something of a newbie to html/php/mysql.
I have a php/html form with several fields of type "input". If the user
enters improper data in a particular field and clicks the Submit button,
the php script has to trap it and return a javascript error message box
with an OK button. That part I've already got down.
But, you know how in Visual Basic you can set the focus on the offending
|
by: Semi Head |
last post by:
Hello folks, I'm looking for a script to validate a specific number
value in a standard form input field.
An example would be, if someone enters a number into a form input, I
want the script to validate it and give an alert if that the number
exceeds the set script value.
Like if the script value is set for 3000 and the number 3002 is
entered, I want an alert to pop and give a warning,
BTW - This script must be generic enough to work...
|
by: uranuskid |
last post by:
Hey folks,
I was going to include a contact form on my website. Well, in the first place that seemed an easy thing to do with a form that prompts a PHP file validating the input vaiables and using it's mail () function to send the mail. However, as I got more into that topic I realized that one should be really concerned about the validation part to prevent spam abuse.
There are shiploads of 'mail scripts' available with each of them has...
|
by: google |
last post by:
In a continuous form the following code is under a button in the form
header. In Access 2003 and earlier, this goes to a new record, then
adds
relevant data to that new record.
DoCmd.GoToRecord , , A_NEWREC
If <some codeThen
= "CA002"
Else
|
by: Neil |
last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text
feature does not support: a) full text justification; b) programmatic
manipulation.
I was hoping that someone might know one way or the other whether that was
true or not, or could point me to an article or help text that would. What I
have seen so far online and in Access 2007 help seems to confirm the above.
But that (or at least (b)) seems incredible that it...
| |
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: lupo666 |
last post by:
Hi everybody, this time I have three problems driving me nuts :-(((
(1)
I have a report with 20 or so Yes/No "squares". Is there a way to
either hide/show the "square" or change the yes/no relative textbox,
depending on value?
(2)
|
by: Megalog |
last post by:
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...
|
by: ARC |
last post by:
Now that everything seems to be fixed in the 1st service pack of the 2007
runtime, I'm wondering if anyone else has seen the annoying focus problem?
What happens is you'll open a form, and the flashing cursor will just
disappear. Seems to happen mainly on split forms. Just curious how
wide-spread this is, and if anyone else has the same issue.
Andy
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |