Search results

Code is not working Whether "No" is in quotes or not in quotes - No Private Sub cboEstID_BeforeUpdate(Cancel As Integer) If Me.cboEstID.Column(3) = No Then MsgBox "Inactive items may not be selected" Cancel = True Me.cboEstID.Undo Exit Sub End If End Sub

My column #2 is my model number, #1 is the ID and width is set to 0, so #2 is what shows on the form, how can I sort on the Active Flag first and still keep the model # as what shows on the form once a record is selected. Thanks

Problem solved by MS access updates

I am not sure what has caused the issue but I am pretty sure it is either a MS windows 10 update or a MS Access 2016 update, but my application has stopped allowing multiple users to connect to my backend. has anyone come across this and if so found a solution. I need help quickly as this is...

Thanks

Cool, I will give it a try but I have one question - What if I want one extra printout, so if Qty is 4, the query will produce 5 records?

Thanks I am going to give it a try in the morning.

Pat, did you look at Arnel’s database he posted. I am not seeing what is wrong with it. Can you expound on your method please.

Correct

Thank Pat, I will take a look, Arnel's query definitely doesn't product a 100 plus records though. So maybe this is not in my head straight yet. Thanks

Trying to print the page for the current item in the report as many times as the quantity listed on the order so I will have a copy for each item being produced. So if Item 2 has a qty of 4 then the report should print that page four times. I believe Arnel has already shown me the way, I'll...

Hold on :) I think i am getting it.... Just run the module to create the long table - correct?

Thanks Arnel, still trying to decipher all of this :) Trying to figure out how the code in the module is entering into this setup. Do I just make the Table tblCounter as you have done and create the cartesian query? I can't figure out where the code is running to insert into the table

I have a report that I need to print out for each record on a quote, the problem is that I need the report to print duplicates for each line item based on quantity. So if Line 1 has a qty of 1 print one copy, line two has a qty of 10 print 10 copies for that item, ect. Having trouble getting...

I have a quote form that looks up a product we build to get all the pertinent info from such as price and description. The combo box then takes the ID for the product and saves it to the quote table, the drop down list is based on the products table and only shows active products so someone...

Yes sir, but the damn column of numbers and the sum total field are on the same form. That’s what’s got me stumped.

Oh darn it, I forgot to mention. Dbl click on any quote to open. Then look at the quote form. Sorry

Ok, Here is my DB, when you open click on quotes and look for the error on the top left of the order details subform. This one has me stumped.

Yes I found that, but o am actually trying to show the total from the form on the same form in the header. Just not working for some reason.

Tried that too - should it work that way? I am using the builder so I know it is not a typing error. I am stumped.