Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Comparing Dates in a query
I am fairly new to VB scripting in Access and I could use some help. I am running a query based on a status field str of [STATUS]="Shipped" with along with a field which includes the ship date. I am wanting to do a comparison with the [SHIPDATE] and the current system date - 28 days. If the...- pcdave41
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
WhereCondition syntax
Roy, That did the trick.. I appreciate the help. Regards, Dave- pcdave41
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
WhereCondition syntax
i'm trying to open a form using information from 2 already populated fields using the following code. I'm not sure how to format the WhereCondition to accomidate two fields. Any help would be great. Private Sub Details_Click() Dim stFrmName As String Dim stCond1 As String Dim stCond2 As...- pcdave41
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
