Search results

thank you sweet!:) Thank you:D

I was wondering if this was possible. I did a search on Google and on this form and I could not find anything. Is it possible to display a form without displaying Microsoft access in the background? In other words I would like to display just the form alone with access running or if possible a...

I could not get it to work. When you enter a new customer name it won't show up in the subform. BUT, if you close the form and re-open it the new customer name displays in *both* subforms. I tried the requery & refreash options as well with no luck. So i came up w/ a generic solution. Since...

Thank you Thank you:) I work 3rd shift and i just got home:eek: ...very tired lol. I will try to fix this error when i wake up and I'll post my results ;) Once again, thank you for the feed back:) Chad

Modules & VBA Note to admin/moderator: Could you move this thread to Modules & VBA? Thanks, Chad

I have a customer subform on page 2 of my inspection log. A combo box at the top allows the user to lookup customers based on name. My problem is after I enter a new customer and part number into the database it shows up in my combo box but I cannot get my two underlying subforms to pull up any...

I have a quick question, My employer asked me to just produce a Cpk result on each part number, not a graph or report just a calculated field in the results form which will display the year to date Cpk on each part number as you scroll though the results. I Know how to make a calculated field...

That makes sense; I have a new table called “tblLoad” which has loadID PK, logID FK, and load. My new form is using queries for data entry which is based off each table. InspectionID is now incrementing when I place it inside a subform on the main form =)). I used lookup fields for the tables...

This is the new layout w/ furnace and acc/rej table. I also made a simple forum for the log. EDIT I worked on the queries Take a look @ QueryInspectionLOG (Chadproject2.zip) Shouldn't inspection number increment everytime i enter a new inspection?

Sorry for the delay, I work the 3rd shift and I stayed over and slept the second half of today. For the moment we are still using the hand written log book. I was granted 2 months for this project since I go back to school next week. Right now when we check all 24 sample pieces we write down...

samples Yes and yes, we receive multiple samples and sometimes do multiple inspections on each sample. We receive 3 GM Truck shipments a day (we have hundreds of customers; GM is just one of the biggest). Each Truck contains 30 to 40 tubs of transmission pinions. Each tub (containing 40,000...

thank you That makes more sense. Having a results table also allows multiple inspections on any given part number with out having to create different inspection tables with “checktype1” “checkype2” etc etc. That makes perfect sense now. Thank you! Drop me another line I’ll be happy to answer...

One more question… I was over looking my design and I think the most appropriate way to design my form is by having the main log table in the default form then once the log info is entered; the subform containing the inspection table is loaded tblINSP PK = tblLOG PK. This table will contain...

The inspections require a set test of attributes, entered by the user. Our total/effective case depth results range from .000 to .099 thousandths of an inch. RC, RB, R15N, R45N, and Birnell results range from 0.0 to 100.0 depending on the particular check. The only pass/fail test we have is MFH...

Wow, thanks allot! I cannot describe how much that helped. I plan on reworking tables tonight. My main problem with the inspection table is different parts require different inspections. I don’t want a table with 10 different columns for each inspection type. This would cause blank fields and...

I am converting a log book over to MS Access. The log book contains information on inspection results for a metallurgical lab. I have one problem w/ my “inspection table” which I will explain later in the post. This is the plan I am using to figure out my entities and attributes for the...