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 &...

looks over complicated! Sorry im a n00b when it comes to access!

umm thats confused me more, it dosent say what its doing, and the names are meaningless#

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...

Sorry no , as it is classed as "Secret" basicly user enters purchase date of unit as date "dd/mm/yyyy" into a text box (txt_purchase) user chooses from a drop down box how many years wrnt it comes with. (com_years) This then populates a text box with the date the wrnt will expire...

IT seems as thendate is not reciving the date. I am using thendate = me.expire.text when I use the message box function to display thendate, it appears blank!

thendate as date. At present it dosent matter if the date has expired or not it still executes the expired date option Private Sub changelabels() If Date > thendate Then expirelable.Caption = "Warranty Expired" expirelable.ForeColor = 255 End If If Date < thendate Then...

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...

ok sorted thanks, just removed the 1st cmb_value

great the date add thing works, however it also adds x number to both days and years? so if I say the wrnt period is 2 years and purchase date was 12/01/2007 then the expirey would give me 14/01/2009 Have I done somthing wrong? this is the code i have used! remaining.Value = cmb_wrnt.Value +...

Ok ive have changed the ideas slighty now its on the form and the expirey is now done as a date so it will say warrenty expiry "dd/mm/yy" so I know I need to tell it to add 2yrs onto the year field! I will play around with what you said too, thanks!

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...