Problem With Table In Subordinate Form

Jan 3, 2008

Hi everyone,

I have a "split form" in Access 2007 (where data is shown both in a table and in a set of text fields), and I'm trying to build in a subordinate form showing data from another table (linked to the first one as "one-to-many" with "one" on the side of the 1st table). It all works fine but for the fact that I always get a side effect: as soon as I add a datasource (the 2nd table) into the subordinate form, every record in the 1st table turns from a simple line into a "grouped" entry - i.e. I get records from the 2nd table visually added to records from the 1st one according to the keyfield value (though nothing actually happens to the tables in the DB, just their representation on the form).

Any idea why this happens and how it can be fixed? Thanks in advance :)

View Replies


ADVERTISEMENT

Forms :: Uneditable Dataset In A Subordinate Form?

Jul 16, 2014

I've got a form with a combo box where I choose an employee and according to that employee's attributes are shown. Some of the attributes are stored in the same table with employee names, some of it is connected by foreign key to other tables. This form is not editable, information only. I've got a button "Edit employee" which opens another form intended to edit the information. I put text fields there by dragging the fields from tables. And so, for some reason, the only editable fields in that form are those connected by foreign key to the main table, but the main table fields are all not editable and error "not in dataset" comes up.

View 5 Replies View Related

Queries :: DSum - Update A Field In Specific Table With Info Form Another Table

Aug 5, 2014

I have a table products with a field "id_product" and "total" (Total items in stock)

I have a query with the fields "id_product" and also the field "total in stock"

I want an update query to update the field 'total' in table 'products' with infos from that query

For each id-product in table products, replace the field total with the field 'total in stock' from the query

So I want to update a filed in a specific table with infos form another table.

View 2 Replies View Related

Making Form Open With Data From A Table Based On Date And Time In Table?

Sep 12, 2014

How to make a form open with data from a table based on a date and time in the/a table?

View 7 Replies View Related

Queries :: Access 2007 - Insert Into Table Where Source Is Another Table And Form

Feb 3, 2015

If you want to use a "DoCmd.RunSQL "INSERT INTO" command to insert data in a table and the data to insert comes from a table and a form, could this be done in one pass?

So...writing a record wit 4 values from table1 together with a additional value from a textbox in table2 as 5 values.

View 5 Replies View Related

Forms :: Update Data From One Table To Another Table Using Form - Access 2010

Dec 16, 2013

How to update data from one table to another table using form.

I have data coming from design team in Database 1 and using form i want search data and assign the job to a person and store it in the database with his name. I have to do this because database from design team is read only.

View 1 Replies View Related

Create Table Of Different Columns In Three Tables Join To Form A Master Table?

Jun 4, 2015

I have three tables that contain different columns but linked by a primary column call Name. I want to create a table where all these different columns in the three tables join to form a master table which can be updated regularly either through the master table or the smaller tables. The master table also has the primary column as Name.

If I update the master table with records, it should update the respective linked table and vice versa. I also want to link these tables to my SharePoint site.

Note: except the Name column, none of these tables have any other columns in common How do I go about this?

View 7 Replies View Related

Forms :: Access 2010 - Form Shows Similar Match In 1 Table - Alter Another Table?

Dec 16, 2014

I have two tables (Access 2010). One with a list of names (List1) and another with a very similar list of names (List2), but they differ in very small ways. For example, List1 might have John Smith, and List2 would have Smith, John L.; and Smith, John. List2 also has a unique ID associated with these names that I need to append to List1.

I need to design a form that will allow me to look up names in List1, and have it return all names that are similar in List2. I then need to be able to choose with record in List2 matches with the List1 entry (based on a few other columns in List2, such as birth date) and have the form add that unique ID to the List1 record.

PS: I am using Access 2010

View 1 Replies View Related

Tables :: Multiple Table Data To Save To A Different Table From A Form

Mar 6, 2014

