Re: Linking Tabs

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thanks Tina. I'm a novice user that has built a DB for my own use. I'm sure
I will continue to screw up the vocab as I go. :-)

This form is used to gather facts about an incident (much like a police
report). The form takes in a lot of information including a narrative and
places it into the table. The table is large and has several columns
(probably about 40 or so). I used the tabs to break out the sections of the
report to complete just to make it easier for the user. Then I have a PDF
print command that I use to print the report. It was working just fine, then
I added a text + number autonumber field using a script and I think I changed
a field. Now when the user complete the tabs, each tab creates a new line
item in the table as the autonumber field is set to allow duplicates. If I
change it to not allowing duplicates, the form does not let the user enter
anything into any of the tabs.

I hope this helps a littel more.

Thx

Bill

"tina" wrote:

a tabpage in a tab control can't be "linked" to a table. a form also isn't
"linked" to a table; it can be *bound* to a table or query, by putting the
table or query name in the form's RecordSource property - or it can be an
unbound form, with nothing in the RecordSource property. (and no, i'm not
picking nits over word usage; "linking" has very specific meanings in
Access, depending on the context it's used in, so using it in the wrong
context can cause a lot of confusion.)

from your description, it sounds like you have the mainform bound to the
same table that all of the subforms are bound to. my first question is: why
have you bound the same table to a form and its' multiple subforms? if we
understand what you're trying to accomplish, someone may be able to offer a
better alternative setup.

hth


"Bill" <Bill@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:51001DB9-9013-458F-A72C-4A8248900533@xxxxxxxxxxxxxxxx
Ok. So I have a form with 7 tabs. The way I designed this was that each
tab
contains a form all linked to the same table (datalink). When I input on
the
header and then clink to the first tab all is fine. When I click to the
2nd
tab I get the error "The changes you requested to the table were not
successful because they would create duplicate values in teh index,
primary
key, or relationship. Change the data in teh field or fields that contact
duplicate data, remove the index or redefine the index to permit duplicate
entries and try again".

The sub forms are all linked thru a field called "ReportID". This is a
unique field which is bases on a text and autonumber to generate a number
format of 08-001 etc. All the tabs must be linked to the reportid to
create
a single report. If I allow duplicates I get many entries on my datalink
table and they do not all come together. Very strange and I really need
help. Thx.



.

Relevant Pages

  • Re: Double click
    ... I have a form that folks use to report ... likely a duplicate, you should be able to just discard the duplicate, and ... >>> written with asp, and it submits to an asp page, and the results are ... >> the user clicks the submit button a second time, before the first request ...
    (microsoft.public.inetserver.asp.db)
  • RE: Compare workbooks
    ... origional code, which opens the new report fine, it then creates a new ... worksheet at the end of the older report. ... numbers in coloum A but these dont show up in the new work sheet. ... So I am looking for duplicate rows where coloum A is ...
    (microsoft.public.excel.misc)
  • Re: kernel BUG at mm/rmap.c:480 in 2.6.10-rc3-bk7
    ... Great you can duplicate it, useful info, thanks a lot. ... relying on a single page report seems unwise) of "Bad rmap" messages. ... static void zap_pte_range(struct mmu_gather *tlb, ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)
  • How to create duplicate report? (Copy of report, not report of dup
    ... Okay, one would think that if you wanted to duplicate a report, you would ... Not so (because Microsoft doesn't care for intuitive design, ... I hate you Microsoft. ...
    (microsoft.public.access.reports)
  • Thousands of Spies Kept Tabs on East German Military
    ... Thousands of Spies Kept Tabs on East German Military ... Cold War Discussion/News/Info Exchange Forum ... with our laws this report cannot be provided in ...
    (soc.culture.german)