Recent content by Solo712

This is because the yellowed line attempts to read past the end of file. Remove the line and place the Line Input #1, Vline on top of the loop below the While Not EOF(1) line. Best, Jiri

It's not only harsh but quite irregular as well. Time off has always been calculated as time off days one is supposed to work, TMK. Jiri.

There appear to be some loose ends still. 1) It is not clear what should happen if the records simply reflect employees' requests for leave, or only approved leaves by the management. If all requests are kept then a status field (request approved/rejected) is needed. 2) I would prefer not to...

Do you mean she can't enter data in the form or she cannot save data into the database? Next thing: can she display data? Jiri

The relationship between authors and books has been set, so the delete will not happen if there are books by the author. Best, Jiri

This OOP is puzzling. There is no situation recognized by the accounting world in which an item would start depreciating after holding its acquisition value for 5 years. Also I am not sure about the "bumpiness", i.e. the need to re-valuate the remaining value of the asset monthly. At any rate...

I don't think this is trivial or picky. It's a question of acquiring the habit of writing efficient code. The inner loop is not just inefficient, but a totally unnecessary code. You know that the inner loop evaluates positively only once, and on the first hit. So, going through the test is...

ad 2) Yes, bookings and reservations are the same thing. Room occupancy should have its own table, based on actual check-in (and check-out). Tariff (?, rate) in that table is a duplicate. The rate is negotiated beforehand, whether by a reservation agent or by reception. The payment table does...

My standard approach is keep separate tables for (bank) accounts and transactions. The accounts have description, account number, opening date, opening balance, status, etc. Transactions are not hard wired to a single bank account: they will have the bank as an FK, either on the debit or credit...

Not a good idea to store intermediate balances. They are available by simple formulas: (which assume that all transactions are dated). 1) period start balance = bank opening balance +debits - credits up to a day before start of reported period . 2) period closing...

There is more than one way of doing this. My preferred method was a consolidation table which recorded all changes (inserts-updates-deletes) and sent via e-mail as excel spreadsheet. The two sides then merged the table by the date stamp and a common algorithm. My tables in the db's did not have...

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

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

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

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.