Subform Link

May 17, 2006

I have a main form (parents and their grant applications) and a subform (children). The information for each is stored in three seperate tables. The parents and children are linked in the relationships via ParentID (one to many). The parents are linked to the applications via ApplicationID.

I have a query which links parents and applications, this query is the recordsource for the main form. The subform is a query of just the children table. The problem I am having is that the subform doesnt seem to be linking to the main form. When I add the details of a new parent/application the ParentID doesnt automatically show on the subform. And I get 'automation object' errors.

View Replies


ADVERTISEMENT

How To Link Form And Subform

Jun 26, 2005

Hi every body. i made a bounded data entry form that is based on a form and a sub form. But when i try to run it i get many errors. I be happy if some one help me how i link these two tables since draging the sub form to the form did not establish the reletion automatically! I be happy if some one teach me how to link form and sub form together. Below u can see the two query which is for the main form and sub form.thanks


http://i5.photobucket.com/albums/y180/method007/constraint.jpg =====> table reletionships pic

QTimeKeepingemployeno,name ==>query

Code:SELECT dbo_Employee.employeeno, [dbo_Employee]![lastname] AS EmpNameFROM dbo_Employee;

subform query:

Code:SELECT dbo_Hours_worked.*, dbo_Task.descriptionFROM dbo_Hours_worked INNER JOIN dbo_Task ON dbo_Hours_worked.Task = dbo_Task.taskcode;

View 1 Replies View Related

Field On Subform Link With Form

Nov 28, 2005

hi

i have a form just like customer orders in Northwind
with 2 subforms
Subform1 is showing orders number and i want to add something on that

subform 2 is products that ordered !

i want to add something on subform1 that if i Dbl Click on orderID field
it will sho for example another Form "orders"
i'm trying this code but i can't do it


Private Sub OrderID_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "orders"

