Search results for query: *

thanks, i didnt want it to come to a query. But it is the easiest way. Thanks.

seems like it would work, but basically i just want the subform to be sorted after I close a parts order/edit form.. anyway I can do that?

ya but can I get a control on the main form to activate it to automatically sort?

Hi, basically I have a couple tables in subforms that track parts that have been ordered under the main order number. What I basically need to have happen is automate the ability to right click the column heading and sort ascending. Anyway to do this through vba?

So I have a Parts List Table that is populated and grouped by part orders and their distinctive vendors. What I want to do is have the purchaser have the ability to add an extra item number associated with that part number. The thing is I need it to add it to multiple entries... or I would be...

Hey, I have a combo box that allows a person to select their name, but stores a given password for that person. I want a message box to pop up and ask them to verify their password. If it does match, then display the details and add a new record, but if not... close the form. Can I do this?

bitchin, thanks guys.

alright well it liked that but its not doing anything with this code. Private Sub A_E_Click() Me.Form.Filter = "[Vendor's Name] Like ""A*"" or ""B*"" or ""C*"" or ""D*"" or ""E*""" Me.Requery End Sub

[Vendor's Name] Like "A*" or "B*" or "C*....."E*

i kinda get it, but how did they set the filter... VB doesnt like my quotation marks.

Scenario: I have a continuous form with a vendor list... alphabetized by the vendor name.. I want to create 5 buttons that put the list at the first letter in the button... so if the button L-P it would go to the first record taht starts with L. Any ideas?

thanks remou

Thanks Remou The problem with the validation code is that It will correctly check the first one, then after data entry of the first one... you click on it again and it wont show the msg box for the other one if it is blank... but it wont close.. so i know its working...if i do fill it in, it...

If I just want to require entry into these to areas I should do this right? Or am I missing something? If Me.[Justification] = "" Then MsgBox "You must Justify this Request." Cancel = True ElseIf Me.[Order Summary] = "" Then MsgBox "You must enter an Order Summary." Cancel = True...

Ginger, you are awesome and thanks for the prompt reply. Thank you for that angle.... works now.. I figured it out... Now onto the Username Problem.

Ginger, It works now... Heres a new predicament... When I email a this report I run a macro based on the username they have on the main screen... The macroname is the same as their username and will send the same report I used for the print preview but now that query that the report is based on...

I like that approach, I get runtime error 3075 "syntax error(missing operator) in query expression '(Requisition Number=34642)'" what am i missing?

Problem 1: I have one report that gets emailed to other people on my network. That report is based on a query that reads the "requisition number" on either the "NewReq" form or the "EditReq" form.... It does work the way I want it to, but when you ask for the report the query prompts for the...