Search results

In all fairness I think I may have deleted the original persons tag on those lines of code. I did not write that, and yes, who ever did write it does deserve credit (I shall sort that now). Update: By using the Acess Query builder Available Days: IIf(IsNull([Start Date])=True Or [Start...

I had exactly the same problem a while back. Go back into regional settings, click customize, go into date and in Short date try "d/M/yy" that's mine currently, and it seems to work fine.

In the attached databse, there is an Available Days function in qryMain. I'd like it so that when a day of the week tickbox is checked, to update the query. However I can't seem to get the Available Days function to access information from the query. I've had this working using a form...

SELECT tblSicknessData.EntryID, tblSicknessData.[Payroll ID], tblSicknessData.[User ID], tblSicknessData.[Daily Hours], tblSicknessData.M, tblSicknessData.Tu, tblSicknessData.W, tblSicknessData.Th, tblSicknessData.F, -([M]+[Tu]+[W]+[Th]+[F]) AS [Days Per Week], tblSicknessData.Location...

Could you please demonstrate an example of this? I'm still at noobie level with VBA Code (the lack of a decent API is a bitch!)

I have already asked for help on this matter once before, but I'm trying to do something slightly different this time. Bare with me... Basically, my query so far has 5 check boxes, for each working day of the week. I have a working function (DateDiffExclude - thank you everyone that helped so...

Oooohhhh, I see now. Thanks again guys, slowly getting better at this. Gonna be a long time before I hit your level though, I still keep trying to do things as if this were Java!

Uhmmm, what does Option Exlicit do exactly? I'm still learning, so it would be good to know. Thanks for response!

I have the following code, and basically it doesn't seem to return the correct value but instead is just jumping to the end of the function. Public Function WorkingDays2(pstartdte As Date, penddte As Date) As Integer On Error GoTo Err_WorkingDays2 Dim rst As DAO.Recordset Dim DB As...

I have a form at the minute that is able to list print cartridges by selecting a combo box. I am not sure how I can get a report to then print this list. I think it's an SQL query that I need, but I'm not sure where to put it. (catch you after the weekend, any response would be great thanks!)

Ok, cancel this, I found a way to do it, took me a while but seems that it's possible by using the wizard, I was just going about it the wrong way. thanks anyway.

I'd like to be able to select a choice of printer manufacturer(as a combo box), which will then display all the printer cartridges made by that manufacturer in a table below the combo box. I have made the forms (with the relevent combo box looking up manufacturers) but am now sure how to relate...

I'd like to be able to select a choice of printer manufacturer(as a combo box), which will then display all the printer cartridges made by that manufacturer in a table below the combo box. I have made the forms (with the relevent combo box looking up manufacturers) but am now sure how to relate...

Lol, /doh! Figured that out after about 30 minutes of being a blind fool, thanks! Now all I have to do is get my Available days function to check for bank holidays and the such. So far I've got: Public Function WorkingDays2(StartDate As Date, EndDate As Date) As Integer On Error GoTo...

Lol, /doh! Figured that out after about 30 minutes of being a blind fool, thanks! Now all I have to do is get my Available days function to check for bank holidays and the such. So far I've got: Public Function WorkingDays2(StartDate As Date, EndDate As Date) As Integer On Error GoTo...

Lol, /doh! Figured that out after about 30 minutes of being a blind fool, thanks! Now all I have to do is get my Available days function to check for bank holidays and the such. So far I've got: Public Function WorkingDays2(StartDate As Date, EndDate As Date) As Integer On Error GoTo...

Lol, /doh! Figured that out after about 30 minutes of being a blind fool, thanks! Now all I have to do is get my Available days function to check for bank holidays and the such. So far I've got: Public Function WorkingDays2(StartDate As Date, EndDate As Date) As Integer On Error GoTo...

Function MakeString() As String Dim stringy As String stringy = "1" If [Forms]![TimeSick]![M].Value = 0 Then stringy = stringy & "2" End If If [Forms]![TimeSick]![Tu].Value = 0 Then stringy = stringy & "3" End If If [Forms]![TimeSick]![W].Value = 0 Then stringy = stringy & "4" End If If...

As I posted in the VBA code forums, I too am having this problem. I need to calculate the ammount of days a person is working, if they are working say Monday and Wednesday, I need to calculate the ammount of these between two dates and then minus holidays from the known dates. Surprised this...

Ok having a few problems. What I'd like to do is pass in a string into Raskew's existing function. This string would be for example "1457" so that it could find the ammount of days a person is available to work, but checking the values of 5 tickboxes (the ones not ticked, would be added to...