Search results

I found my answer. Amazing what the brain doesn't comprehend so early in the morning. I used the macro line "SetProperty" selected the object, and set visible = -1 and it worked fine. =)

hello I have a switchboard that has 3 buttons. New PO - Opens frmMAIN in Add Mode Edit PO - Opens frmMAIN in Edit Mode Close PO - Opens frmMAIN in Edit Mode, but here is my dilemna. (frmMAIN has a hidden control fldCLOSED where visible is set to false when form loads) When the user...

What has happened is the database I was given to clean up is a purchase order database where now they want me to make a modification and I have searched the boards for a couple days now. In the current ways, the vendor is selected in the combo box, and then the part number populates and is...

Hi. In the below picture, my field that says Vendor is cboVENDOR. Using cascading combo boxes, when the user selects the Vendor, the next cboPN shows the part number. I am looking to find a way to show the 2nd column of cboPART in the text field(Text 17) after it, which is called txtDES. Here...

Hey quick and easy question. I am able to sum the subform, but I have 2 fields called txtSHIPAMT and txtTAXAMT, which may be $0.00 alot. I am trying to sum the subform and only sum the ship and tax fields when they have totals in them. Do you have any suggestions? Thanks Here is a picture...

Hello. What I have been tasked to do is create a purchase requisition database. I have 2 forms: Main form - frmMAIN Subform (datasheet view) - frmDETAILS The frmDETAILS shows part number, qty, cost, etc. My Issue is while the frmDETAILS is connected to frmMAIN with the frmMAINID, I...

Hello all: I have a report which is used as a quote letter. This is split into 3 pages with breaks. The first page is my letter, which has the quote number generated from the Quote Table as well as address information, etc. The second page shows standard terms and conditions (i.e. company...

Thank you for your advice! I appreciate it!

Hello. I would like to know if using a select case statement would be more appropriate than an If Then statement. I have 3 fields in a form. fldDIST fldADDRESS fldCITY I would like to make it where a user cannot see the submit button until all three fields have entries or are "not null"...

Would anyone be able to suggest a way to open a report based on a combo box selection? I have a combo box which has 2 values, "Net" and "Rebate" If a user selects Net and clicks on the submit button, it would open the report, rptNET. If they select rebate, and clicks on the submit button...

I have a report that is a customer quotation, which is based on a query. In the query, once of the fields pulled is fldSIGNATURE, which is a link to the path of an image on my network of the quote originator's signature. I would like to be able to print out the report based on this image. I...

Hello. I have a database for creating customer quotes for our products. I have 6 inside sales reps. I have a different report for each inside sales rep. For example, rptREBATEkbr is for 1 user, rptREBATEkws is for another user. Is there a way to open a report according to the user? For...

Hello: I know how to populate 2 combo boxes that are unbound, but would like to know how to populate a combo box based on a text box that is bound. My code is: Me.cboOEM.RowSource = "SELECT fldOEM FROM" & _ " tblOEM WHERE fldDISTRIBUTOR = " & _...

I am currently working with a database which performs a crossover from a competitor part number to our part number. The current process is: 1)Chooses the competitor name from a drop down 2)Chooses the competitor part number from a secondary drop down 3)Our part number shows up in a...