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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
2007 to 2003 function problem
Hello everyone. I've been working on a database in MSAccess2007 and had to convert it to 2003. I have a line of code which returns a requested date range from a query to a listbox: Dim MySQL As String MySQL = "SELECT * FROM qryContLife WHERE 1=1" If IsDate(Me![StartDate]) And...- Eugenios
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
-
Multiple IIf statements
Hello everyone. I'm trying to create a formula that will return values based on several fields. I have 2 dates - Depot In and Depot Out. The formula requires more than 2 calculations and this is where get confused whether it is possible to use a IIf statement. The formula is used to calculate...- Eugenios
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
-
DateDiff and some operations with it
Hello everyone. I've recieved wonderful help last time when i turned to this forum, now i have another problem and hoping you will help a beginner again. I have a table with containers. Each container has an arrival date. I am trying to make a function using DateDiff to calculate the difference...- Eugenios
- Thread
- Replies: 5
- Forum: Microsoft: Access Other topics
-
Search multiple fields simultaneously with data ranges
Hello, I'm new to this forum and would like to greet everybody. I'm working on a search function which is similar to the one given on this website provided here : http://www.tek-tips.com/faqs.cfm?fid=1177 Only I currently have 5 textboxes for search and the results are returned to a listbox...- Eugenios
- Thread
- Replies: 41
- Forum: Microsoft: Access Modules (VBA Coding)
