473,327 Members | 2,012 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,327 software developers and data experts.

Tabbing Through Multiple Datasheet Subforms

20
Hello,

Currently, I have a main unbound form with 5 subforms, all of which are in datasheet view. I need to be able to navigate between the subforms as if they were one big datasheet.

I found this article, and it kind of helps... but isn't exactly what I'm looking for either:

http://www.techrepublic.com/article/...-and-subforms/

Does anyone know what I could do to have this effect?

Thanks in advance for your assistance.
Mar 27 '14 #1
5 1244
zmbd
5,501 Expert Mod 4TB
Not really sure what it is that you are after, or why what is discussed in the referred to article isn't what you need to have happen as you do not explain the deficiencies of the method.
Mar 27 '14 #2
NeoPa
32,556 Expert Mod 16PB
Furthermore, if something is important to the question then simply linking to something that includes that within it somewhere is not a good way of asking the question.

When people have to do the groundwork for you just so they can understand what you should be asking, they are often less than keen to spend their time trying to help you.
Mar 27 '14 #3
Vaulcul
20
Thanks for the quick response zmbd and sorry for being vague. I'll try and clarify.

I'm trying to make it so that as a user tabs through one of the datasheet subforms, when they get to the end of a record contained in the datasheet it will jump to the appropriate subform and record in the datasheet in that subform.

In looking at the link I provided in my first post, I was able to figure out how to set focus to cells in other subforms while tabbing... but with odd/strange behavior. Like when I get to the last record and press tab in the first subform the next record in the current subform is selected before the setfocus code executes.

The user experience I'm after is that they will be able to tab through all of the data as if it were one big datasheet, even though there are 5 subforms that they are jumping between.

Below is a sample of the simple code I've written... I'm pretty sure it's too simple:

Expand|Select|Wrap|Line Numbers
  1. Private Sub PP10_KeyDown(KeyCode As Integer, Shift As Integer)
  2. If Shift <> acShiftMask And KeyCode = vbKeyTab Then
  3. Me.PP10.SetFocus
  4. Me.Parent.PY_PP_Spring_Filter.SetFocus
  5. Me.Parent.PY_PP_Spring_Filter.Form![PP11].SetFocus
  6. End If
  7. End Sub
  8.  
  9. Private Sub PP1_KeyDown(KeyCode As Integer, Shift As Integer)
  10. If Shift = acShiftMask And KeyCode = vbKeyTab Then
  11. Me.PP1.SetFocus
  12. Me.Parent.PY_PIT_Job_Filter.SetFocus
  13. Me.Parent.PY_PIT_Job_Filter.Form![Notes].SetFocus
  14. End If
  15. End Sub
Mar 27 '14 #4
Vaulcul
20
My apologies NeoPa... I struggle with providing full/good information. Thus I don't post often to help forums, as it's usually frustrating to everyone :(

Not trying to make other people do the ground work, just not very good at asking for help.
Mar 27 '14 #5
NeoPa
32,556 Expert Mod 16PB
I understand. Not everyone is able to come out as they'd like to when they put their thoughts into words. These are some ideas to bear in mind of course, but just do the best you can. After all - it's you that benefits most from getting it right.

Good luck :-)
Mar 28 '14 #6

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

Similar topics

0
by: misscrf | last post by:
I am currently working on a database, in 3rd normal form, which is for candidates who apply for a job with the law firm that I workd for. My issue is with good form design. I have a main...
2
by: Guy_Philly | last post by:
I am trying to add multiple subforms (or subtables?) on an existing form. The underlying table is a very detailed descriptive table for art in a collection. I am already using one subtable to...
22
by: banderson | last post by:
Hello I'm new to developing databases in Access and using Access2003. I have a dataset with a few many to many relationships that I have created linking tables for to make multiple 1:M relationships....
10
Megalog
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...
2
AccessIdiot
by: AccessIdiot | last post by:
Title says it all - I have a form with a subform. Subform has one unbound checkbox whose sole purpose is to launch another form when checked. I have this subform in datasheet view (for ease of data...
0
by: David Wilschek | last post by:
Hello, I am trying to make a high level summary form which has multiple subforms displayed on open in pivot chart view. When i go into form view on the main form i can only manipulate one of the...
10
by: CJ Jarvis | last post by:
Hello, I have been trying to resolve this problem for a while and can't seem to find a solution anywhere. I have a database with the following relationship setup: A) Contract table with field...
3
AdamHope
by: AdamHope | last post by:
I'm wanting to give my users some options in a datasheet view * drag the columns around * set the widths * show or hide columns, etc. If they do this, the changes don't 'stick' because they're...
1
by: Kim Strom | last post by:
I have an unbound main form with 2 datasheet subforms that are linked together by a field I put on the main form that reflects the value needed to link the 2 subforms. That works perfectly. So on...
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...
1
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: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.