Search results

I need to print out your reply and study it more thoroughly so I can comprehend. This may take a while. Thank you kindly.

When you say: "first - I would treat this like a clocking in/clocking off procedure and have a table structured like this process, event code, date+time" Do you mean "process, event code, start date/time, AND end date/time"?

I want to enter start times and stop times for each process done on multiple production lines. The data to be entered includes: StartTime, EndTime, and ProcessCode (Process codes being: "producing", "down time", "lunch time", "changeover", etc.) We want to see where the time is being spent...

I finally found the answer!: http://answers.microsoft.com/en-us/office/forum/office_2007-access/can-you-automatically-alphabetize-data-in-a-forms/f98d4f8c-23d0-488e-a6cb-089a85041eeb

I'm a little lost. Trying to remember how I did this. I've attached images of the combobox on the form; and also the properties of the field.

Well, I looked at that Record Source property before I changed it and it referred to the table. So I tried using the line you gave me but changing the name from the query to the table. Is this what you're asking?

It says the record source does not exist. So I tried placing brackets? Still get the same message . . .

I have a combobox on a subform with a recordsource from a query. The query includes 2 tables - Toppings and Toppings_Items. I am assigning multiple toppings (subform) to an item on the form. The hiccup is that I can't get the combobox to sort by the part/topping description. It is sorting by the...

If you didn't want to help, why not just say so from the git go? I obviously don't have the knowledge and expertise that you do. And I have googled and looked at various other websites and links. I came here because I thought this site was a resource as well - where smart people can help out us...

Please also keep in mind that these reports are all based on a query that is asking for an Item Number.

Some guidance please . . . where do I find the docmd.output? How do I "list the whole bunch of them in some VBA? (Just a novice here.) Thank you!

Ok, so I'm working out of a backed-up database copy. I changed four of the forms to reports (by "saving as"). I question how to successfully print all these reports from one query since all of these "reports" are designed VERY differently. I have two of them attached for your reference. I'm...

I checked out that link and see that it is an easy process to change a form to a report; which I will look at doing for all the forms in the database (with the exception of those that really need to be a form). Anyway, I have just 2 questions: - What happens to a form that it would come back to...

May I ask how this can be a problem?

I respect that advice however I am not in a position to be able to change the forms to reports at this time.

Forgive me if I'm not explaining clearly. Shall I try again?

I am printing forms rather than reports (they are not editable and used for viewing data). The "form" was just a vehicle to use to show the data (by query) of everything needed by the operator. Anyway, the forms are printed by, and different based on the, department to give them the information...

I have forms that are printed based on a query parameter of [enter item number]. There are several of these forms that I would like to print at one time (with one command) making it easier for the user to gather their information at the beginning of the day. I also don't want to lose the ability...

This is most helpful. Thank you again. I will most certainly check out that tutorial. (Wish I had an image of a humble smiley to go right here!)

I want to get me some of that coffee!! YOU ROCK! Yes, this is exactly what I needed. I was looking at what you did. I see there are no events at the control/field level. There is just the one event on the On Current property of the form. I know virtually nothing about code - can you help me...