So I am building a database to track PTO. I already have a form set up with an append query but what I want to do it use a list of check boxes to create mass appends incase a large group of people leave, Holidays, etc. Instead of having to do them individually. I am wondering if this would be possible for me to do? Thanks for your help in advance!!
Question Mass Append
- Thread starter brow1726
- Start date
Are you wanting to "click" against employees taking leave and append all those records where a control has been checked ?
If so, your append query would look for the flag on the table updated by the form control you checked. Use a Continuous Form.
If so, your append query would look for the flag on the table updated by the form control you checked. Use a Continuous Form.
Maybe start from the beginning.
Do you have a Continuous Form with a check box on each Record ?
If so, then actioning the check box would normally change the bound table. The Append Query would select records from the Table where the field is Yes/-1
You may need to build in a Requery as the first action on the Command Button as the last record checked may not update the table.
Do you have a Continuous Form with a check box on each Record ?
If so, then actioning the check box would normally change the bound table. The Append Query would select records from the Table where the field is Yes/-1
You may need to build in a Requery as the first action on the Command Button as the last record checked may not update the table.
I have a entry form attached to a table by an append query. I have data pertaining to the certain date, amount of time taken, etc. What I would like to do is have the ability to check boxes at the bottom to sub for the employee field so I can create multiple records at one given time.
It has an employee field, date, type of PTO, Hours Used, it has a button that runs an append query to a seperate table holding the records. At the bottom I plan to put check boxes with names attached to them. I would like to use these text boxes to sub for the employee box so say 10 people decide to leave early. I can check those 10 people at the bottom fill out all the data and save records for each individual on the table that holds the records.
Your description of the Form does not sound normal.
If One Employee is at the top of the Form, how can you then check other Employees on the same Form ?
I can imagine a Main Form where you can enter details of pending leave and a Sub Form (continuous) where you can check any employees that will take the above leave option.
Can you post your form (screen shot) or attach a stripped down database that has no sensitive data ?
What version Access ?
If One Employee is at the top of the Form, how can you then check other Employees on the same Form ?
I can imagine a Main Form where you can enter details of pending leave and a Sub Form (continuous) where you can check any employees that will take the above leave option.
Can you post your form (screen shot) or attach a stripped down database that has no sensitive data ?
What version Access ?
Here is a stripped down version I used names of cartoon characters. The employee field is changeable as well as the employer field is not neccesary I was just using it because I thought it would be nice to have but I dont think that dlookup will work with a check box set anyways. All other fields are mandatory. Any help with this would be great. Thanks Again!
Your Form TimeOffSummary1 is attempting to perform a not Normal task.
The main part of the form is ok but the 3 buttons will always be suspect as to what they they can do.
Think about how a Database should work and why you would even use one.
If there were only 3 employees then why spend time and money on a database ?
If you have an unlimited number of employees then separate buttons for each employee is not sustainable. This will you if this is pursued :banghead:
I have to be out of office for 24 hrs and others may assist.
For now I suggest you think about how the flow will work.
Do you first look at an Employee and then see if any others may also require attention or do you review a pending holiday that may suit more then one employee.
Happy to assist further but not for a day or two.
The main part of the form is ok but the 3 buttons will always be suspect as to what they they can do.
Think about how a Database should work and why you would even use one.
If there were only 3 employees then why spend time and money on a database ?
If you have an unlimited number of employees then separate buttons for each employee is not sustainable. This will you if this is pursued :banghead:
I have to be out of office for 24 hrs and others may assist.
For now I suggest you think about how the flow will work.
Do you first look at an Employee and then see if any others may also require attention or do you review a pending holiday that may suit more then one employee.
Happy to assist further but not for a day or two.
So I decided to go with a list box to make it an easier process and I am having trouble trying to append the query to the table to create a single record it seems to keep multiplying the new record to double what in the database. Anyone have any Ideas?
A list box instead of hard coded buttons is a smarter way although I still question the normal work flow issue in what you are doing.
You don't append queries. You mean append a Record to a Table ?
Test your query as a Select Query before changing it to an Append Query.
If you are adding a Leave Record then you would have multiply records in a table as an Employee takes leave over the years.
You are not getting mixed up with an Update Query that will make changes to an existing Record ?
Attach your Db again if you are still stuck on an issue.
