Search results

  1. Schlingel

    Code doesn't work: db.OpenRecordset

    May i ask u another question? Is there any possibility to check whether the records with this date are already in the table? As always, thanks in advance
  2. Schlingel

    Code doesn't work: db.OpenRecordset

    This works perfect!!! Thanks 1000 times
  3. Schlingel

    Code doesn't work: db.OpenRecordset

    Thanks, I will try it
  4. Schlingel

    Code doesn't work: db.OpenRecordset

    I have a Table "Entschuldigung" (Datum, Tag, Stunde, Modul, Inhalt, TN, KW). Every day consists of 8 Records of Stunde. It looks like it: Datum Day Stunde Modul Inhalt TN KW 24.10.2006 Tuesday 1 Economics MWF ...
  5. Schlingel

    Code doesn't work: db.OpenRecordset

    Hi, Could u please help me and tell me why the following code doesn't work: Private Sub bflEntschuldigung_Click() On Error GoTo Err_bflEntschuldigung_Click Dim i As Integer Set db = CurrentDb 'Set rst = db.OpenRecordset("Entschuldigung") Set rst = Me.Recordset 'rst.MoveLast 'rst!Datum =...
  6. Schlingel

    How to get working days in the query?

    Hi, i have a problem I need to create a query that shows me only days which r: 1. working days 2. which r not in the table on which the query is based Thanks in advance
  7. Schlingel

    Inserting the records into the table

    FoFa, thanks for ur reply, but could u tell me more about it? I am really new to it
  8. Schlingel

    Inserting the records into the table

    Hi! Please, please, please help me! I have created a form that should get Date, Day inputed by a user. Then it must place 8 the same records in the table. Any help will be appreciated Thanks in advance
  9. Schlingel

    IE open and automatically fill the field

    Hi, I will really appreciate ur help, because i didn't find any good advice in a history of this very forum. I need to open a link in IE window (I know how to do it) and i need that a field will be autofilled with a name of the user (here i need ur help). Thanks in advance.
  10. Schlingel

    Funktion for the Week Number

    Thanks 1000 times! I found out the right code and now it's ok!!! Thanks Thanks Thanks. By the way, i checked with Now() and Date() and it works super in both ways!!! Thanks again
  11. Schlingel

    Funktion for the Week Number

    Thanks for this reply. But to use this funktion i have to write a VBA code, haven't i? And i am really a newbie. Could u give me a little bit more of instructions? Cause if i use the funktion u gave me as a standard value, the access writes "Syntax error". And if i write a code, then i get 43...
  12. Schlingel

    Funktion for the Week Number

    Hi, I will really appreciate ur help. I work on Access-2000 database and have a problem. I need to get the number of the week. So i used the funktion as a standard value as following: "=((Monat(Datum())*30,5-Tag(31-Datum()))/7)" It shows me for today 39 instead of 44. Could u please help me and...
Back
Top Bottom