I have three tables: Vehicles; Vehicle Reallocated; and Vehicles Retired. I have a form that runs a query to find all the info in the Vehicles tbl that is not "Retired", not visible in the form. I then have the option to toggle to a Reallocated or Retired form. When i toggle to the reallocated form, i have the like fields in that table (ie Van #, Vin, Make etc) pulling the info from the hidden subform with the vehicle query, so i do not need to fill in repeat data. However, when i add a reallocated date and the new clinic that vehicle is for, i get the record ID for the vehicle reallocated table as expected, but when i save none of the data moved over from the query saves in the record?

How to get all the data on the reallocated form to save?

View 6 Replies View Related

Create Duplicate Table Using Same Form And Compare It With Original Table

May 1, 2012

Here is what I am trying to do: I have form, and a table which is created from this form. The data is entered a second time using the form to make sure there are no discrepancies.

Any easiest way to implement this? (create a new table (which is duplicate), and then compare them?

View 5 Replies View Related

General :: Using Checkbox Form From One Table To Populate Another Table

Dec 11, 2013

1. I have a table which lists all of the equipment we use in our company and would like to use it as a template in a form so that users can select a checkmark if the equipment is being used that day. The checked items would then be used to populate another table which records all of the equipment the user has selected. I thought the checkmark method would be best so that the user can scroll through the list of equipment and select multiple pieces for the day. The reason I don't use a multi-value field is so that the user can also enter quantity and hours of equipment used in the same table when they scroll through the list.

2. Once all of the equipment pieces have been checked, I would like the user to be able to click a review button which would navigate to the next form with all of the selections for the day. This new form will have the option to go back to the first form if any corrections need to be made. And also have the option to submit the results.

3. Once the user is finished with their selections, the user can then select Submit which will finalize the recorded equipment table and clear the checkboxes and any inputs from the equipment template table (without modifying anything) so that it can be used for the next day and so forth.

I am using access 2013...

View 3 Replies View Related

Getting Form Data Discplayed From One Table Into Another Table

Jan 19, 2006

New to Access! I am creating a quotation database where a new company name will be entered. In 1 form a pick list of products which I then want to go into another table associated to the company name which can then be queried and displayed in a report for printing the quotation.

I have created

QuotesTbl
QuoteID (PK)

QuotedItemsTbl(PK)
QuoteID (FK) (1-Many Relationship w/above)

I will create a form to generate a new quote, enter the company name with a display of quoted items (QuotedItemsTbl) (Query QuoteID).

On that Form i want to have a button to 'add items' on that form be able to pick from items in StockTbl which when selected and button 'close' copy the data to QuotedItemsTbl

Any advice to a enthusiastic buy novice newbie much appriciated.

View 2 Replies View Related

Tables :: Getting Data From One Table To Form Of Another Table

Oct 15, 2013

I have a table called "WorkRequest" consisting of some fields such as WR Number, WR Date, WR Time, WR Requested by and WR Work Requested.Once a work request is completed, I want to open a form called "JobCards" from a table called "JobCards". When I click on the pulldown box for the Job card number, it lists the "WorkRequest.WR Numbers" which is what I want.

My problem is: As soon as I select the WR Number and it displays in the jobcard form in the JobCardNumber field, and I press ENTER or TAB, it must automatically populate the corresponding fields on the JobCard Form. These fields are defined identically in bot the "WorkRequest" and the "JobCard" tables.

View 2 Replies View Related

How To Print Hidden Form Using Visible Form Only - MS Access 1 Table And 2 Forms

Nov 24, 2014

I have a Lost/Found property database which we use to keep record of the lost/found property and it is working fine.

As per our organization's policy, we keep the item(s) for up to three months in which if it gets restored to the owner then fair enough otherwise after three months the item(s) can be claimed by the "Finder". But for this very purpose we issue the Finder with a "Claim Receipt" which he/she should bring in when claiming for the item(s) after three months period. Therefore, It's just the right time to upgrade the database to a more professional level.

The database has one table and two forms.

One form (LostFoundForm) is visible to the user in which they enter data, this form has two sections; Item(s) & Finder's details and the second section is about Restoring details.

However the second form (ClaimReceiptForm) is hidden to the users (for manual data entry) and has only one section which is exactly the same as the first form's first section, i.e., Item(s) & Finder's details. This second form takes the data automatically from the first form because the table behind them is same and fields are same (please see attachment). Up to here it's all working fine.

I would like to introduce a Checkbox or a CommandButton in the LostFoundForm which when we click should pull up a msgbox asking "Do you want to print the receipt for this item(s)?" with a Yes/No option. On clicking "No" it should, obviously, settle down but on clicking "Yes" it should print the "corresponding record" from the ClaimReceiptForm.

View 3 Replies View Related

Opening A Form Based On The Same Table As The Calling Form

May 22, 2006

Hi All

I have a form based on a table called tblListMaster and I want to allow users to open up another form showing all the members of one of the entries in that table so I have added a button called 'Show List Members'.

The list members form which I then want to bring up is also based on tblListMembers (it's a master-detail form). When I hit the button to open up the list members form I get an error message saying that the table is already opened exclusively.

I can understand why I get that message so I thought I would be cunning and create a dummy form which I open up, passing in my list id in the openargs (at that point I also close the original form) and then from that dummy form automatically open up the master detail form and close the dummy.

Code in List Master form

Private Sub cmdListMembers_Click()
' open up the list members form

DoCmd.OpenForm "frmDummy", acNormal, , , , , Me.ListId
DoCmd.Close


End Sub

Code in Form Load of dummy form

Private Sub Form_Load()

DoCmd.OpenForm "frmMaintainListMembers", acNormal, , , , acWindowNormal, Me.OpenArgs
DoCmd.Close


End Sub

Sadly I still get the same error message - does any one have any ideas what I'm doing wrong?


Gordon

View 4 Replies View Related

How To Bind Form With Table And How Data Can Come Automatically In Form?

Nov 24, 2006

Hi,
I'm new in Access and facing a problem. Hope I’ll make myself clear.

I've a table "members" and I've created a form "member_form" based on this table (members).

1. I want to binde my form "member_form" with my table "member" so that the new data I store in form, automatically sotres in table. How can I do that:confused:

2. In form, I've fields "Member_ID" and "Member_Name". I want that when I type member_id in "Member_ID" field, the member name in "Member_Name" field come automatically. How can I do that???:rolleyes:

Thanks in advance
Hami Bjorn

View 1 Replies View Related

Built Form On Top Of Table - Use Combo Box To Update Value On Form

Sep 20, 2012

I have a table called input and a "form" input made on top of that same table. When I input the data on the form it updates properly no issues.

I have another table main. i update the vendor name using combo box from main.

It works like that.

SELECT main.[Vendor Number], main.[Vendor Name]
FROM main;

And I update the vendor name using control source =vendorname.column(1)

I have even achieved the same thing using DlookUp .

The problem is that it saves on the Form but the data from Dlookup or from comboBox updates for "Vendoe Nmae" is not saved in input table.

View 7 Replies View Related

Combo Box Based On Linked Table Needs To Pull Info For Sub-Form From Non Linked Table

Aug 31, 2007

I am trying to build a Form that will show an estimate (then eventually will be moved to a project if customer and employee aggree to price and project) in a Form F_Estimates is a M_Customers(Customer_ID) (Based on a Table) and thier info in a Subform. Also is the "projected costs" from parts out of the Parts(Part_ID) (Based on another Table) in a second Subform as a list that I need to calculate $$$ in
(Dang that still sounds evil and definately NOT understandable even after edit... so)

Here's some basic info

Tables

EstimatesandParts - Table
EstimatesandParts_ID : Autonumber
Estimate_ID : Number
Part_ID : Number

Parts - Table
Part_ID : Autonumber
PartNumber : Text (not a number due to some part#s have letters in them)
PartName : Text
Unit Price : Currency
Description : Text

Estimates - Table
Estimate_ID : Autonumber
InvoiceNumber : Text (again can have letters in it)
EstimateDate : Date/Time
EstimateTime : Date/Time
Employee_ID : Number
Customer_ID : Number
ProblemDescription : Memo

Customers - Table
Customer_ID : Autonumber
FirstName : Text
LastName : Text
CompanyName : Text
Address : Text
City : Text
Province_State : Text
Postal_ZIPCode : Text (CDN Postal codes are letter num letter...)

you can see the link table in the EstimatesandParts Table

Now I want to use that link to populate a subform in the F_Estimates form

Forms

SF_Customers - SubForm

(all boxes atm are text boxes on this form till I figure out the Parts section then will use same base for this so I can pick any customer in the database to be the customer for this estimate. Also will have ctrl button for making new customer with customer form and a refresh on Focus Gain bit of code)

FirstName
LastName
CompanyName
Address
City
Province_State
Postal_ZIPCode

SF_Parts - SubForm
Default View -Continuous Forms

(want it to be a list of parts that I can grab prices and descriptions from then in a bit of code to calculate a cost of parts)

Part_ID : Combo Box
Control Source - Part_ID
Row Source Type - Table/Query
Row Source - SELECT Parts.Part_ID, Parts.PartNumber, Parts.PartName, Parts.UnitPrice, Parts.Description FROM Parts ORDER BY Parts.Description;

(Pulls info from the table Parts for input into a list of parts to be used on that project)

PartName : Text Box
UnitPrice : Text Box

(here's where I run into problems due to the fact that the form is not based on the parts table but rather the link table EstimatesandParts so I can't propogate the info to the 2 other text boxes, ps I dont care if they cant be text boxes and have to be linked or some other type I'm not "set" just need to find out how to make it work )

(have tried a couple things to complete this task)

Me.txtPartName = Me.Part_ID.Column(2)
Me.txtUnitPrice = Me.Part_ID.Column(3)

(works AWSOME ... for ONE ROW then propogates the second selection to the first and second and third selection to first second and third and so on ...)

(tried to make control source for the txtPartName to)

=Forms!Parts!Partname

(Doesnt exist .. akkk, cant use ActiveForm either as it doesn't focus on the SubForm but the MainForm ... cry)

F_Estimates - Form

Estimate_ID
InvioceNumber
EstimateDate
EstimateTime
ProblemDescription

(all basic Text Boxes)

Employee_ID
Customer_ID

(Combo Boxes Select Customer and Employee from list of present ones of each)

SF_Customers
SF_Parts

(Both SubForms on the main form)

Now this is an Exerp from my entire Database I like to work on one small problem at a time and I have made this its own little database till I figure out the problem then I will bring the info I learn back into the rest of the database and go from there ...

Hope you can help I have a feeling I will need to make a recordset and go from there but I'm just not able to wrap my head around that for some reason

Thanks in advance for ANY and ALL help that I get from here

View 10 Replies View Related

Update OnHandQty Table Field Based On Qty Field From Another Table / Form

Oct 30, 2012

I have a table called Inventory (table1 - PK=INVID) that contains all inventory ID numbers and descriptions. I have another table called Inventory Transactions (table2 - FK=INVID) that gets updated through a form. When a new transaction is made in table2, I want the transaction amount to get added or subtracted to an OnHandQty field in table1. I tried having table2 (transaction table) as the main form and then table2 as the subform, but I couldn't get table2 to update.

View 5 Replies View Related

Form To Table Or Form To Object?

Apr 20, 2005

I've run into a bit of a problem with the database I'm working on now. I have a form where the user inputs a date range (start date and an end date). Those dates are used to filter a set of records. Each record has a "submit date". All records with "submit dates" that fall between the user defined date range are displayed in a report. Right now I have the date range saved in a table (which really should only have one record). That's problematic though. I think I need to ditch the table and code the dates so that when the dates are input, there are date objects which are given the values of the input dates. Therefore, at any one time in the database there is only one start date and end date in memory. Each time the user wants a report from the database, he will be prompted to input the date range. Unfortunately I don't know how to do that.

Can anyone help :confused:

View 1 Replies View Related

Underlying Table For Form|Sub-form

Jul 13, 2005

(original thank-you below...)
sorry, more stupid questions: I want the underlying table for the mainform to have the little column with the "+" you can press to see the related subform data. I created the two tables and then created a related form and subform, but the underlying table does not show the "+" column)??

HUGE thank-you for the response MStef - the example was helpful ! I will start again with 2 tables instead of one.....(I had thought i wanted to have all the info on one underlying table for viewing and printing purposes, but, I guess its not necessary). Thank-you!
SR

View 1 Replies View Related

Pass Value In Table From Form To Another Form

Mar 15, 2013

After filtering in the filter form, how do i pass the list4 value in the filter form to event form's scheduled list when i press add...

Attachment 11590

View 1 Replies View Related

Form Event (Before And After Update) Copy Form/Field Value To Another Table/Field

Aug 17, 2006

Group,

I thank you in advance for considering this inquiry.

From within a Form.field (based on a master table query), I desire to trigger two events; one before update and one after update.

This function will serve to document specific form.field value changes to a "log" table for review prior to being committed back to the master table.

What I'm looking for are functions, which I can use in a Macro or VBA code to facilitate a field read and copy before change and a read and copy after change triggering.

I'm sure this is absurdly simple.

View 2 Replies View Related

Table Form

Apr 19, 2006

I have created a AutoForm: Tabular and I have got 6 columns. I enter a product code into the 1st column, and when I tab off this column it runs the following code to fill the next 2 columns:Private Sub Product_Code_AfterUpdate()
Dim Chk As Variant
Chk = DLookup("[description]", "[dbo_tsapmaterials]", "[product] = [Product_Code]")
If Chk <> "" Then
Me.Description = DLookup("[description]", "[dbo_tsapmaterials]", "[product] = [Product_Code]")
Me.BUOM = Trim(DLookup("[unit]", "[dbo_tsapmaterials]", "[product] = [Product_Code]"))
Else
Me.Description = "Incorrect Material"
Me.Product_Code.SetFocus
End If
End Sub

The problem I have is that when the product doesn't exist in the table dbo_tsapmaterials & the Description sets to "Incorrect Material", it doesn't go back to the Product_Code column.
Is there any way this can be done, or is there a better way to do this?

Any help will be greatly received.

Kind Regards

Carly

View 1 Replies View Related

Using Same Form On Different Table

Mar 30, 2005

Hello,

I have a form that adds data to a table. This was created manually instead of using the wizard.

I now have a new table with a new name that needs to use the same form design, how do I get access to let me do this ?

When I copy and rename the form and try to change where it points to it won't let me change to the new form.

Any ideas.

Alex.

View 3 Replies View Related

Form To Table

Apr 22, 2005

Hi: this is my first post to this forum. I am amazed by the knowledge of this site. Hope you can help me with this problem
The question is: Is it possible to fill in a table with a form like this?

I made a table with the following fields:
ID
NAME
Column
Row

I have a form that has 7 fields: NAME and 6 text boxes.
The 6 text boxes referes to a small 3x2 grid. I have to input an ID number on each textbox.
The form looks something like this:
NAME:________
-- A - B - C
1 [ ] [ ] [ ]
2 [ ] [ ] [ ] <----------------Textboxes!

I will like to create a table using this form. For example, if I type the number "123" in the location A1 and "111" in A2 and the name of the project is "NEW", I will like the table to look like this:

NAME ID COLUMN ROW
NEW....123..... A.......1
NEW....111......A.......2

Thanks a lot
DAN

View 4 Replies View Related







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