Tab Control With Subforms / "Can't Build A Link Between Unbound Forms" Error

Jan 23, 2007

I am trying to create a database for a cub scout pack that just keeps scouts information, medical info, parents info, and parents medical info each is a seperate table. I have created a Tab controlled form with 4 tabs. On each tab the ONLY thing I have is a subform that contains the appropriate information. Each table has it's own form with the table as it's record source. I link the scouts table to the medical table by SID which is a primary key in the Scouts table. I link the Scouts table to the Parents table with a PID which is the Primary Key in my Parents table, and I link the Parents with the ParentsMed with a PMedID, key in the ParentsMed table.

Question #1 - Using a Tab Control you can only have 1 record source. What should I use? I have tried the tblScouts and I have also created a query with every field from every table.

#2 - When I try to use the parent and child links on the subform I get the error "Can't build a link between unbound forms" but each form is bound to the table and the record source on the tab control has had a table and my qryEverything, neither work. I can type in SID but it still doesn't function properly.

Any suggestions or comments on a better relationship method or any insight on how tab controls are supposed to be setup or anything would be greatly appreciated.

Thanks a lot

Rick

View Replies


ADVERTISEMENT

How To Link Subforms To Other Subforms On An Unbound Form

Feb 4, 2006

I forum could someone tell me:

I have an unbound form on that form I want to put three sub forms one on a products table the other on a course start dates table and the link table that joins the other two together. all three are related to each other with Pk/FK links.

When I try to link them it says you cannot link items on an unbound form.

regards in advance
Peter:eek:

View 1 Replies View Related

Forms :: Subforms Master / Child Link

Apr 9, 2015

I am building a user creation form. I have built it with 3 subforms

Subform 1 is voor general information about the user.
Subform 2 is some more specific information about the user
Subform 3 is more info about the same user.

Now when I create a user (record) in subform 1 it gets the primary key lets say 14. Then when i add information in subform 2. I want it to grab the Primary key 14 from subform 1. So that the information which is inputted in subform 2 will be related to information from subform 1. I get it working if I make a Main form and then put subform 2 and 3 in a subform and then let them grab the primary key from the main form. But how does this work with 3 subforms and no mainform.

View 3 Replies View Related

Forms :: Link 2 Subforms (1 To Many Relation) Within One Navigation Form?

Sep 2, 2013

Let's say :

1 navigation form called Nav_Main

2 subforms :

1 called master_form ( PK = id_master) (table : master_table)
1 called details_form (with id_master in it) (tables : details_table)

the relationship is still established

I want to switch from master_form to details_form and retrieve only records corresponding to the last id_master where I was in master_form

(do I absolutely need to recreate a parameter query of details_table ?) What is (are) the simple way(s) to do it ?

View 3 Replies View Related

General :: Tab Control - Same ID Forms And Subforms

Feb 24, 2013

I have a form with a 'tab control' on it

Tabs 2-9 have a subform on them

Each form/subform writes to a seperate table

The form is the main table

When a record is created with by the form an autonumber Id is generated

I want to pass this ID to each of the subforms so that the tables can all link

Form-1 Table-1 AutonumberID
Subform-1 Table-2 AutonumberID from table-1 (can be new field in table)
Subform-2 Table-3 AutonumberID from table-1 (can be new field in table)
For all subforms and tables

View 2 Replies View Related

Build A Link To Another Program? (modify A Text File)

May 6, 2007

I have a database that I plan to use to help us manage an old "Remedy" system....
There is a field for "Ticket number"
I want to be able to click a button and have this ticket open in Remedy.

Remedy DOES have a link system. When I creat a link it creates a file like this:

Ticketnumber.ARTask

The contents of the file are simple:

[Shortcut]
Name = NTRS-Trouble
Type = 0
Server = samson
Join = 0
Ticket = NTRS422904



The name of the file seems to be irrelevent.
How can I programatically get the button to re-write the ticketnumber into that file, in that spot (after the letters "NTRS") and then have it open the link? I figure I can keep 1 file in the working directory and just re-write that same file over and over again... I just don't know enough about VB or macros to figure it out.

View 2 Replies View Related

Forms :: Formatting Calculation In Unbound Control

Sep 17, 2013

I have an unbound text box with the following control source:

="The scores below are based on the number of total evaluations (" & Sum([TitleIDCt]) & ")."

I set the formatting of the control to Standard. It reads:

The scores below are based on the number of total evaluations (1718).

I need the comma to show up so it reads like this:

The scores below are based on the number of total evaluations (1,718).

Can this be done?

View 6 Replies View Related

Forms :: Binding Unbound Control To A Table

