VB Code:
DoCmd.OpenForm "FreightProvide rMatchFrm", , , "ShipperCode1=' " & Forms!CurrentLo adListFrm![ShipperCode1] & "'" And "ShipperCode2=' " & Forms!CurrentLo adListFrm![ShipperCode2] & "'"
This code works if you only include the first ShipperCode1 and leave off the second ShipperCode2. Any ideas as to how to add more than one variable.
jjstevens
Last Activity: Aug 16 '07, 04:18 AM
Joined: Dec 3 '06
Location:
-
Any idea why I am getting a Type Mismatch error after entering the code above?Leave a comment:
-
ShipperCode is not a number it is a code like this: "ABC-ABC-" How would the syntax change for this type of code.Leave a comment:
-
Here is the Where Statement I came up with, Can someone tell me why this doesn't work! I am a novice at this whole thing.
Where FreightProvider MatchFrm![ShipperCode1] = CurrentLoadList Frm![ShipperCode1], FreightProvider MatchFrm![ShipperCode2]=CurrentLoadLis tFrm![ShipperCode2], FreightProvider MatchFrm![ShipperCode3]=CurrentLoadLis tFrm![ShipperCode3], FreightProvider MatchFrm![ConsigneeCode1]=CurrentLoadLis tFrm![ConsigneeCode1], FreightProvider MatchFrm![ConsigneeCode2]=CurrentLoadLis tFrm![ConsigneeCode2],...Leave a comment:
-
Multiple Field Filtering
I want to be able to double click on a field called Weight on CurrentLoadList Frm and have it open another form called FreightProvider MatchFrm and filter on six different fields that are on both of the forms listed above. The six fields are: ShipperCode1, ShipperCode2, ShipperCode3, ConsigneeCode1, ConsigneeCode2, and ConsigneeCode3. The net result will hopefully give me a list of Carriers that have done the exact same loads in the past that I am... -
I am not sure how to do what you are asking? Any further instructions that will help me figure it out or if someone knows the code in order to do this I will take that also. Thank you all for your helpLeave a comment:
-
I have created the query and the form. I just don't know how to refine the records down to the ones I am looking for based on six different fields. If it was one I'd know what to do but because there are six I am lost. Can a macro filter a form based on six different fields that keep changing. Let me know. Thanks alot.Leave a comment:
-
Filtering a form based on multiple fields
I want to be able to double click on a field called Weight on CurrentLoadList Frm and have it open another form called FreightProvider MatchFrm and filter on six different fields that are on both of the forms listed above. The six fields are: ShipperCode1, ShipperCode2, ShipperCode3, ConsigneeCode1, ConsigneeCode2, and ConsigneeCode3. The net result will hopefully give me a list of Carriers that have done the exact same loads in the past that I am... -
Actually, I figured it out, thank you all for your help. I appreciate it very much.Leave a comment:
-
This code is opening the form but is not filtering the form. Any ideas?Leave a comment:
-
does anyone have any ideas?Leave a comment:
-
No I mean, I have 17 users in three different states using the database. If any one is in the database besides me I can not make design changes. The error message says you do not have exclusive access. I am not talking about security rights, I am the administrator....Leave a comment:
-
Making design changes while not having exclusive access
Is there a way to make design changes to an access database using 2003 while not having exclusive access? -
Here is more information. The form that I am in is CurrentLoadList Frm and the field I want to double click on is [ShipperCode1]. I want that to open the CarrierFootPrin tSubFrm, find the [State] field and filter on (Right(CurrentL oadListFrm![ShipperCode1],2))Leave a comment:
-
On Double Click - Preview Filtered Form
I have a form loaded and want to be able to double click on a field and have it pull up another form and filter it based on the value in the original form. What is the best way to do that. Access 2003. -
Thank you all, this solution works great.Leave a comment:
-
Just a warning on duplicate records
I am trying to set up a message box warning (or open to some sort of other warning) when a duplicate record is entered. I do want to allow duplicate records but I am looking to warn when it does occur.
Example of warning: Check number all ready entered are you sure you want to continue.
Any Ideas?
No activity results to display
Leave a comment: