Search results

great cheers. that bit works fine I hope.

Hi all, I have a text box (txt_day) that populates itself when another box is changed. One box displays the date and txt_day displays the day. I would like to get what txt_day displays into a string. I currently have: inputday = Me.txt_day But this returns (example) 12/05/2009 . How...

I have tried the following: Function fSQLDate(varDate) If Not IsNull(varDate) Then fSQLDate = Format(CStr(varDate), "\#yyyy\-mm\-dd\#") End If End Function SQLText = "INSERT INTO absent ([start_date], [end_date], [days], [reason], [name], [fullname], [day], [absentcode], [notes]...

yes - that seems about right - is there any way of getting round that?

I tried that - still no luck. It doesn't do it to all dates - just some. Any ideas?

I have the following: SQLText = "INSERT INTO absent ([start_date], [end_date], [days], [reason], [name], [fullname], [day], [absentcode], [notes], [comments], [backtowork], [certification]) SELECT #" & totalstartdate & "#, #" & totalenddate & "#, " & TotalBusinessDays & ", '" & namevalue2...

Hi all, When in the attached database I need to create a report that shows just year 2009 or 2008 etc... If you open up and click on open form, then at the bottom is holiday detail report - this is how far I have got. Is there a quicker way of doing this that works. I only want 1 year to...

Howzat..... That seems to work. Cheers for that - I'll keep testing anyway just to make sure but at the moment it seems to work. Thanks again Martin

Hi, Please find attached 2 images. 1 showing the report and form and the other showing the design of the report and the filter of the report. I still haven't got this working. When I choose 1 Feb 2009 it brings up the correct date but when I choose start_Date between 06/02/2009 and...

Hi both, Thanks for the help. I now have the following in a query: SELECT MakeUSDate([Start_Date]) AS Expr1 FROM absent ORDER BY MakeUSDate([Start_Date]); And my absent table has a field called Start_Date. in there are dates such as 18/01/2009 and 03/02/2009 etc... I have inserted...

Hi all, I have the following code under a command button (OK): Dim strcondition As Variant On Error Resume Next Dim countme As String Dim team As String countme = "countme" team = "IT" strcondition = "[Start_Date] BETWEEN #" & Me.txt_date & "# AND #" & Me.txtEndDate & "# AND...

Hi, I have tried your solution and the results seem to be the same. It still shows 2008 holiday bookings while searching through the 2009 data. Any other ideas? Thanks Martin

Just wondered if anybody else had any ideas? Thanks Martin

Hi, I have changed the query that runs to report to: SELECT BaseData.FirstName, BaseData.LastName, BaseData.Title, BaseData.Department, Entitlement.Yearfld, Entitlement.Entitlementfld, BaseData.EmpTerm, HolidayBookings.DateBooked, HolidayBookings.HalfDay, IIf([Halfday] Like 0,"1","0.5") AS...

Hi all, In the attached is a quick holiday database. I am just stuck on why the report side of it wont pick up the correct year. If you open the form and then click on holiday detail report it shows all the holiday, but it should only show for the year specified in the top combo box. Can...

Hi, I have posted a new version of the DB with what I want to happen in the code under form load. (still doesn't work) Just click the open form button on the screen that appears. Many thanks Martin

Please see attached. This is the file I am trying to put into my other database. I would like it so that when the form is opened it goes straight to show the data from field 'storey'. But still able to pick a different year from the top combo box. Thanks Martin

I have the following code Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[LastName] = '" & Me![Combo60] & "'" If Not rs.EOF Then Me.Bookmark = rs.Bookmark which works fine as it is the code behind a combo button. I would like to change it so that it also works...

The above I am unable to remove from the references in vba? It just says it cant do it. Is there a way round this? I can't access some code becuase of this. Thanks Martin

howzit? not howzat?