Search results

  1. Schlingel

    Stop Opening The Form

    Hi! Hope u all r doing well. I need ur help once more, please. I have tried to find it in the forum but no luck. I have a form and on_open event, which checks if the user has already wrote down his day plan. In this case the form must not open at all. What i could get is that the user get the...
  2. Schlingel

    Modul for checking the values in the table row

    Hi! I have a small problem again. Hope u could help me. I really appreciate ur help, u know I want to create the module that must check and control the value of the variable put in the table. Somehow, it checks nothing. Could u tell me why?! Here is my code: Public Sub StundenControlle() Static...
  3. Schlingel

    Checking the records in table

    Hi! I really appreciate my being the part of this community. I also appreciate ur help. Thanks, i have already learned much. Now i have a small problem and i am asking for ur help. I have a form. The user can input hours (options group from 1 to 8), module (combobox, only list entries) and...
  4. Schlingel

    How to use a compund Primary Key?

    Hi I have a little problem. I have a database with two tables: Nachweis and Entschuldigungen. In the first one u can add the records of what u have done for every day, the second one is for the days when u were absent. I need to let the user to add in the second table only records which are NOT...
  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

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