Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. apestaarten

    My Query gives an error#

    I Changed the null tests into nz and I found out that I have forgotten to test the null value of "Datum herstelmelding". That solves the problem. Now I have to change the date constants into data variables. The code :SELECT Verzuim.RelID, Verzuim.[Datum ziekmelding], Verzuim.[Datum...
  2. apestaarten

    My Query gives an error#

    Hello, I Try to calculate the number of days someone is ill. I use the following Query : SELECT Verzuim.RelID, Verzuim.[Datum ziekmelding], Verzuim.[Datum herstelmelding], Verzuim.Maandnz, Verzuim.[Aantal uren ziek], CInt([B])+CInt(([Datum herstelmelding]-IIf([Datum...
  3. apestaarten

    Dsum with AND (.......OR......)

    Hallo PHV, Once more you heave given me the right solution! Thanks! Small question, where can I find the rigth syntax or is there a way to see what is missing? Best regards Apestaarten.
  4. apestaarten

    Dsum with AND (.......OR......)

    I try to use Dsum to sum the ours ill for a particulair location whereby the recover date or the moth still ill are valid for a month. Here under my code : [code]Ziekteuren = DSum("[Aantal uren ziek]", "Verzuim Query1", "[StationID] =" & StationID & " AND (Datepart('m',[Datum herstelmelding])...
  5. apestaarten

    Set background color in field

    Thank you PHV, You ask the right question. I managed to solve the problem with conditional formating. Thanks also BUBBA100 Regards, Apestaarten
  6. apestaarten

    Set background color in field

    I did. But the the conditional format is then dependent of an other recordset. See here under the code. Private Sub Form_Open(Cancel As Integer) Dim jaar As Recordset, strSQL As String, rst As Recordset strSQL = "SELECT * FROM Jaar" Set jaar = CurrentDb.OpenRecordset(strSQL) strSQL = "SELECT *...
  7. apestaarten

    Set background color in field

    Hi, In a recordset (Access 2007)I select a record using the find methode (rs.find(expession)). I find my record and I want to change te background color of one of the fields. In my case rs!day. I don't know how do this. Who can help me? regards Apestaarten

Part and Inventory Search

Back
Top