Recent content by gemma-the-husky

General number isn't right. That would accept 13.2 for instance, but if you are storing the value in a long data type field you will get a type mismatch somewhere. You need to prevent the control receiving anything other than a whole number.

I would get the times entered as 24 hour values. If a course stage was 3.40 pm, get it entered as 15:40, and store it as a dare/time record. If the course extends more than a day, then you need to take the date into account. I am sure having the times stored in this way should make things...

Sometimes it may be that getting your database to manage the data correctly and in a harmonious and logical way is more important and instructive. That is, If you saw the data presented as 1,2,3 rather than 1st, 2nd, 3rd it might not really matter so much. However have then dealt with...

I don't really know what quicken is. I thought it might be a multi user accounting system for SMEs. If it's more like an analysed expense record for an individual where you don't need to produce an enterprise balance sheet, then I assume it's much easier to build. The bells and whistles might...

I expect there are ID numbers in there, then.

Why not use quicken? Because a basic accounting system could be developed in a couple of weeks. You never have to pay for maintenance, and it does exactly what you want. Depends what books of prime entry you want, but I doubt very much if quicken offers anything much that is really needed. Maybe...

Seriously. You do not want separate sequences for debit and credit values in the same table. Just a single sequence, using positive/negative values Far easier. The total is the sum of everything, and in a double entry system should add to zero. Obviously you might want a sales receivable...

Do you mean 13Mb. I have DBs of 50mb with thousands of objects that build to accde with no problems. They won't build if they don't compile. Are you certain there's no code issues. Might you have code that works in both 32bit and 64bit access. That might run as a .dB, but won't compile to an...

I don't think the network is necessarily to blame. Maintaining a persistent connection with multiple users is probably the biggest issue. Writing queries to minimise the number of records that are returned is important. Also, use a wired connection rather than wireless.

I was going to say that. I rarely use .openquery to execute an action query. I would use currentdb.execute, and include error handling. As Pat says I would also include error handling for the whole code block.

Maybe the problem is having byref in your header. It should be byref by default, but maybe putting byref in the header causes something to go wrong.

@naa123 If you have an accde then users already can't see or modify a form's design. The only issue is preventing access to the database navigator (tables and queries), so your issue should be rather less difficult.

No, not quite. You produce an accde normally, and then the code protector reprocesses the accde to remove the bits that identify the public variables and constants. I use it to make decompiling my accde files difficult, but it clearly does come with the problem that you can't reconstruct the...

I know this is an old thread, Pat, but Wayne has a product that strips out the variable names to prevent such powerful disassembly. All variables are just recovered as var1, var2 etc, which would make code rather harder to follow. Edit. I already mentioned this about a year ago, I see.:D

@isladogs I use the code protector from everything access, which removes all trace of variable names from disassembled projects, thus making the code much less readable. Just in case. It only takes a few seconds to process any mde/accde