Search results

  1. G

    Updating query

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

    Extracting data from query

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

    Not getting out of loop

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

    Using only certain records in a form

    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!)
  5. G

    Using a combo box to display a table

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

    Using a combo box to display a table

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

    Creating a string

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

    Trying to calculate sick days

    Basically I started using access a few days ago, as a computer science student it's been fairly easy and I have a good understanding so far. However, I'm finding it very difficult to calculate data. In particular sick days. I have a part time database to input that includes the following...
Back
Top Bottom