Search results for query: *

yyyy/mm/dd SELECT * FROM qryContLife WHERE 1=1 AND [Depot In Date] Between #2008/05/01# And #2008/07/30# mm/dd/yyyy SELECT * FROM qryContLife WHERE 1=1 AND [Depot In Date] Between #05/01/2008# And #07/30/2008# Both textboxes are formatted to short date. Currently in both cases in...

Didn't help, returns 2 weird values out of like a 100 possible. The thing is that even if I run the 2003 version in 2007 access it works fine, but if in 2003 it doesn't work.

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

thanks, going to work on this

DepotFee: IIf(Not IsNull([Depot Out Date]), DatePart("d",[Depot In Date])*[Storage Fee/Day], IIf(DateDiff("d",[Depot In Date], Date())<31,DateDiff("d",[Depot Out Date],Date())*[Storage Fee/Day], 31*[Storage Fee/Day])) Solved i guess ;) thanks

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

solved.

right guys, thanks for the great help, managed to do it with this function: DepotFee: IIf(DateDiff('d',[Depot In Date],Date())>31,31*[Storage Fee/Day],DateDiff('d',[Depot In Date],Date())*[Storage Fee/Day]) Have a little problem left. On my input form I have a combobox to input the...

I'm trying to run this from an independant form. It is easy to run it in a query, but I need a a function in vba that will make calculations based on the datediff values ;( Am i getting this through ? ;(

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

thanks thanks thanks again ;)

Remou, thanks alot, everything works now, you've done a great job. You're a very patient and helpful person. Thank you.

yay, we're on the right track, it works with simultaneous searches, this is the output: SELECT * FROM qryContLife WHERE 1=1 and [Status] Like 'RM*' AND [Depot In Date] Between #05/01/2008# And #01/05/2008# and it gets shown in the listbox, but the dates are weird. I input from 05/01/2008...

Did what you've said, left 1 if statement at the beggining of the Addwtf sub, haven't changed anything in the button sub, this is whats the output like: SELECT * FROM qryContLife WHERE 1=1 [Container Number] Like '*'[OwnerCode] Like '*'[Arrival Date] = '*'[Depot In Date] = '*'[Container Size]...

Sorry, don't pay attention to the : Private Sub Command120_Click() I accidently copied that together with the required code

Private Sub cmdShowCont_Click() Dim MySQL As String, mycriteria As String, MyRecordSource As String Dim argcount As Integer Dim Tmp As Variant mycriteria = " " argcount = 0 MySQL = "SELECT * FROM qryContLife WHERE 1=1" Addwtf [myd1], "[Container Number]", mycriteria, argcount, "myd1" Addwtf...

The only thing that changes with your suggestion is that the function takes all the fields no matter whether they r empty or not, the output in this case looks like this: SELECT * FROM qryContLife WHERE 1=1 and [Container Number] Like '*' and [OwnerCode] Like '*' and [Arrival Date] Equals '*'...

SELECT * FROM qryContLife WHERE 1=1 AND [Depot In Date] Between #2008/05/01# And #2008/07/01# this is what i get if i just input the date range, and I get the values in the listbox, but as soon as I add something else to the search, Container Size or Status, the listbox is blank.

Private Sub cmdShowCont_Click() Dim MySQL As String, mycriteria As String, MyRecordSource As String Dim argcount As Integer Dim Tmp As Variant mycriteria = " " argcount = 0 MySQL = "SELECT * FROM qryContLife WHERE 1=1" Addwtf [myd1], "[Container Number]", mycriteria, argcount, "myd1" Addwtf...

Right, what I experiece when I search for a date range and other values. When I search for a date range, the output is this : SELECT * FROM qryContLife WHERE 1=1 AND [Depot In Date] Between #05/01/2008# And #01/07/2008# AND [Depot In Date] Between #2008/01/05# And #2008/07/01# And the...