Jun 4, 2013

I have a user form that has many unbound controls that are used as calculated controls that lead up to an unbound control that is the grand total of all the data entered. I would like for the unbound grand total control to update the grand total field in the table where I would like to store the data..is there a way I can bind an unbound control to a field in a table?

View 1 Replies View Related

Forms :: Unbound Object Frame Inside Tab Control

May 24, 2013

On a Tab Control inside a from, I've created an Unbound Object Frame, referring to an MS Excel Work Sheet. The goal here is to link that Unbound Object Frame residing on the Tab Control and save the form/link.

Now, when I execute the code, the Object Frame is linked and updated, but when I close the form, the link inside the Object Frame is not saved! However, when I do the exact same thing without placing the Object Frame on one of the pages of the tab, so as regular control inside the form, all works fine.

The code is as follows (performed when I click the button);"OLETest" refers to the UnBound Object Frame placed inside the first page of a Tab Control inside the form.

With OLETest
.Enabled = True
.Locked = False
.Class = "Excel.Sheet.12"

[code]...

View 2 Replies View Related

Forms :: Refer To A Calculated Value In Unbound Control In A Form

Jul 19, 2015

In my DB i would like to make a form that displays different calculated values based on other forms and queries like income running cost etc., but i do not know how to refer in an unbound control to value of a control in another form. I get always #names? error. However it worked when loaded that form i refered to. Is there a way to do it without loading the refered form?

View 3 Replies View Related

Without Any Success To Build A Small Stock Control Database.

Feb 15, 2008

Hi

I am trying without any success to build a small stock control database.

very simply put I am the main site and I have many other sites. each site has a unique code. I have 4 products only. I want to have the total stock that I hold in my site and as I send stock to other sites I want the number to decrease from my site and be added to the other specified site.

any ideas anyone.

View 3 Replies View Related

Forms :: Unbound Control In Data Input Form - Auto Fill Leading Zeros

Apr 12, 2015

I have an unbound control in data input form requiring to input a 6-digit number. I have put a validation rule restricting more than 6 digits. Most users prefer to enter, say 123 and the system can enter the 3 leading zero for them.

View 6 Replies View Related

Unbound Continuous Subforms

Feb 24, 2005

how do you make them?

i've just started going through all of my forms and making them unbound, as the people i'm creating this program for are far too stupid to create good data with bound forms. a few of my forms, however, contain continuous subforms. how do i get the records to show up for them? it's actually about three levels deep, but i'm sure i can figure out how to take care of that once i hear the concept (customer form > job form > job details [continuous subform]).

thanks guys

added after i saw there's another post on this subject: sorry about the double post on the subject. i looked at the other post on this, though, and was not convinced on how to do it. i understand they're a pain in the buttocks, but these people are REALLY stupid. on second thought, is there any way to have a BOUND continuous subform from an UNBOUND form? for instance, when the user selects the record and it is brought up in the form, the bound continuous form pulls up the records based on the ID's and whatnot? will this work? thanks

View 5 Replies View Related

Forms :: Records Total On Main Form From Subforms - Run Time Error 2450

Apr 24, 2013

Trying to get a total on main form from records from two subforms.

I'm coming up with Run-Time error 2450 Microsoft Access cannot find the referenced form 'tblitemlist subform'.

View 3 Replies View Related

Forms :: Runtime Error 2110 But Only On Last Control

Mar 24, 2015

While I have developed many databases using other RDBMSs I'm afraid I'm something of an Access 2007 newbie so the vast bulk of my experience counts for nought given Access' many "unique features".

What I have is a form with about 3 text fields, 2 date fields and a number of comboboxes on it. Although, for now I'm not worrying about the combo boxes until I get the other fields working.

I am trying to develop an update screen where the user types the primary key value for a record into the first field and using DLookup retrieve the other values from the table and insert them into the form so the user can adjust them if they wish and click the Save button to write the changes back to the table. That's the theory.

Unfortunately the reality is, although the values added to the other fields using DLookup are "there" they don't appear on the screen until the controls lose focus. My best guess is because they are being added programatically and no Return key is being pressed, focus will not change and they will never appear.

So to get around this I put a line of code in the GotFocus event of each control to move focus on to the next control, effectively "looping" the focus once around the controls. This worked well until the focus was being moved from the second last control to the last control when I got, Runtime error 2110: Can't move focus to this control. The control was visible and enabled, as was a dummy control I tacked on the end to see what happened.

Main code block in Exit event of first field:

