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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Falroc
-
retrieving data between 2 dates
That is what I would like to do. Hire a professional that is but that isn't one of my choices. Thanks for all your help. I will try and figure it out on my own.- Falroc
- Post #9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
retrieving data between 2 dates
Skip, I guess I need to put in the table where the Purchase Date Field is. Can you show me the syntax to tell what table and field to use? The problem is that someone else wrote all the VBA and I am trying to reverse engingeer the code. By the way thank you for all your help. I was feeling...- Falroc
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
-
retrieving data between 2 dates
so should it look more like this? but how does it know what field to use. If Me.txtStartDate <> "" Then sWhere = sWhere & "([Date Used]) BETWEEN (#" & Me.txtStartDate & "#) AND " & _ "(#" & Me.txtEndDate & "#) AND- Falroc
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
retrieving data between 2 dates
First of all let me tell you I am a complete noob when it comes to VBA in access 2007. I have attached a copy of the module for part of a report selector form I created. Everything works until I try to get all records between two dates thru user inputs. I made two unbound blanks in the report...- Falroc
- Thread
- Replies: 9
- Forum: VBA Visual Basic for Applications (Microsoft)
