Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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