I have this problem:
I have a drug (in the main form) and its components (in subform)
i need to find the similar drug to a certain one.
molen malat
Last Activity: Dec 4 '06, 08:12 AM
Joined: Oct 14 '06
Location:
-
Accounting prog?
is Access is the best tool for building an accounting program?
if not .. what is the best for that? -
subform
I have a Form with SubForm .
how can i look for a certain record(main form) with all its related records(subform ) -
Thanks ........Leave a comment:
-
filtering again
Hello...
Can I filter a subform depending on a value exists in another subform?
thanks. -
from sub to mainForm
i tried to use a Find Record button to search for a specific field, e.g. LastName, FirstName etc. I have a form (frmHouseHold) and a subform (sfrmApplicants ) and I placed the Find Record button inside the subform, to find a record in yhe mainform but wasn’t successful. -
realy i don't try it again because i found a solution using VB-code that is:
If Not IsNull(Me.txtA) Then
strWhere = strWhere & "([EnName] = """ & Me.txtA & """) AND "
End If
and so on for other criteria then:
lngLen = Len(strWhere) - 5
strWhere = Left$(strWhere, lngLen)
Me.Filter = strWhere
Me.FilterOn...Leave a comment:
-
realy i don't try it again because i found a solution using VB-code that is:
If Not IsNull(Me.txtEn Name) Then
strWhere = strWhere & "([EnName] = """ & Me.txtEnName & """) AND "
End If
and so on for other criteria then:
strWhere = Left$(strWhere, lngLen)
Me.Filter = strWhere
Me.FilterOn = TrueLeave a comment:
-
Thanks......... .....Leave a comment:
-
sorry..
but a syntax error in it because ofthe "( " can you send it again.
thanks..thanks. .thanksLeave a comment:
-
converting to VB
can i convert my access files (MDB or MDE) to a visual basic program, including forms and all its objects and events? -
the query is:
SELECT Drugs.EnName, Drugs.Cmpny, Drugs.CPrice, Drugs.NPrice
FROM Drugs
WHERE (((Drugs.EnName )=[Forms]![SbQDrg]![TextA]) AND ((Drugs.Cmpny)=[Forms]![SbQDrg]![TextB]) AND ((Drugs.CPrice) =[Forms]![SbQDrg]![TextC]) AND ((Drugs.NPrice) =[Forms]![SbQDrg]![TextD]));
thanks a lot..Leave a comment:
-
filter problem
How do I filter a Query in Access with multiple combo boxes on a Form, such that when selections are made from say four combo boxes at once, they work together like AND statements, but if they are left blank then ALL records are returned, so that the Query is filtered progressively by each combo box selection, and not filtered if no selection is made? -
how can i post the query?...Leave a comment:
-
ignore null value when filtering with multi criteria
i have a query with 4 fields, and a form based on it. i put another 4 textbox to get criteria to filter the query. the query runs normally when all the textbox have a value (not null) but when one or more of them is empty (null) the query returns no records. how can i ignore the (null) in my criteria.
No activity results to display
Leave a comment: