Search results

Hey Fijian, here is a dummy Access file zipped up with the basics of how I do weighted averages. It includes tables, queries, forms, and modules. Hopefully you'll find something useful in it. The 2 "XRF..." tables hold info/data that the weighted avg is calculated on. There is also some code in...

Fijian, I do a weighted avg for shipping mixed lots of materials, each lot having their own chemistry. To do this I set this little calculation in a Module: Function WEIGHTEDAVG(X, N, T) ' Where X is concentration, N is no. of pallets per crushing lot, ' and T is total no. of pallets...

Rif :d :d :d

If you want a form that is in Datasheet view, but with command buttons, you will have to make a blank form, put your command buttons on it, then add your data form to this "blank" form as a subform. I set up and use a few of these for my stuff, and it works well.

That is pretty much what I did for an exercise application I did with 2 continuous subforms on a main form. Worked like a charm.

I would look at something like a command button on your sample log form that could be clicked on to automatically make an entry on your sample log form. The button would be set up to select from a list of RM's. I don't know enough about your process to tell you exactly how to go about it though...

I would second the blank report/drop needed reports as subreports option. I had to do something similar for showing a variety of test data reports onto one report, as a neat summary. This worked pretty good.

Gemma, in manufacturing, there are untold instances of a customer ALSO being a supplier. Example: Gemma's Custom Chrome Shop is in the business of selling chrome plated parts and does its own chrome plating. Gemma's happens to have GM as a customer. GM has contracted Gemma's to buy...

Wow.:confused: Chris, thanks for putting up the samples, they are well done.

Given Monday's round, of golf that is, I concur. That being said, I enjoy playing the game 99% of the time, even though I go round and round with it. Definitely a game that demands practice of the entire skill set, in order to excel. I take it, from your posts Rich, that you do not care for...

Ah. Round of golf Round of drinks Round we go

Huh? What did his post have to do with drinking?

GML, thanks for the tip. You're right about leaving the driver alone for that, and I can see the wisdom in that. This scramble is for work, so I don't think I'll be able to share bragging rights with ya, but I still thank you. My main problem is playing enough through the year to get...

Probably no more coaching than is needed to kick a much larger ball into a huge net :rolleyes: :D . I appreciate GML's vantage point, but I still think there are more than a few golfers out there who are all about the money. I used to really like Fred Couples until I read an interview with him...

Matt, I'm attaching an example of what I talked about in your last post on this subject. It is a simple data form. As the user cycles through the textboxes, inputting data, they have to enter a location where the sampling took place. When the cursor or focus goes on that textbox, a popup form...

Look in the Sample section of these Forums. I put one together and posted it earlier this year. Another poster also put theirs in that post, so you can get a couple of ideas. Look for the last one or two examples posted; one is in Access97 and the other in Access 2000. This will at least give...

Bet he figured the same thing.

Bob, won't you have to define column headings in the properties of the crosstab query to get any headers for the report?

Chad, are these inspection results in a regular format (I mean, is there a set list of words for the result of a test)? If so, an update query could fix the table of results.

Matt, this IS possible, but it may be pretty tedious to work out. I've seen examples (in here, I think) of a tooth chart for a dentist's application that worked similar to what you want. I did something similar as well, for an industrial hygiene app. We needed to note air sampling locations...