Recent content by Solo712

  1. Solo712

    Insert Into Query for 1:m Relationship

    Eberhard, Pat and plog are right. the union query would by the correct way to go in this case because the 1:m relationship btw the Games and Games Played tables is always 1:2. This makes the Color & Result tables quite unnecessary and silly. Note that a win by White is a loss for Black and...
  2. Solo712

    The Deep State

    My .02$ (Canadian): 1) The 2020 election was not "stolen". It's just that the electoral process has been so manipulated by the Big Tech and MSM favoring one side that it that it has little resemblance to anything that may be rightfully called "democracy". 2) "The Deep State" did not create...
  3. Solo712

    Version Control for VBA modules or projects?

    Since as a developer I worked mostly by myself I had not seen the need for for versioning control products designed for the use of teams. But I learned in the school of hard knocks that it pays to maintain version control. I did it via table which recorded all code, report design and query...
  4. Solo712

    Dlookup problem

    You guess wrong, as you sometimes do. You did not question the use of DLookup for a task which by all appearances calls for a select query. Ebs was the only one who called that out. Jiri.
  5. Solo712

    Dlookup problem

    I am surprised to see you as the only one who sees the obvious here (beyond the date format and so on). The Dlookup will hit the first record that matches the criterion, so obviously as a first thing you would want to see how many followups are due at any particular date. So yes, a select query...
  6. Solo712

    DCount

    The point may be moot but, FWIW, pbaldy is most probably right. Neither "CINT" nor "INT" worked for me as I tested the casting. In my example (below) only Clng worked. x = CurrentDb.OpenRecordset("SELECT COUNT(*) FROM MyBatch WHERE Clng(txtDate) = " & _ CLng(DateSerial(2024...
  7. Solo712

    Solved Seat license security

    I really don't get it it, Pat. Is there a reason why you want to track the licenses individually, in preference to, say, issuing a single license to your client with a max number of concurrent users ? I have not seen anything in your posts that would indicate a need for such a system. There...
  8. Solo712

    Solved Seat license security

    Pat, it is not clear from the OP or the subsequent discussion what type of "seat licensing" you have in mind. There are basically two types: 1) per named user where an individual license is tied to a specific software installation, 2) per active user - license limits the number of users who...
  9. Solo712

    Not opening two of the same versions of the Front End file?

    FWIW, @1 - Using the same FE copy from the server by more than one user is a potential problem, eg. if the app settings are manipulated or customized by the users via FE tables. At any rate, I would discourage using shared FE as it defeats the very purpose of a split database. Restrict the...
  10. Solo712

    Solved No current record error

    Instead of requerying an empty table you should set the form for a new record: DoCmd.GoToRecord , , acNewRec Best, Jiri
  11. Solo712

    Password Generator

    I would recommend the standard process of generating a random sequence of allowed characters to get into the database initially. Then make the user create his/her own password based on rules.
  12. Solo712

    Solved Issue with checking duplicate values

    The qualifying test cannot be written like that. Your "c" will always be positive if there is a record with a PositionID of that value irrespective of the CourseID, and vice versa. So you will always get the message if column(3) ListCourse is not Null. Try this: c = DCount("positionid"...
  13. Solo712

    Point of sale

    Any retail commercial db app has sophisticated inventory control such as you mention, and in some businesses handling perishables more than in others. The need to move goods before expiry date is an absolute priority. Also, systems that I am familiar with have "sales & shelf contribution"...
  14. Solo712

    Use IF function to identify if identical values exist in another table?

    I think you always get the "values" message because the statement does not protect against null string. Try If Nz("Select".....
  15. Solo712

    Delete Record

    Me.Refresh will not help. Use Me.Requery after the Delete command. Jiri
Top Bottom