Search results

Well, I made a simple quality database which recorded inspection results. The database evolved over the past two years into a system which logs everything from furnace performance to shipping orders. The database has over 100,000 records now and it’s eating up the system resources on the lab PC...

I’m interested in updating my current Access database to a standalone VB app which connects to the MS Access database. Is this a good idea or should I go with SQL Server and VB.Net? Does anyone have a book recommendation for MS Access with VB.NET?

I figured it out. I made two queries one with case inspections the other with only hardness inspections. Created two sub reports, one for each query, linked part ID as my child then placed them side by side. Cross tab would not work since I needed to reuse the data for different math functions.

I have a report which lists a summary of “customer parts”. Don’t ask me why but my boss is bugging the hell out of me to change the format of this report to display the spec high and low, Stdev, and Avg on only ONE horizontal line per part. As you can see if a part number has two or more...

How do i update a table with a value inside a text box? This is what i have . CurrentDb.Execute ("INSERT INTO tblCUSTOMER ( CUS_NAME ) " & _ "SELECT " & Form_PUSHER1_LOGfrm.TextInsertNewCustomer & " AS Expr1;") AND CurrentDb.Execute ("INSERT INTO tblCUSTOMER ( CUS_NAME ) " & _ "SELECT...

Works, unless the time difference changes from PM to AM =(Format([PUSH1PRODUCTION_TIME_TUB_STOP]-[PUSH1PRODUCTION_TIME_TUB_START],"hh")*60)+Format([PUSH1PRODUCTION_TIME_TUB_STOP]-[PUSH1PRODUCTION_TIME_TUB_START],"nn") 1, start = 4:10 AM stop = 5:00 AM Total = 50.00 correct 2, start = 5:05 AM...

I have two text boxes which store medium times (hh:mm Am/Pm). How can I calculate the time difference for these two medium times (Start = 11:00Pm, Stop = 12:15Am = 75 minutes)? I know the time difference will never exceed 24hrs. So I don’t need the dd/mm/yy. Could someone point me in the right...

thank you True, but I am creating redundancy and I just don’t see the need of having a JOB_HISORY entity when history data is stored in the PLACEMENT entity. Unfortunately I am asked to create this history table which I cannot think of anything useful to store in it. I know sometimes rules have...

For my job history entity should I just store my placement number and remove the candidate number? Since placement number already determines the candidate number in the placement table.:confused:

I apologize for asking this question. I have searched all over these forums and on Google. I’m looking for a function that decrements the current date (by day only) based on a single integer value. For instance, today is 8/28/06. A user enters 5. The return is 8/23/06. I’ve looked into...

Seems like it would work but once i exit the last field inside my first subform I get this error. run-time error '2465' Microsoft Access can't find the field 'SubFrmtblCarbon' referred to in your expresion :confused: EDIT: GOT IT! here is the code ran after last field is exited Private Sub...

thanks Thanks, I'll give it a shot at work tonight

How do you tab out of one subform and into another from the main form. I have 3 subforms and after a user is finished entering data into the main form the first subform sets focus. After data is entered into the subform it’s impossible to hit the “enter” or “tab” key to move onto the next subform.

thank you Ok I removed all unnecessary indexes, fixed the circular relationships, and renamed my foreign keys to correspond with the PK. Thank you for the help =)). :D

thank you Thank you I’m looking for this selection under tools->options but I don’t see anything about creating an index. I have looked under all the tabs. I redid my forum so everything is updated through subforms. What about table normalization dose everything look ok? :)

I’m working on a new database which will record furnace logs for a heat treat company. I did my best to normalize the tables. I’m trying to add new records through a select query which updates multiple tables. My problem is I don’t believe I did that great of a job normalizing the tables because...

I have a list of inspection types but the result for each inspection is a user defined numerical answer. That’s where the problem is. Say a user intends on inputting 38.9 and makes a typo and 389 is entered. I’m looking for a way to check the inspection result and see if the result is less...

I’m designing a database for a metallurgical lab. Everything works fine except I have nothing in place to check for typos in my inspection results field. With 15,000 records added in the past 2 months it’s very cumbersome fixing errors when a PPK report needs to be printed. My approach is to...

note Note: When database is opened it auto hides the access program. When opening the database hold down Shift

I want to add a filter search on my forum which will look up load numbers based on the selection from 3 other combo boxes. I already have two combo boxes; Customer & Load. When the user selects a customer the Load combo box grabs all load numbers from the database with this customer name. I...