stLinkCriteria = "[OrderID]=" & "'" & Me![OrderID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit Sub
End Sub

would u please help me

View 1 Replies View Related

Link Multiple Fields From A Subform

Dec 1, 2006

Good Afternoon to all...
I am looking to link more than one field from my subform to my main form. I have one field linked by properties (link child field/link master field). Is there a simple way to link another field from my subform to my main form?
Please Help??? Cori

View 5 Replies View Related

How Do I Link A Subform To The Main Form?

Oct 24, 2005

Hi,
I have set up a database for my company which holds records to all the companies that we have as clients. I have created a main form and a subform. The main form is where all the particulars of the companies are entered, and the subform is like a preview window of the companies. By right, when i click on one of the records in the subform, it should reflect in the main form, enabling me to add on additional information using the fields in the main form (i have some features in the main form that should be used to record the informatio), but I just do not know how to go about doing that. is there a way to link the subform to the main form, such that when i click on the past records in the subform, it will reflect on the main form for me to edit? Any help is appreciated.

View 6 Replies View Related

Forms :: Link A Subform To Other Records?

Dec 4, 2013

I am creating a database for work. I have a form that has a record of information for a single contact. On that form I have a sub form that will have a series of notes that should be attached to the record that loads.

At the bottom of that form are three buttons. They move from one record to another. I want the notes subform to change when I move to another record.

How do I link the subform to the record loaded on the form.

Attached is the access database.

View 6 Replies View Related

Unable To Link Subform With Memo Field?

May 31, 2006

I have a form/subform that I want to link together using a memo column, yet when I try Access tells me that the column datatypes are incompatible. I've even tried making both the form's and subform's recordsource be the same table. Any idea how I can do this?

View 6 Replies View Related

Forms :: Link A Record In Subform To A Form

Jul 13, 2013

I have a form (frmAddBeaterToShootDay) with a subform (frmChooseBeaters). I want the subform to show all the records of all the beaters in the contact list, which it does. I then want to be able to tick the box (AddToShootAsBeater) and associate that person with that record on the form (frmAddBeaterToShootDay).

When I go to the next record on the form (frmAddBeaterToShootDay) again I want to show all the beaters on the subform but all the tick boxes in (AddToShootAsBeater) should be blank until I tick the required ones.

I think I should be doing this as a Many to Many relationship which I have done from (tblContacts) (tblShootBeaters) (tblShootDates).

The problem is when I put all three tables in the query I get no results in the subform!

View 1 Replies View Related

Forms :: Open Link Form From A Subform

Dec 16, 2013

I have a form containing company records. In a subform I have contact records for individuals in each company.

Each of those individuals has a child table for adding contact notes (telephone, email). I want to add a button to the subform to open a new, separate form so I am able to add notes.

I used the wizard to create a link button but I get

Code:
Syntax error in query expression

So does Access assume the button is opening from a form rather than a subform or does it not matter? Is there something I need to change to the following code?

Code:

stDocName = "Form_Companies_Notes"
stLinkCriteria = "[Company_contact_ID]=" & Me![Company_contact_ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria

View 3 Replies View Related

How To Link A Subform Field From The Main Form

Jan 5, 2012

Seems like nothing I have so many questions today.

I have a main form and a sub form. The main form have a command button where when I clicked, the Sub form text fields should be empty or cleared.

How do I refer to that of subform from the main form?

This is what I have now and its not working.

Code:
Me.Forms![frmAuditAddNewMain]![frmAuditAM].Form!Text123 = ""

View 3 Replies View Related

Link Parent To Child In Master And Subform

Aug 28, 2013

When trying to link parent to child in master and subform, I am getting a pop-up:

Subform Field Linker
"Object variable or With block variable not set"

View 3 Replies View Related

Forms :: Option Button Link To Invisible Subform?

May 8, 2014

I have two option buttons, 1_optn and 2_optn. I have two subforms, 1_frm and 2_frm.

When clicking the little round dot (the option button) for 1_optn, I want the subform 1_frm to become visible. Likewise, when clicking 2_optn, I want the subform 2_frm to become visible. In the properties panel, both forms visibility is set to No.

I have tried creating a Macro and the best I've gotten is using the OpenForm function but that opens up the forms in a new window. I'd set the Macro to the OnClick event for a combo box (as I couldn't get the option button to work) so when "1" is clicked, the form would pop up. But they have to be in the same form. No pop ups. It also has to be an option button, not a combo box or list box.It also has to be a Macro. No Event Procedure coding unfortunately.

View 1 Replies View Related

Forms :: Create New Record In Form - How To Requery Subform To Link Properly

Apr 2, 2013

I have a form (frmAddManifest) with a subform (subfrmManifestTransporters).

When creating a new record, I can enter data into frmAddManifest, but the subform doesn't update to link with the record - I presume it's because the record from the main form hasn't been completed yet.

Is there a way to requery the form and/or subform so it stays on the record I was working on, and link the subform properly?

View 4 Replies View Related

Forms :: How To Link Combobox Between Form And Subform To Only Show Selected Filtered Data

Apr 1, 2013

I have a suppliers table and a products table. Two forms, Stock form with combobox to list Suppliers and a sub form with combobox that lists Products.I want to select a supplier from the Stock form and then the combobox in the subform to only list products directly sold by the Supplier.Have dabbled in SQL as follows:

SELECT Products.ProductID, Products.ProductName
FROM Suppliers INNER JOIN Products ON Suppliers.SupplierID = Products.SupplierID
WHERE ((Stocksubform.SupplierID=Stock.SupplierID))
ORDER BY Products.ProductName;

View 2 Replies View Related

Subform In A Form Doesn Show Controls When Link Child And Master Fields Derfined

Jun 13, 2005

Hello,

I have a form and a subform in MS Access 2003. I have made some changes to database structure, so I decided to change the subform also. When I changed the Link child and link master fields, the controls of the subdatasheet dissapear- they show only in design view. If I clear the contents of Link child and link master fields they appear again, but the records are not binded.
Is there a setting on the parent form that also has to be changed, to make the new binding?

Thanks,
Aleksander

View 1 Replies View Related

Link Me Up.

Aug 8, 2005

Folks,
i have a small problem wizzing my nut. I copy two tables from mycurrent database to an external database,now i am trying to link these two tables in the external database to the ones in the currentdb. I get a run-time error 3012 telling me that an object 'tblLanguage' is already present.which iam failing to track. Any ideas Please??
Here is my linking code.
Sub LinkMeUp()
Dim tbl As DAO.TableDef
Dim sTableName As String
Dim sThatTblpath As String
Dim dbName As String
dbName = "my_ExternalDatabase"
sThatTblpath = ";Database=" & db_Path & "" & dbName

For Each tbl In CurrentDb.TableDefs
sTableName = tbl.Name
Set tbl = CurrentDb.CreateTableDef(sTableName)
tbl.Connect = sThatTblpath
tbl.SourceTableName = sTableName
CurrentDb.TableDefs.Append tbl
Next tbl
End Sub

View 3 Replies View Related

How Do I Get Rid Of This Link.

Aug 2, 2006

Hello,

The current database I am working on I made it by copying the one I was working on originally. I just realized on the VB window that there is still some relation between them. Because, if I look at the tree on the left of the code window I see it says "GCB (miniGCB)", being GCB the one I copied, and miniGCB the one I am working with.

How can I get rid of the link with GCB?? I want the tree to just say "miniGCB".

Thanks,

View 1 Replies View Related

Link Pdf

Jan 17, 2006

Hello all,

I created a table and linked a pdf file to one of the fields, but when I created a form to display the table contacts, I could not see the attachment or icon or any reference to the linked object. The field in my access table is an OLE object.

Thanks for helping out.

View 7 Replies View Related

How To Link FE To BE Using VBA?

Aug 31, 2005

I have packaged an Access DB (Split) as a run time solution so I can distribute to users without Access.

When I install it on a PC it runs.

If I move the back end to a network, the solution can't find the back end because it has been moved.

Access run time does not include the linked table manager in the toolbar.

Is there code in VBA where I can refresh the link between front and back end.

Ideally I want to write an error handler that will call a sub to prompt the user for the new location of the back end if it has been moved. Then have the user browse to the network location and click on the back end and store that location as a string. Using that string refresh the links.

Any ideas on that?

View 5 Replies View Related

Excel Link

Nov 3, 2005

Hi all,

I have added about 15 links on a form, linking to word and excel documents. The word documents open fine but all of my excel documents pop up with a messae saying the file cannot be open, yet when i just go to the document on my hard drive they all open fine...does anyone have any ideas please. Thanks

View 6 Replies View Related

Link To Excel Doc

Apr 11, 2006

Hi,

I'm new to this so please go easy!

I have an excel document which automatically refreshes data gathered from an access db.
I need to put a button on the switchboard on the same db to open the excel document, basically to make it easy for others to find.
I have tried hyperlinks but it doesn't want to play. It locks the db and then won't refresh the information.
I know i'm missing something blindingly obvious, can someone help?!
:confused:
Thanks
elsiegee

View 1 Replies View Related

Link Tbl Keys...which Way To Go?

May 13, 2006

Hi Forum,
I'm building a db to track computer and user problems for work, where I double as a Client Support Administrator (IT Guy).
I have these tables: (simplified list)

tblComputers
tblPeople
tblCompAssignment
tblProblems

I'm at a loss as to how to link the 'Problems' table. This is where I'll record trouble tickets reported by users.
Incoming trouble tickets could relate to the Computer or to the User's Network Login.
I thought I might have a field in the problems table for UserName and also one for ComputerID, but this seems problematic. Anyone got any ideas?

View 12 Replies View Related

Link To Url From Messge Box

Jun 29, 2006

I am trying to link to a url from a message box with difficulty.
eg the user opens the form and a message box appears asking have the latest datasets been downloaded? If answered yes the form opens, if no links to web address.

has anybody any examples.
Thanks

View 2 Replies View Related

Link One Field To 3

Apr 12, 2008

I have a database which works as an information system for the upcomming olympics.

In tblAthletes is...

AthleteID (Primary Key)
FirstName
Surname
And Various other fields not needed in this problem

In tblResults is...

Gold
Silver
Bronze
Also other field in this table


What I am aiming for is to have Gold AND Silver AND Bronze all as foreign keys of the AthleteID field.

Is there a way to do this or can another way be suggested. I am working on the 2000 version of access.

View 5 Replies View Related

Cannot Link Tables

Dec 24, 2005

Hi There

i am trying to link some more tables to my access front end from the sql server back end

when i select 'ODBC Databases' from the link pop up box, the pop up box just closes

any ideas why, or work arounds would be appreciated

Happy Christmas

View 4 Replies View Related

Link Tables

Jun 20, 2006

Does anyone know how to link tables automatically/VBA?

I'm trying to import files from our DB2 database in which one file is created monthly and instead of manually importing / linking the files manually, I'm looking to have access link to the new file automatically.

The file names are structured as so..

ITM01 (Jan)
ITM02 (Feb)
ITM03 (March)

Thanks

View 5 Replies View Related







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