I received an excel document with a combo box, but when I click on the dropdown arrow, it turns into the plus (+) sign and will not open. I tried changing the Trust Center Settings but nothing seem to work.
i am using excel 2013.
Sackey
Last Activity: Feb 20 '15, 02:06 AM
Joined: Jan 14 '15
Location:
-
Excel
-
The user wanted a form instead. They wanted to enter an employee number and have the rest of the form populate. i already have a report and the totals show up as they should, but when i use the query to populat th form most of th records are not showing up. i am aware of the naming convention, but was trying to get the form to work first -
The only way that I can get it to copy/paste is to show it in SQL View which I am not to familiar with, If that will help you in anyway, the following is the SQL VIEW. Thank You.
SQL VIEW:
...Code:SELECT [Master Roster].Employee, [Master Roster].[Last Name], [Master Roster].[First Name], DisciplineT.Incidents, [Master Roster].[Adj Hire Date], [Master Roster].[Job Description], [Master Roster].[User Level], Count(DisciplineT.Incidents)
Last edited by Rabbit; Feb 2 '15, 05:06 AM. Reason: Please use [code] and [/code] tags when posting code or formatted data.Leave a comment:
-
I had already tried that (ctrl+c ctrl+v) and it did not work, I even try to copy/past using the snipping tool, but nothing seem to work.Leave a comment:
-
I am trying to copy/paste it but its not working, the paste option is grayed outLeave a comment:
-
i have the field (incidenS)from a table. This field have different entries for each employee (collision, injury, inspection). i am trying to figure out a way to get a total for each entry (total collision, total injury, total inspection)for each employee, and put the individual totals in a form. I tried creating a query to add them up, but when i enter them on the form i get the word 'error' in its place.Some help/advise will be greatly appreciated....Leave a comment:
-
Getting totals for different entries in a field
Please open the DDrive Doc to read my question. Thank you.... -
Sackey replied to How to total different values in a field in a table using the Dcount functionDCOUNT Fin Accessi created a form using 2tables. one of the table has a field (incidents)with 3 different entries (collision,inju ry and accidents`). An employee can have all 3 or a combination. other information is pulled from another table (date of hire etc).i am trying to get a total for each entry for each employee and put onto a form. i tried to include screen shots, but its not working. let me know if you need more info. thank youLeave a comment:
-
Sackey started a topic How to total different values in a field in a table using the Dcount functionDCOUNT Fin AccessHow to total different values in a field in a table using the Dcount functionDCOUNT F
i have a field in an access database Field name:Incidents. Table: IncidentT. in the incident field there are 3 types of incidents that are entered for employees ( injury, collision, and Inspection). i need to know how to get seperate totals for each incident for each employee on a form. tried to use the Dcount function, but keep getting errors (ie: the word name or some huge number). any help will be greatly appreciated
Thank you.
No activity results to display
Leave a comment: