Search results

Hello, I have a text box "Txt1" And multiple Combo Boxes "Cbo1" "Cbo2" "Cbo3" all on a form "frm1" The combo box options are 1 = Yes, 2 = No. I would like it if either cbo1, 2 or 3 are "No" or "Null" then txt1 will be disabled. This would change as the combo boxes are changed. E.g The...

Hello, I'm having an issue with my report where the page header appears on the last page even though there is no detail on the last page. How do i hide this header on the last page if the detail section on the last page is empty?

I do see it if i look at the plain text format. But this doesn't seem practical for large amounts of information. Every line item has the code and it could vary from source to source. Is there not another way within the coding that when text is entered into the text box it will automatically...

Hi, I have a form that uses a memo field with rich text. I would like to use rich text so i can keep the correct formatting (Paragraphs) from my copy+paste source, but i do not want to use the font the source uses. I want to use the Font in my form (if needed) so when i generate my report it...

Hello, I have 3 combo boxes that filter one another Sql of last combo box SELECT TblEquipment.EquipmentID, TblEquipment.EQUIPMENTNAME, tblPlant.PlantID, tblEquipmentType.ID, TblEquipment.PSMRMP FROM tblEquipmentType INNER JOIN (tblPlant INNER JOIN TblEquipment ON tblPlant.PlantID =...

My only problem with this is if i make changes i have to edit 2 reports each time. Also it is a report that has multiple sub reports.

I have a report that is generated from a form that i want to serve 2 purposes. 1. I filter the report based upon a record which i can then view data or print. (I have this working) 2. I click a button which opens the same report but in this case all the fields are blank which will allow me to...

Hello, I have a database that generates purchase orders. Currently the PO has a generic name "Purchase Order". I currently use the print preview feature to attach the report to my outlook as a .pdf file. I have a text field in my report name [txtPurchaseOrder] I would like to attach...

Works great, thanks.

Ok let me take a step back and try another situation. I would like to open a form this time. If I select the year 2013, I would like to open my form [frmResults] where all records of [ResultDate] are between 1/1/2013 and 12/31/2013. if 2014 then between 1/1/2014 and 12/31/2014 etc

I have a tbl with the following fields [tblTask] TaskID,TaskDate, Task I have a search form a combo box filled with years, cboYear 2016 2017 2018 etc.. I have a report that displays tasks with a date field on it which takes data from tblTask. [TaskDate] There will only be one Task...

Hello, I have setup a brief example in excel to show what i would like to achieve in access. I need a table that would store all data on a test related to the same pieces of equipment every year. Each year we will perform said test with a form that access would generate on a report to carry in...

You are correct, I am currently adding the M or P onto the end of the number, but only in my PO form and in my report. I have a lookup form that will only display the PO# without the M or the P in the drop down combo. I was asking if its possible to display the M and the P in the drop down list...

I have a form [frmPOLookup] with a combo box [cboPOLookup] that looks up purchase orders by [OrderID] I have 2 different purchase types. Maintenance and Project. On my purchase order form i run the following code which generates a PO# based on what type of purchase it is. Private Sub...

I see there are many ways to skin this cat. Thanks all for the input.

I'm sure this is pretty straight forward but i can't figure it out. Im getting a compile error, Block if without end if on the following code Option Compare Database Private Sub cmdOK_Click() If Len(Me.cboPermitType & vbNullString) = 0 Then MsgBox "Please select a Permit Type"...

Nevermind, got it!

I added that but I still get the same error.

S:\CST MAINTENANCE\Maintenance Database\Saved Data DO NOT EDIT\Attachments\Manuals and specs\Pump Manuals\Pneumatic\Yamada\Owners Manuals\NDP5-15OM This is my path.

Well I don't think the Link option is going to work for me. I have it working BUT every file I try to open gives me the following response Run-time error 53 File not found My files are all saved on a shared drive across our network along with the split database. From the research I...