Recent content by reneelacks

The sites are warehouses where the products are stored. Products are Manufacturer specific, and each product contains its chemical list. Locations now need to be added, (i.e. MotorOil DW30 is stored in 3 different Warehouses (Sites), but the specific location is different in each warehouse...

I'm creating a database that shows what I thought were simple relationships, ex. Manufacturer w/many Products; Products w/Many Chemicals and a drop down box in the PRoducts table to select multiple sites where the products are located. This has worked well until I was told I needed to add Site...

Worked like a charm!:D

@ Namliam - so why does it work when I leave out the parameter?

its an integer in the format YYYYMMDD.

The expression says if the WO has not closed (=0), then count the number of days it has been open thru today, otherwise count the difference between when it was open and when it closed. I then used >30 as the criteria as I only wanted to see Work Orders that had been open longer than 30 days. I...

When setting the criteria for the following expression to: >30 to view any Work Orders that have been open for 30 or more days, the results display perfectly; however I want the user to be able to set the Min # of Days.. when I set the following Parameter: >[Enter Min # of Days Open] ...and...

:banghead:i've created a database with multiple subforms within the form; however some of the subforms randomly appear and disappear for no apparent reason. Has anyone experienced this before? Please Help!

Sorry should've looked at the other threads first! Got it

Hello, I needed to update two tables (one of which is linked to my company's main database system) and the 2nd which I created in Access. The only way I could get them both to update was to use a subform; however I'd like to set up the form to look very similar to the paper copy they're used...

Veh# Year Make Model $ Req# PO# 031158 2003 CHEVROLET CAVALIER $13,866 981413 1998 CHEVROLET CAVALIER $13,866 042538 2004 CHEVROLET G1500 $21,580 I hope this looks a litt better

Table1 ID Veh# Year Make Model $ Amount Accepted Req# #PO #2031158 2003 CHEV CAVALIER$13,866$13,866 39814131998CHEVROLETCAVALIER$13,866$13,866 40425382004CHEVROLETG1500$21,580$21,580

Table1IDVeh#YearMakeModel$ AmountAcceptedReq# #PO #20311582003CHEVROLETCAVALIER$13,866$13,866 39814131998CHEVROLETCAVALIER$13,866$13,866 40425382004CHEVROLETG1500$21,580$21,580 This is my table, I'd like my form to.... Load Make, model, etc. when Veh# is entered, and allow the Req# and...

a table Im using to input data ... (to be appended to another table) vehicle

I'm trying to add records to a table using a form. Some of the information is pulling from a table that is linked to another table to show existing data. The form will not allow me to add records.... help.