Private Sub Text6_Exit(Cancel As Integer)
Dim varItemType, varItemTypeCode, varItemClass, varItemClassCode, varDescription As Variant
Dim varPurchaseDate, varWarrantyEnd As Variant
Dim varItemTypeTxt As AcTextFormat
Dim PurchaseDateSQL As String

[code]....

View 5 Replies View Related

Tab Control And Subforms

Aug 2, 2006

I had 2 forms before, so I decided to make it easier and joined them together using tabbs, first tab is student info, the second is student cources. Since student cources relate to student info I have made it as a subform of student info. But the problem is that when I click on student info tab or student cources tab , the view scrolls down, and it gets frustrating. Is there any way to stop it from scrolling down.

View 2 Replies View Related

Forms :: Select Query Error In Control Source Of A Text Box

Jul 16, 2015

is it possible to use a sum select query in the control source field of a text box. I have a query that works fine in a combo text box but I keep getting a 'syntax error with subquery parenthesis' when I try and build on in a normal text box.

I am building the query using query design view and the query works and then I'm copying the SQL code behind the query into the text box field and access reformats it s a bit so not sure it's that's the reason.

R_P_Data_P = Table
approvalNosys = Field in the table
status = Field in the table
score = Field in the table
cmrOverview = Form
[approvalNoSys] = field in form
1 is the criteria

Code:
SELECT R_P_Data_P.approvalNosys, R_P_Data_P.status, Sum(R_P_Data_P.score) AS SumOfscore
FROM R_P_Data_P
GROUP BY R_P_Data_P.approvalNosys, R_P_Data_P.status
HAVING (((R_P_Data_P.approvalNosys)=[forms]![cmrOverview]![approvalNoSys]) AND ((R_P_Data_P.status)="1"));

View 7 Replies View Related

Forms :: Error 1907 When Placing Chart Control Within A Form

Nov 3, 2014

I have just tried experimenting with placing a Chart control within a form (Access 2010). Although the chart ultimately seems to work (based on my one simple example), I'm getting an Error 1907 (Could not register font.......) each time I launch the database or reload or edit the form.

This error message is itself contained within a "Configuration Progress" screen for MS Office Prof + 2010 which seems to complete if I select Ignore the error message but runs again each time the database is launched (with the same error message showing up part way through). I am logged on as Administrator.

View 2 Replies View Related

Modules & VBA :: Get Names Of Subforms In Tab Control

Nov 13, 2014

I have a main form that has a Tab Control. The tab control could have 5 to 10 tabs. Each tab has a subform and in some instances a tab could have a tab inside that tab with subforms as well. I want to be able to get the subform names in each tab.

I am able to get the main form name by using me.form.name

How can i get the names of each subform in each tab?

I am creating a dynamic form and need to get the names into variables for later use...

View 3 Replies View Related

How Do I Add An Unbound Control To A Query

Nov 23, 2007

I have an inventory transaction file that has quantity on hand as a calculated field. I am trying to add this unbound field to a report using a query but I can't figure out how to add my quantity on hand field to the query since it is a calculated field and not a bound control.

Any help would be appreciated.

Thanks

darrrellx

View 1 Replies View Related

Control Source For An Unbound Textbox

Oct 25, 2005

I have a form that uses a query as its control source. The problem I have is that on this form I have an unbound textbox that I need to show the result of another query in. I thought I could do this by using =[Query]![QueryName]![Field name] in its control source, but this isn't working.

What is the right way to go about this?

Cheers

View 5 Replies View Related

Tabular Form With Unbound Control

Nov 23, 2006

Hi,

Is it possible to have an unbound image control on a tabular form displaying a different image for each record ?

Actually i have tried putting some code on the onCurrent event, but it is displaying the same image in all records, depending on which record is current.

This is the code which i tried using:


Private Sub Form_Current()
On Error GoTo Err_Form_Current
If Not IsNull(Me.txtCountry) And Not IsNull(Me.txtCatalogueNumber) Then
Me.Stamp.Picture = Environ("userprofile") & "My DocumentsDatabasesPhilatelyStamps" & Me.txtCountry & Me.txtCatalogueNumber & ".jpg"
ElseIf IsNull(Me.txtCountry) Or IsNull(Me.txtCatalogueNumber) Then
Me.Stamp.Picture = Environ("userprofile") & "My DocumentsDatabasesPhilatelyStampsNotAvailable. jpg"
End If
Exit_Err_Form_Current:
Exit Sub
Err_Form_Current:
If Err.Number = 2220 Then
Me.Stamp.Picture = Environ("userprofile") & "My DocumentsDatabasesPhilatelyStampsNotAvailable. jpg"
Else
MsgBox Err.Description, vbExclamation, "Error #" & Err.Number
End If
End Sub

