Search results

I was looking for the text. Thanks :)

Is it possible to manipulate the transparency % of fore color in a text box? Also is it possible to rotate this text box at say a 45° angle?

I have 3 tables [Table] "Field" [tblplant] "ID" "Plantnum" [tblboiler] "ID" "boilerName" "Plantnum" - Lookup tblplant [tblProduction] "ID" "UnitName" "PlantNum" - Lookup tblplant I have a form with a 2 combo boxes. cboPlant. CboEquipment. I'm using a union query to populate boilername and...

Ah good idea. I never really thought about splitting my tables. I always put everyone on the be.

Hello, I have a project i publish with updates every so often that i keep in a version history table. The format is "Ver 1.0.0". Currently i use a text box that displays the latest number from my table and shows it to the user so they know what version they have. My issue is that when i am...

I tried this but maybe I am doing something wrong. I am trying to filter combo box [CostCenter] on [frmorderline] with the selection made in combo box [Purchasetype] on [frmorder] I put this into [frmorderline] Sub CostCenter_AFterupdate() Me.Filter = "[PurchaseType]=" & CostCenter...

Hi, I have a combo box on a subform that i would like to filter the results from the choice made on the main form. I have done this successfully with 2 combo boxes on a main form using the query [Forms]![frmOrder]![PurchaseType]. But the subform doesn't seem to work the same. My subform name...

Ok i got it. Damn me and my pea brain. I added this. DoCmd.Close acForm, "frmworkorderrequestnew", acSaveYes DoCmd.Close acReport, "rptNewWorkOrder", acSaveYes

Hi all, Here is what i have. A form (Pop up) [frmworkorderrequestnew] to enter data with a submit button A report [rptnewworkorder] that takes the data from the form (With a query and this in the criteria for workorderid [Forms]![frmWorkOrderRequestNew]![WorkOrderID]) The goal is when the...

Well I have multiple tables that include different pieces of equipment with different kinds of information tied to each of them. I then have a work order form that I select a UnitID(Piece of equipment) for a tech to go work on. air compressors, boilers, chillers etc.. each "Type" of...

Is it possible to take a field from 2 separate tables and show both sets of values in ascending order in 1 single combobox? I would rather not combine these tables which is why i ask.

I tried this but I still had the same problem. I also counted my characters that are displayed on the report and I have 251 showing but I have 1125 I need to display. I changed the field in my table to Long Text and remade the textbox with the new field on my report but it's still showing 251...

Yes i think i can do this. I thought it would be easier to keep track of, but this may be the answer.

I 4 different tables with 4 different types of measuring instruments. Pressure, Level, Flow and Temperature I then have another table (Vessels) with a VesselID that each instrument pertains too. Each instrument table has a VesselID field lookup. I have a form with tabs, each tab for a...

Hello, I have a combobox on form1 that displays values from field1 in table1. I would like to record the selection (Control Source?) in field1 from table 2, 3 and 4 Is this possible?

So I got to thinking about this a bit more, and I think for the future of my database it may be better to store them as attachments. It will be easier for someone else to add and edit without me having to add more code for every manual that may get added later. I have attached an example of the...

I have a form that i copy text into from a PDF which then generates a report. I'm having an issue when the PDF displays the text on different lines. When i copy this into the text box, it displays it as it was when i copied it (I have to scroll down the text box per line) The issue is that...

Yes, but each model could have 3 manuals each. (different or some the same) I guess I would need a line of code for each variation? if type = 1 and model = 1 open a1 if type = 2 and model = 1 open a2 if type = 1 and model = 2 open b1

If you chose model PD10P it would open a different PDF depending on whether you selected owners, parts or spec manuals. They are all different.

I have attached a sample database.