Search results

OK, I am trying to build sql strings from a form buy the user selecting criteria from boxes on a form. I was given some code which I have adapted very slighty Dim strCrit As String If IsNull(Me.server) Then ' proceed Else strCrit = strCrit & " And [Server type] = '" &...

I am still having issues with getting a qbf working correctly! I have been told to use VBA to pass the criteria to the query? so far i have been trying this Dim strCrit As String If IsNull(Me.Server) Then ' proceed Else strCrit = strCrit & " And [Server type] = '" & Me.Server &...

In the query itself you simply put <5 to get the result. But how do I pass this critera from a form? Basicly the user enters a number in one box, and the choses "or more >", or "Or less <" from a combo. Clicks the run button and then the qery runs showing how many items are instock with that...

Thanks for the help on my last question. One more small one. How do I compare two dates to check if the entered date is newer or older than the current date. I have tried if date > thendate then xxx but that dosent work correctly. What I am doing is comparing the expirey date of a warranty...

Hi, I have never had to do any maths with access before, so I don’t know where to start! What I need to do is calculate remaining warranty information for products. In the table I have 3 columns. the 1st column is "Purchase date (dd/mm/yy)" 2nd column is "Total warranty period (years)" and the...

Hello there. I hope you can help with the issuse that I am having with my criterea queries! I can do the QBF, that bits not the issue, however its not behaving the way I thought it would! I have follwed what my book says and also http://support.microsoft.com/kb/304428/EN-US/ too, but the...