Search results

So If I were to take the hyperlink option, how would I open the path that met all 3 criterias?

I got the cascade working, Now I just need the attachment part :D

My reason for using the attachment field is I felt it would be easier down the road for other users to add manuals to the database without the risk of storing the file in the wrong folder or adding the wrong hyperlink to the database.

Hello, I have 4 Tables tblPumpManufacturer PumpManufacturerID PumpManufacturer tblPumpModel PumpModelID PumpModel tblPumpManualType PumpManualTypeID PumpManualType tblPumpManuals PumpManufacturerID/PumpManufacturer (Lookup) PumpModelID/PumpModel (Lookup) PumpManualTypeID/PumpManualType...

Hello, I have a continuous form that shows a list of Preventive Maintenance Tasks (frmPMTasks) I currently have a report that will print all tasks or all tasks that are due but what i would like is to be able to select certain tasks with a check box or something similar and generate a report...

Hello. So i am having difficulty making a table design for a work order form. On my form i have a combo box, cboEquipmentID. This is where the user will select the piece of equipment that the work order will pertain too. My equipment could be anything. all equipment is stored in tblEquipment...

I did it that way because I have 10 different types of equipment and they all have different fields for details, maybe 30+.

So i have 3 tables. tblEquipment EquipmentID, EquipmentName, EquipmentType 1, Reactor 1, 1 2, Vehicle 1, 2 3, Tower 1, 3 TblEquipmentType EquipmentTypeID, EquipmentType 1, Reactor 2, Vehicle 3, Tower TblReactorDetails ReactorDetailsID, EquipmentID(from tblEquipment), EquipmentDetails1...

Never mind I got it figured out by reading more into what you said. cboUtilitySubType was the name of the field and not the data. The data was UtilitySubType. That fixed it thanks,

I tried this but it asks me to enter a parameter value for cboUtilitySubType. The field is the correct name but it does not appear on the first form. Only the second.

I tried the following code but got an error. Run time error 13 Type Mismatch. DoCmd.OpenForm "frmEquipmentList", , , "PlantNum = " & Me.cboPlantNum And "cboUtilitySubType = " & 1

Hello i have a search form to open up a continuous form. my search form has 1 combo box. cboplantnum. my continuous form has 2 fields [PlantNum], [cbosubUtilityType] I would like to filter the form using a WHERE function. I would like to filter by cboplantnum on the search form AND also...

Nevermind. I found out how to do it using the following VBA Code. Private Sub cmdSearch_Click() Dim strFilter As String strFilter = "([EquipmentType]=" & Me.cboEquipmentType & ") AND " & _ "([PlantNum]=" & Me.cboPlantNum & ")" Call...

Where exactly do I input this information Ranman?

Well one of my problems is that sometimes the finished product is also a raw product for another finished product. I found it easier not to duplicate data this way.

I have 1 Table. tblProduct Field 1 - ProductID Field 2 - ProductName Field 3 - RawProduct1 Field 4 - RawProduct2 Field 5 - RawProduct3 I input finished products & Raw products in the same table. Raw products are used to make the finished products. I have a search form that opens...

I have a small search form with 2 combo boxes. cboPlantNum (tblPlant) Field1 - PlantID - Field2- PlantNum cboEquipmentType (TblEquipmentType) Field 1 - EquipmentTypeID Field 2 - EquipmentType I have a search button (cmdSearch) that opens a continuous form with a list of equipment. I would...

I don't usually do this but I chose to for this one instance. I had to mass input data with a sub table and found it easier to copy and paste a lot of information this way.

The column properties look good. They also save when I close the table. The problem is the column count and the row source will not save as the respective table/query.

I have a split database. 2 tables. Table 1 (tblForklift) ForkliftID ForkliftOwnerShip Table 2 (TblForkliftOwnerShip) OwnershipID ForkliftOwnerShip Table 1 Forkliftownership is a combo box and displays the correct columns in the back end, but when i go to the front end it will revert back to...