Actually, the above code works fine for Single Form, but not on tabular form.

Thank you for any advice.

View 2 Replies View Related

Reports :: Unbound Control On A Report

Jul 7, 2015

I have run across a problem where I have an unbound control on a report that "used to work just fine" until today. It is a concatenated string:

Code:
=[ProgramCity] & "," & (" "+[Programstate]) & (" " & Left([ProgramZip4],5)) & (" "+[ProgramCpsAbbreviations])

I have this on two slightly different reports, where only one line of the report is different. One report works fine, no problems. All the data is there. But on the second report I get the dreaded #Name? error.

So I amended my query and used

Code:
CSZ:[ProgramCity] & "," & (" "+[Programstate]) & (" " & Left([ProgramZip4],5)) & (" "+[ProgramCpsAbbreviations])

And now set the field source as CSZ and it now works fine.

So my question is: Why does the concatenated code not work sometimes in a report but the same code in a query works fine?

Do reports not like concatenated fields?

View 11 Replies View Related

How I Can Build Forms For This Question

Dec 25, 2006

Hi


I 'm new at this Forum and also I'm new programmer in Access.

I 'm trying to answer project called (Cerulean Bee) ,which is attachment down

I do the table and forms but I don't know how I can let them as it the question (Artwork Order-Employee Work Log-Print Order-Project Cost Analysis).

Her my file http://www.megaupload.com/?d=XP34TRO3

Please help me to find ant error I do , and to get best answer for my question.

I'm realy need your help


Thank you all

View 2 Replies View Related

Selecting Control To Link To New Form

Feb 13, 2006

Hi,

Have been developing an Employee DB which includes sickness records and interview information. Have mangaged to sickness records but now I need to link interviews to these specific records which is where I am having a problem.

All sickness records are shown on a sub form and I attached a button at the end of each record so that I can can add interview information that is linked to the sick record through SickID but just cannot get it to work.

Have attached relevant forms and tables and could really do with some help as am pulling my hair out here.

Cheers

View 2 Replies View Related

Continuous Subform Unbound Control Problem

Feb 21, 2006

Hello,

Please see the attached images (screen shots from my db).

I'll start by explaining the function of this form. Invoices are raised through a different area of the system - they then appear in the outstanding invoice list in my payment processing screen while awaiting payment. When a payment is received the user creates a payment using the controls at the top of the form. When created - payments will appear in a list box at the bottom of the screen. I then want the user to be able to highlight a payment from the list and type the amount to allocate against each line in the outstanding invoices subform. Then (once happy with the allocation) press the "Allocate" button which will cycle through the allocations the user has made inserting rows into my Transaction table - allocating the payment against multiple invoices.

The fields displayed in the outstanding invoices subform are selected in a query which calculates the amount still outstanding. In trying to illustrate my aim I've added an unbound text box to the subform (the column Allocate). What I'd like to be able to do is type a different amount against each outstanding invoice. I understand this is not the way that unbound controls work in continuous forms - i.e. that they are multiple instances of the same control hence when I type 100 against the first item in the list it appears against every item in the list. I can't use a bound control because the query is not updateable - and in any case, the entry won’t exist in the transaction table until it has been inserted anyway.

I'm pretty competent with Access and VBA but haven't really explored recordsets - I'm usually able to achieve what I want by binding my forms to stored queries. This, however, is a bit more of a complex problem than I'm used to dealing with.

So, to the point then. I guess my first question is - is it possible to achieve this? I'm sure it must be. If so please can someone try to shed some light?

Secondly, I have an idea but have absolutely no idea of how to implement it. I seems to me what I would need to do is build a temporary recordset for the form and add a field to it i.e. the "Allocate" field I've been talking about. The user would then be able to manipulate this recordset because the form wouldn't be directly accessing a query. Nor would there be any unbound controls on the form. Once the user had typed in all of the allocation figures they are happy with they would be stored in my temp recordset. They could then hit the "Allocate" button which would cycle through the recordset inserting rows into my Transaction table (as long as various validation rules were passed).

Does this sound possible? If so can anyone give me any help or point me in the direction of any material they know of that might be of any help?

Thanks in advance for your help.

To give a flavour of how I originally built this form I've attached another image - PaymentProcessingOld.gif. It's a similar kind of setup. Payments are created at the top of the screen and appear in the list box bottom left. The outstanding invoice subform serves only as a point of reference. The user actually allocates payments by selecting the item from a combo box and typing the amount. This builds the transaction I've talked about above. It's quite straight forward when there are only a few payments and allocations, but in practice payments are usually large and split across up to 100 different invoice lines. That makes it a very tedious task.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved