Search results

I probably should have done a better job of describing the tables. Here goes: Data Storage Table: ID - Autonumber, key field Factory Order - Identifier of the job as it moves through the shop Operation - The step the job is currently at (010, 020, 025, etc.) Part Number - Which part we are...

Oh, and if anyone knows of a job that involves designing things involving Samurai Pizza Cats, please let me know so I can put in my application. :)

Sorry - I'm used to dealing with manufacturing folks. :) SPC is Statistical Process Control. For the purposes of this project, I need to store measurements and then look at past data for trends. If one of several conditions are met the data point is flagged as unusual. The traditional...

From some discussion in another thread (http://www.access-programmers.co.uk/forums/showthread.php?t=266376) it was suggested that I post a question here regarding table design. Attached is a copy of my DB. I'll mention right now that this is half-completed (if that). The short explanation of...

OK - I'll post something in the Tables forum after lunch regarding the normalization. I don't write many DBs, so I'm sure the design isn't ideal. However, I'm still puzzled as to why a simple function like this subform isn't working correctly for me. I've done similar things in the past...

OK, I guess I'm missing something. I have three tables: The Data Storage table is going to keep the "header info" for the SPC data that is collected. The Measurement Storage table has a Parent ID field that shows which Data Storage field it belongs to. The actual measurements are stored here...

Here's the DB. The data storage DB is just intended to hold the data, and the SPC Data DB is the one I'm having trouble with. The particular form that is causing trouble is "SPC_Data_Entry_Display_Form". There is only one subform. To test the main form correctly, it is intended to be...

It is set at No. For reference, during my first attempt at this I shut off access to some functions that I didn't want the user to have. After it didn't work, I played with those settings (Allow Additions, Allow Edits, etc.) to see if I could sort it out - no luck. Then I deleted the whole...

Yes, I can edit the tables by opening them directly and typing in the data.

Yes. I can edit as needed in the subform only.

OK, I'm having a lot of trouble with this today. Hopefully this is a simple fix. I have a form (SPC_Data_Entry_Display_Form) based on a table (Data_Storage_Tbl). Each of these records has info about when and where a measurement was taken. I want to record the measurements in a separate table...

I'm cross-posting in this forum since I haven't heard anything in the VBA forum yet: ___________________________________________ Hey there. I recently upgraded a DB from 2003 to 2013 and ran into the following problem. I have a button that opens a file dialog box and allows the user to...

It looks like you're on 2010 - have you had any reason to try it on 2013? This worked fine for me until we upgraded.

Hey there. I recently upgraded a DB from 2003 to 2013 and ran into the following problem. I have a button that opens a file dialog box and allows the user to upload a file to a predetermined location (and store the address as a hyperlink). I borrowed this code from someone else on here and...

OK - I lied. I apparently didn't test the other button well enough. Sometimes it seems to update all of the records, other times only the one I had most recently selected. So both buttons don't work (which makes me feel a little better), but I still don't know if there's a good way to do what...

Hey all. I'm back again. I have a main form and subform set up where the main form shows a work order and the subform allows the operator to enter various materials required. I'd like to set up a button to print up a purchase order for all of the items entered, then set the "order date" for...

Thanks all - I think that'll work for what I'm trying to do. Now I just need to figure out the rest of the database. :)

Sadly, I only have MS Access 2003 - can you save it as an older version for me?

Thanks - it should only be one file per record, so I think the method you described should work. I was a little unsure about the FileDialog, though - and when I tried the example from Microsoft.com it gave me an error. :( But, I think something along those lines will work for me if I can get...

I'm not sure if this is the correct place to put this, but... I'm going to be creating a database where one of the functions is to provide access to a certain file associated with each record. I'm using Access 2003, so I think I want to link to the files rather than store them directly. So...