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
What I have is a table ('tblJobLog') with our main listing in it where we add customer job information as it comes in. The 'Customer Name' is a dropdown list that links to our table 'tblCustomers' so that we can ONLY select a customer name that we deal with. The alternative is to add a customer or list them as COD.
Now this is where I would like to target, the COD's. We still like to keep a record of who the COD is and we have some common customers that are listed as COD only.... So when we go to enter the customer name we have to put COD and in the description we are suppose to input the customer name (We will says RandyShop <--- me, for now).
What I would like to have done, if possible, is to see when we select 'RandysShop' from the dropdown, it checks to see if the COD Status (in the 'tblCustomers' table) is set to YES (its a check box, or YES/NO field). If it is set to YES (or selected) then the change the name shown in my main 'tblJobLog' to look something like COD: RandysShop.
The reason I would like, if possible, to do it this way, is because some customer go on and off COD regularly as the mess around with payment. So instead of creating a new customer that is listed as COD: RandysShop to have access do the leg work based on a simple YES/NO field (COD Status).
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
I'm trying to use the following code to programmatically sort four fields on the continous subform:
Code:
Me.SPlanChange_03_OFFSET.Form.OrderBy = "AOBJ ASC, ORG ASC, AVAILABLE DESC, AGFND ASC"
Me.SPlanChange_03_OFFSET.Form.OrderByOn = True
It appears that the code works partially - the values in the "AOBJ" field are as they be and so are the values in "AVAILABLE" field. The values in the "ORG" and "AGFND" fields will not sort.
Is what I'm trying to do even possible?
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.
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;
i have a button that open another form. the form should copy some filed from the form that the button in it.
Example. i have the from-A with field name- ID. in this form there is a button that open form-B.
this form had also the field ID and another fields of information on the specific person (with the same person form the form_A)
i want that the ID will automaticlly updated whrn i open the form so i can add another information. these are teo tables that are linked together and that is the reason that witohut the ID it cant be updated, and i dont want to update it manually.
We have a switchboard that we have created for a database. We would like to link from this main switchboard to the switchboard in another database. If this is possible and if someone could help accomplish this I could sleep at night and move on to my next hurdle. Thanks in advance. Paula
View 1 Replies View RelatedHi
I have a situation whereby I need to create a db that will link to a directory of images, I have successfully got access to link to an image and create a record but to add 1 image at a time would be unproductive. The user should be able to highlight multiple images and then have access create a new record for each image (link). Any support or suggestions would be greatfully accepted.
Thanks
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
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.
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.
Anyone can help me how to link fields in different tables. Im creating a databse that has an ID. and that ID will be same with the ID on the other table.
Table 1
ID = 123
Table 2
ID = link to (Table 1 ID) and when i input characters on the Table 1 ID field it will appear or inputed also at Table 2 ID field.
Hope some ideas. Thanks
Michael
Can anybody help me, I have a database with over 4,000 records in one table and >800 contacts in another, I have company ID auto number in the site details and contact ID autonumber and company ID number in the contacts, I have an embedded table in the site form but when I try to enter new contact details it comes up with the error message
'the LinkMasterFields property setting has produced this error: 'Ambiguous name detected:call_click'
I have checked all the relationships and they appear to be ok. I have also rebuilt the subform but I still have problems, does anybody have any idea how I can fix this?
Jennifer
PS I am not a programmer so could you please reply in non technical speak.
Hi
Can you tell me if the following is possible and if so how to do it.
I have several different tables which require a date to be entered.
99% of the time this date is the same ie
(Table 1) Visit Date = (Table 2) Scan date 1
(Table 1) Visit Date = (Table 3) Scan date 2 etc.....
However in some cases Scan date 1 and/or Scan date 2 may not be the same as Visit date so the input does need to be editable.
Is there anyway I can link the information in Table 1 to automatically be displayed and stored in Table 2/3 and to be able to edit Tables 2/3 if the scan date is different to the visit date which it could be for a small number of records.
Is this possible or is it simply impossible to do this.
Thanks for any advice.
im creating a workers database and iam a beginner in access.i have created one table and a form like with the following details workers number ,name ,position attendancy and allowance so what i want is is i choose a workers number from the combo box all other details associated with the number should appear how do i do that?
View 6 Replies View RelatedI 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 RelatedI 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!
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
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 = ""
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"
So I have a table "InventoryTracker", with one field lookup set to list (drop down) and the source is another table "inventory", field "Item". This works good and all the items that I enter in the "inventory" table are available from the "InventoryTracker" table. Both "inventory" and "InventoryTracker" have a field called price.
Heres what I want to have happen.
When I select a item from the drop down list menue in "InventoryTracker" it automatically fills in the "InventoryTracker" price based on the price from the "inventory" table (for the item with the same name, the one I just selected). This has to be fairly straitforward, I can do it in excell, but not acess.
Can anyone help a newby out?:rolleyes:
I need help! I've set up a database with a subform that worked until recently. I get an error message that says: The LinkMasterFields property setting has produced this error:'Invalid outside procedure'
I had added a date and time stamp for when something gets modified it changes the date/time. I even backtracked and took all that out from tables, forms, queries etc. but the error keeps appearing when I'm trying to update my subform.
Thanks,
supan
I have a risk table containing risks and risk owners (many owners for one risk), meaning that I have two risk owners columns. What I would like to do is to connect both risk owner columns (containing the name IDs) to the Names table. But Access does not allow to connect more than 1 column to another.
See the attached file...
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.
Hi
I have created 4 tables which have 3 field common in all these tables and carry the same data value. Is it possible to enter data in the first tables and it copies to other tables automatically. After all its the same 4 data fields in these tables.
Liver database
Table 1. Auto ID; Surname, First name, Patient ID;-----other not common fields.
Table 2. Auto ID; Surname, First name, Patients ID;----other not common fields.
Thanks