Search results

  1. I

    How can I make an expression which refferes to a specific date on the current year?

    Hi! I have a little VBA-line that needs a bit of changing. It is part of a bigger procedure that calculates how many boats a company has on their docks. With this code though, I would have to manually go in and change the date every year. It should preferabelly be counting from the date April...
  2. I

    Is there a way to prevent a form from updating its content dynamically?

    Hi Again :) I was wondering if anyone knew of any way to prevent a form from updating its content against the tables dynamically? I have some subroutines that check what values the fields have, and deactivates some of the fields based on the values. (Every field that is not "0" is deactivated...
  3. I

    All fields suddenly reads #DELETED when accesing a record from two sessions at once

    Hi there! I have a scary problem, I have just redesigned my database for supporting multiple users. I am currently in the test-phase, where I simply open the database twice (hereby refered to as two sessions), and then I try to produce errors by typing in data in the same records at once. I...
  4. I

    Need helt developing either a que-system or an effective anti-concurrency function.

    Hi there! I have been searching different forums, but I can't seem to find any answer to this excact issue, and this is without doubt the best access forum, so here goes. I have a little project with a few different challenges. This might be a little long to read, but I would like to just...
  5. I

    Problem comparing dates in If sentence

    Hi Again :) I have another If-related problem... If rst!Dato >= Tekst27 Then If rst!Dato <= Tekst29 Then TextFile.WriteLine (rst!Dato - rst!Medlemsnr) End If I am trying to make an If sentence compare if the field [Dato] from a table I have is greater than the Text field "Tekst27" and...
  6. I

    Problem with setting a value in an If statement

    Hi there!:cool: I am trying to use an If sentence to determine whether a combinationbox is "Bestilling" or "Bestilling_ut" and then set a variable to one of two values. If Kombinasjonsboks11 = "Bestilling" then forlag = Landsetting If Kombinasjonsboks11 = "Bestilling_ut" then forlag =...
  7. I

    Dcount problem

    Hi! I have been reading hundreds of threads in different forums to get an understanding of why I have this problem, but no luck. I have a table of a lot of members in a boat-club, more specifically which members that have ordered help with their boat. And i need to count the total number of...
  8. I

    Need help making an IF sentence in a form

    Hi I am making a database for several boat companies in Norway. One of the forms is a form to fill out which boats are going to be hauled out of water for the winter, on which dates and which hours. On a full day the companies can lift in total 21 boats of water. So i have made the form so...
Top Bottom