Eugenio
Last Activity: Aug 15 '08, 04:52 PM
Joined: Mar 26 '08
Location:
-
sorry for not posting, was quite busy. Right, the problem is solved through chaning the date separator in the regional settings ;) format was dd.mm.yyyy , after changing it to dd/mm/yyyy, everythings fine. -
2007 to 2003 code 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:
...Code:Dim MySQL As String MySQL = "SELECT * FROM qryContLife WHERE 1=1" If IsDate(Me![StartDate]) And IsDate(Me![EndDate]) Then If CDate(Me![StartDate]) < CDate(Me![EndDate]) Then mycriteria -
Solved i guess ;) thanksCode: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]))Leave a comment:
-
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 the storage fees of containers
The logic behind the formula is - If [Depot Out] IsNotNull then datediff("d",[Depot In],[Depot... -
...Code:If IsDate(Me![txtBeginDate]) And IsDate(Me![txtEndDate]) Then If CDate(Me![txtBeginDate]) < CDate(Me![txtEndDate]) Then mycriteria = mycriteria _ & " AND [BirthDate] Between #" _ & Format(Me![txtBeginDate], "yyyy/mm/dd") _ & "# And #" _ & Format(Me![txtEndDate], "yyyy/mm/dd") & "# "Leave a comment:
-
right, i've managed to create a search for a sepcific date range using your example and it looks like this:
...Code:Dim MyRecordSource As String Dim strSQL As String If IsDate(Me![txtBeginDate]) And IsDate(Me![txtEndDate]) Then If CDate(Me![txtBeginDate]) < CDate(Me![txtEndDate]) Then strSQL = "Select * From tblTest Where [BirthDate] Between #" &Leave a comment:
-
thanks guys, i will be working on this and will post if I encounter any difficulties. Sorry for the confusion I caused. Thank you.Leave a comment:
-
ADezii, I never used the Recordset function so I don't fully understand how the code works. In your example you have a table with birthdates and a form with 2 text boxes, this part I get, but this one scares me:
...Code:Set MyRS = MyDB.OpenRecordset(strSQL, dbOpenDynaset) If Not MyRS.BOF And Not MyRS.EOF Then 'valid Records Do While Not MyRS.EOF Debug.Print MyRS![LastName]Leave a comment:
-
Thanks for your attention. Right, is it possible to incorporate the example u gave me into the existing code? I mean so that I would be able to make searches using various criteria e.g. sort the data by the date range between 01/01/2008 and 01/02/2008 and some other piece of data like container size for instance.
I really hope I'm being clear. Unfortunately I don't have a chance to test ur example right now, but I'm going to do that...Leave a comment:
-
Search multiple fields simultaneously for values within a certain range
Hi there, I'm returning to this forum for the second time and I would like to say thanks for the great help provided. I've encountered a new problem now and hope that you will be able to help me again.
I'm currently implementing a container monitoring system in MSAccess07 and I'm using a multiple search function to sort containers. I use several unbound text boxes and a list box.The user type's in partial search criteria in one or... -
got it. topic closed.Leave a comment:
-
But i need the user to be able to input any report title they want. They wont be able to change the values in the hidden text box. and im not really sure how to link a text box with a caption, or is it now what u mean ? ;)Leave a comment:
-
Assign a title to a report through VB
Hello everybody, I'm new to this forum, so sorry if i post something that has been already answered althought i couldn't find it in search. Anyway, there it goes:
i have a search system which gives you the values you search for in a list box. The list box has its "Multi Select" property set to "Extended" which allows you to pick specific records from the list box. I also have a button to allow you to produce a report...
No activity results to display
Leave a comment: