I have a table for all my members, then a table for each class (for attendance purposes) and the class tables are linked to the master via subdatasheets. I also have a form that pulls up all the details of a member and I want to show all the times they've attended class. Is it possible to add the subdata sheets to the form or would I have to add the attendance record as a subform that filters on the person?
View RepliesI have a continuous form with a bound subform in the footer section. Is there a way (with VBA?) to set the tab order so that it tabs down to the subform in the footer after a few controls in the main form and then back to the main form after going through the subform?
Also I have a form with a subform in datasheet view. Can I have the tab order set so that it tabs through a few fields in the datasheet view, expands the subdatasheet and allows you to tab through it, then tab back to the main datasheet?
I want users to fill out a few fields in the main form, go the subform easily, enter the data there, then go back to the main form easily and enter the rest of the data before going to the next record in the main form.
I have a main table and multiple other tables that I want to link to each row of the main table.The main table "Data" consists of columns (Name, x, y) where "Name" is the primary key and all values are unique.Each of the other tables have columns (Name2, z) where the value of "Name2" is the same in each row and also corresponds to the table name.
I want to make each table a subdatasheet of "Data" where each row in "Data" shows the values in the table corresponding to its name. (i.e. where Name = Name2).Below is what I have so far, but the code doesn't work because linkchildfields and linkmasterfields need to be run from a subform.(?)
The error I am getting is 'Property Not Found' once the code reached the linkchildfields line.
Quote:
Sub STS()
Dim i As TableDef
Dim db As Database
Dim tbl As TableDef
Set db = CurrentDb()
Set tbl = db.TableDefs("Data")
[code]....
I have limited experience in Access, but I have managed to create a user form, where items are selected from comboboxes (Test results; when, who, outcome, etc)
At the end I have built in a command button that should add a record to an existing table, but so far no luck. I have used the following VB code for this:
Private Sub Save_test_results_KeyPress(KeyAscii As Integer)
Dim dbsICT_Test_Management As DAO.Database
Dim rstActual_test_results As DAO.Recordset
Set dbsICT_Test_Management = CurrentDb
Set rstActual_test_results = dbsICT_Test_Management.OpenRecordset("Actual_test_ results")
rstActual_test_results.AddNew
rstActual_test_results.Update
End Sub
I have a form (called Form2) with say 3 text boxes, called txt_Field1, txt_Field2 and txt_Field3.
In txt_Field1 the user specifies the number of records to be added to an existing table. The fields txt_Field2 and txt_Field3 are used to pre-populate the records with default values.
Furthermore, I have set up a table called Table1. It's headers are ID, Strategy, divRate. ID is Autonumber, Strategy is Text, and divRate is Number.
Suppose the user inputs the following on Form2:
txt_Field1 = 3
txt_Field2 = Covered
txt_Field3 = 0.04
How do I programmatically add 3 records (since txt_Field1 = 3) to Table1 such that the table will look like:
ID, Strategy, divRate
1, Covered, 0.04
2, Covered, 0.04
3, Covered, 0.04
Whenever I add a new record to a table with a form I created, it records the "ID autonumber" that it's associated with instead of the text. For instance, if I selected "Kevin" from a combobox list and had the form record it, it will show up as "1" in the table under the field name "Names".
View 3 Replies View RelatedI have a table with 2 fields in it - Type and Pallet_Case - using a form the user enters the name of the Type and then from a combo box selects either Pallet or Case. There is a button on the form that is to save the new record to the table. (code below) The strangeness that is happening is that when the new record is added to the table, whatever is the first existing record alphabetically in the table is changed to the same Pallet_Case selection that was made for the new record.
I have a list box that displays on the form that is updated after a new record is added to show what records exist in the table (this is done by a query of the table and sorts on the type), so I can see this happening without having to open the table. It doesn't matter what sort order I put the list box in nor the table it still changes the first record alphabetically. And it is only change the Pallet-Case field. I even changed the first record to something else and it still did this.
Dim dbs As DAO.Database, strSql As String
Set dbs = CurrentDb
strSql = "Insert into [PP Type TBL] ([Prepack Type],[Pallet Case]) Values ('" & Me.Type & "','" & Me.Pallet_Case & "' )"
dbs.Execute strSql, dbFailOnError
I have a form AddNewEquipment. This is bound to a table, EquipmentDetails.
EquipmentDetails has a Yes/No field, 'ParentChoice'. So when EquipmentDetails.ParentChoice = Yes, I want to open up a new text box, AddNewEquipment.ParentDescr, into which someone can put some text. This text I want to append as a new row in a different table, ParentList.ParentName. (that table also has an autonumber field)
I only want to do the save when I save the whole form.
Is this something like using an On Lost Focus event from the ParentDescr field which only invokes when the overall form save button is clicked? What would I put in the On Lost Focus event.
I have quite an extensive form linked to a table. When I add new columns to the table I seem to have a problem getting the form to read the data.I have just added a numerical column to the table and added a text box on the form that is bound to it. When I try to pull up the value using VBA it is blank, even though an entry is visible on the form. I have set the text box to general number and the entry shows in the actual table. When typing in the entry into VBA it capitalises where required so it must be registering the table entry. However the value it pulls remains blank.
View 2 Replies View RelatedI am adding a combo box to a form with data sourced from a table. Everything seems ok but when I select an option from the combo list and move to the next record the selection is repeated there also. How do I get to select a different option in the next record?
View 1 Replies View RelatedI have an existing Main form that has a sub form that the user uses to enter multiple records into a table....it works fine EXCEPT that I need to make it even easier and more intuitive and add a lot of labels. Basically the user selects items from a drop down list that adds items to a Work Order. I need to add some labels to the form to make it more descriptive for the user.
So, what I want to add multiple records using a single main form.
Is is possible to?:
1. simply turn the subform into a single main form? Can this be done by using a Command button or something similar?
2. copy all of the controls etc from the sub form into a new main form and have it all work nicely?
I have a totalquery that runs fine and give me the sum for both fields I'm looking for but I can't get the outputs to fill the fields on the form. I have tried the Dcount query in the control source but that just returns an error and locks up access.
Code:
SELECT [Tble-wcDelays].Causedby, Sum([Tble-wcDelays].HoursDelay) AS SumOfHoursDelay
FROM [Tble-wcDelays]
GROUP BY [Tble-wcDelays].Causedby, [Tble-wcDelays].LinkingID
HAVING ((([Tble-wcDelays].LinkingID)=[Forms]![Frm-ePlusCent]![cleanID]));
That is the query.
Hi all!
I want to insert a subdatasheet into a table but I only want certain records of the subdatasheet to be viewable/accessible e.g. Record 1 of my table should be related to records 1-5 of the subdatasheet. Is this even possible? Or worth doing for that matter!
Thanks in advance! You've all been really helpful in previous crises/head-scratching moments! :D
Hello,
I'm sorry if this has been already discussed but I've been searching without result.
I have a table "A", with table "B" in it as a subdatasheet.
Now when i insert a new row into "A", i need a new copy of the table "B" to be created, meaning every row in "A" would have it's private copy of "B". Is there a way to do this? I don't insist on subdatasheet solution, i just need a new copy of B to be created and linked to any new record in A.
Any suggestions?
Is it possible to pull information out of a subdata sheet to simplify a query or report? I am currently running a query based on 2 tables, however this produces multiple instances of the same info. If possible it would be much more beneficial to collect all info from the main table but I have not been able to find any info on how to access/reference the subdatasheet. Is there a way to do this or is this much more complicated than it sounds?
View 1 Replies View RelatedI have a form that I'll populate with some data, I need to then append this data to a table and clear the form for use next month, is this possible?
View 1 Replies View RelatedI wondering if it's possible to have more than one subdatasheet for one table. My table relations are as follows:
tbl1: Offices
col1: ID (autonumber)
col2: Office (text)
tbl2: Sections
col1: ID (autonumber)
col2: Section (text)
col3: Parent_Office (number) (relation to [Offices].[ID])
tbl3: Staff
col1: ID (autonumber)
col2: Name (text)
col3: Parent_Office (number) (relation to [Offices].[ID])
col4: Parent_Section (number) (relation to [Sections].[ID])
As you can see the "Staff" table has two relations. One to the "Offices" table, and one to the "Sections" table. I'm trying this because this company has some employees under an office, and some employees under a section under an office. And in the end was hoping to be able to look at the "Offices" table, then expand an office to show both contacts related to that office, as well as sections related to that office.
Is this possible? Or am I beating a dead horse?
Help is much appreciated.
Liam.
Is it possible to add new records to a linked table ? i tried it out but new records is not possible, is there a workaround for this.
View 8 Replies View RelatedHi once again!
I am trying to see if it would be possible to realize this design:
I have a table with 20 records (equipment names) and each one of them as a unique serial number and a lot of other fields;
Somehow I need to create a subdatasheet for each one of those records! This subdatasheet will contain pin to pin connections informations (lots of records maybe 70) for the cables attached to the equipment !
Example:
TabEquipment_Names
eqp1
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
eqp2
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
eqp3
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
As you can understand each equipment has a proprietary cable with specific pin to pin connections so I CANNOT create a single subdatasheet for the whole TabEquipment_Names table, but I would need to specifically create a table for each record in the Equipment_Names table, isn`t that correct?
Is there any way to do this?
Thank you.
e.
Hello all,
i am making a form to process ordering within my membership system,
i would like to add what i believe is called a subform or table of somesort, which is all connected to the same table i am using, but i would like it to appear in hte table format so that i can add more than one product that my client is buying.
the attachment i have shows what i have so far, the product information on the left is what i would like to be in the table area.
I have a form with two cascading comboboxes where the first selection is the alphabet and the second selection is a person's name. (the alphabet is a coding system but not assigned based on a person's name) I used one table based on example 2 of this website: fontstuff. com/access/acctut10.htm
What I want to do is add columns to the table such as organization, purpose, etc. then have them in the form as textboxes that update as soon as the second combo box is selected. Is this possible with just one table or do I need to go a different route?
I have an Access table with records that have a two letter, two number alphanumeric identifier (AA01, AA02 etc)
I am trying to create a form whereby, when the user types in the first two letters, the next sequential number from the table is generated.
The letters can be totally random and selected by the user, but the numbers do need to be sequential.
Hi, all! I need some help. I am trying to figure out how to enable the subdatasheet in my subform. I've already told the root query to include the subdatasheet, and it works. My subform only allows datasheet view, and I've enabled the subdatasheet visible property in the subform. What am I missing? I really need it to show up. It would be SO cool if it would work. Thanks!
KellyJo
I want to add a new tab "Debt" in CustomerDetail form. So, I want that when I click tab "Dept" to get listing the customers who are in debt to the company.
How can I get a Dept information for that Customer in a Deptform?
What is the way to do it? Dept information are stored in Dept table.
When I add something in a table using a form, I always want an automatic date, namely today's date. So I set this in the form with NOW (). The only thing is, when I view my records a day later, it automatically adjusts the dates. I don't want to type in the date every time, because it's always todays date. But I don't want the table to adjust the data-capturing dates automatically.Any suggestions to get around this?
View 3 Replies View RelatedI am new to Access and have the following problem. I have one table which displays Skills (memo field) a second table which displays a skill rating ( 5 choices) and a third table which list the jobs in the company. I need to compile a fourth table which lists the skills required for each job and the corresponding ratings. I would like to have a Form in which I select the job and all 560 skills are displayed in datasheet format and I can select the ones required and allocate a skill rating. The results should then be saved to the new Table.
Any ideas as to how to acheive this task.