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 derfloh 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. commanderrico

    Argg...won't chart what I want.

    Ok, I have a database that tracks the downtime for machines in my turning shop. Each Line has specific Machines on it which vary from line to line. In the table, each machine has details about when it was down, why, how they fixed it, and how long it took. What I want to do in form is have...
  2. commanderrico

    Chart title based on data

    What I have are two combo boxes on a form where the user can choose a month of the year and the line they want to see. Then they click "Chart" and it creates a chart based on what they input. I want the title of the chart to reflect whatever they put in the combo boxes. Not sure how...
  3. commanderrico

    Exporting table error

    Ok, I created a command button to export a query to excel. I entered some data to test and make sure it work. There are 25-30 fields or so in the table and after I entered 3 records and pressed the button it exported to excel perfectly. Then I went through and entered 31 records, one for each...
  4. commanderrico

    Exporting to excel

    I need to export a query to Excel and I want to do it with a command button, does anyone have an example of the code to program the button. That's my first question. Second question: can I export that query to Excel and have it show up in an Excel template? I have a specific Excel format...
  5. commanderrico

    Getting what I want in a report from my query

    Ok, I have many fields in a table and I want to create a query based on that table. There are some fields that don't have any information in them at all. In my query I want to design so that all the fields are listed in case they are added to at some other point in time but if there isn't...
  6. commanderrico

    Dependent combo box problems...

    I got it. I searched throught the forum and found an old post and tried it a different way and combined what you had told me with that info and it worked. Thanks for your help. Rico
  7. commanderrico

    Now that's something I've never seen before

    Usually I create the form and subform in one shot with the wizard but I can't get it to do it today. Usually when you select two or more tables it'll give the option to create a mainform or a mainform and a subform. Must be cranky today cause I can't get it to work. Probably operator error...
  8. commanderrico

    Creating excel worksheet for individual records

    I know I post here a lot, but its cause I'm such a newbie. And I'm working on a few different projects so here's a question about my other one: I want to create a table with fields such as DATE: SHIFT: CAST LOT #: PART TYPE:, etc. The last field I want to be an excel worksheet. I know I can...
  9. commanderrico

    Dependent combo box problems...

    Here's the SQL from the second combo box, not sure if this is right, this is my first time trying to do this: SELECT [Mac Dept LO/TO Proc].[Specific Equipment] FROM [Machining Downtime] GROUP BY [Machining Department].[Machine], [Mac Dept LO/TO Proc].[Specific Equipment] HAVING ((([Mac Dept...
  10. commanderrico

    Now that's something I've never seen before

    I created a form using the wizard. It has parts from two tables on it, so it has a subform. When I click finish on the wizard nothing shows up on the form. All I see is the background from the autoformat. When I go to design view everything is there like it should be but when in form view...
  11. commanderrico

    Dependent combo box problems...

    I reworked the SQL like you said aboove and I requeried the second combo box afterupdate on the first as follows: Private Sub cbxLine_AfterUpdate() cbxMachine.Requery End Sub But when I run the form it still asks me for parameter values for Mac Dept LO/TO Proc.Line. The name of my other...
  12. commanderrico

    Dependent combo box problems...

    Ok, I have two tables in my db. One has different turning lines and each line has the specific machines that are on the line. My other table is for the downtime of those machines where the user will input the date, employee, shift, problem, what line it was on, what machine, etc. So what I...
  13. commanderrico

    OLE object, Excel worksheet

    What I have is a table with fields, DATE:, PART:, CAST LOT:, SHIFT:, WORKSHEET:. The Worksheet field is an OLE object and I want it to be a specific Excel worksheet that I have created. Now I want that worksheet to be the default object for each record when a new one is created. to make...
  14. commanderrico

    Creating excel files

    I do know how to create a query, and I do know some code, what I was asking, in a round-about way was if there was anything special I would need to do in the query in order to get the results I want. Maybe something I wasn't aware of.
  15. commanderrico

    Creating excel files

    Ok, I got the command button down. How do I go about creating the query so that I can capture exactly what I need? This is really helping, thanks so much. rico
  16. commanderrico

    Creating excel files

    The thing is that the user needs to create a new Excel file everyday. Is there a way to program the button and the form so that they can enter what they want the file name to be? I'm kinda new at all this programming stuff so if you would give me a little more direction that would be great...
  17. commanderrico

    Creating excel files

    I posted a message yesterday about date sensitive materials and my computer was having issues so I couldn't attach the file for you to look at. Anyway, someone from another forum suggested that I have individuals input data in access and then press a command button which would create an Excel...
  18. commanderrico

    queries and reports

    Because I'm kinda new at this I think I'll need a little more to complete the task, such as how to program the button and what to put in the query. Thanks Rico
  19. commanderrico

    queries and reports

    I have a table of downtime for specific machines that is organized as follows: Date: Shift: Start Time: End Time: Total mins: Area: Problem: What I want to do is be able to create a report that shows me total downtime for each shift and then shows be total downtime for each...
  20. commanderrico

    Combo boxes dependent on combo boxes

    Actually, the records I have are already in one table, that is from your example, my make, model, and color are all in one table. Is there a way to do it from this point or would I have to redo everything? Rico

Part and Inventory Search

Back
Top