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

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

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

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

In a table I have 3 different combo boxes that I want to be dependent on each other. If I choose an option from the first combo box I want the next combo box to display only the options for what I picked from the first combo box, and so on. For example, in the first combo box I have Fruit and...

Hello, I have a bunch of records with a date field in the format MM/DD/YY. What I want to do is create a form in the program that allows a user to enter a month and a year and the click a button and the program will generate a report that shows every record that corresponds with that month...