Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Cero21

    Sum values across columns with 1 of 2 keys the same

    Worked! Thanks.
  2. Cero21

    Sum values across columns with 1 of 2 keys the same

    Basically here is what I have. Equipment(Type(key),Unit (key), allocation, Jan, Feb, Mar, Apr..., Dec) Type is the type of equipment it is (ie glowsticks). Unit is the unit number which holds the equipment (we have 4). Allocation is the number of each equipment they initially started with. The...
  3. Cero21

    Sum values across columns with 1 of 2 keys the same

    Any ideas?
  4. Cero21

    Sum values across columns with 1 of 2 keys the same

    I'm using the same thing you showed me above for "allocation".
  5. Cero21

    Sum values across columns with 1 of 2 keys the same

    Each month is a number type so the user just types in how much was used for each month. ie. JAN - 10 Feb - 20 etc
  6. Cero21

    Sum values across columns with 1 of 2 keys the same

    Well, I guess I found another question related to this. How do I sum these results together? Here what I got. As well as allocation I have fields for every month and would like to have quarterly sums. So now I can find the sum for each month but how do I add 3 months (results) together?
  7. Cero21

    Sum values across columns with 1 of 2 keys the same

    Exactly what I was looking for. Thanks!
  8. Cero21

    Sum values across columns with 1 of 2 keys the same

    I have a table with 2 primary keys: Unit and Type Each record has a field called allocation(number) What I would like to do is find the total "allocation" for each type in a query. Another way of putting this is I would like to know my total number of items from all the units combined broken...
  9. Cero21

    Copy one record from one table to another in a form

    Thanks a lot guys that worked out great. I would have never figured that out myself!
  10. Cero21

    Copy one record from one table to another in a form

    Oh ok. Makes sense. I'm going to go the button route. I typed this into a click event for a button Private Sub Command68_Click() strSQL = "INSERT INTO Deployed Personnel Archive " _ & "( [CFTPO], [Service Number], [Unit], [Name], [Initals], [Rank], [Gender], [Operation], [Start Date], [End...
  11. Cero21

    Copy one record from one table to another in a form

    Thanks for your quick response Remou. Just a question on that. Would I place that code in the "event action" for a form button or create the append query and link it to a "run query" form button?
  12. Cero21

    Copy one record from one table to another in a form

    I would like to know if I can copy one record (the currently displayed one) from one table (the table the form is based off of) to another table using a form button. I've been searching but all I've found is how to move all the records at once. Anyone know how to do this? Thanks.
  13. Cero21

    Coloured Combo Box?

    Nevermind my last. I just added the code to the on enter event. Thanks.
  14. Cero21

    Coloured Combo Box?

    I've decided to go with your first idea as it makes the interface in this case cleaner. Just one more thing now that I've been fooling around with it. Is it possible to have the colours show up right away? Right now the combo boxes are white until I change them, then they change to the colour...
  15. Cero21

    Automatic form field filling from a table data with primary key?

    Sorry about the question title I was thinking about filling the deployedpersonnel table with the Name and Initial fields from the Personnel table and have those field automatically fill when selecting the corresponding service number. I more appropriate title would be: Showing related table...
  16. Cero21

    Automatic form field filling from a table data with primary key?

    I don't know if I can explain this properly but here goes. I have three tables. Personnel(ServiceNumber[primary key], Name, Initials, etc...) Operations(OperationName) DeployedPersonnel(ServiceNumber[foreign key], OperationName[foreign key], start date, end date) DeployedPersonnel as you can...
  17. Cero21

    Coloured Combo Box?

    It's true. It's a little confusing looking but it works I suppose :) Thanks for your help.
  18. Cero21

    Coloured Combo Box?

    Hi I have a table field that uses a lookup combo box. The values are: "green", "yellow" and "red". Is there any way I could make the background or names actually appear those colours as well? Thanks.
  19. Cero21

    Open a form and automatically start with a blank/new record

    Thank you both for your extremely quick responses. I ended up going with John's suggestion as my users need a edit ability as well. Thanks again!
  20. Cero21

    Open a form and automatically start with a blank/new record

    The users of my database are going to edit/add/delete records in the database using forms. The problem is when they open a form the first record appears in the field boxes and they begin to edit that record thinking they are actually adding a new record. I have a button that clears the...

Part and Inventory Search

Back
Top