Recent content by gemma-the-husky

Yes, but doesn't that mean you have to modify inside the form to call the appropriate function and determine what privileges are needed to execute the event? It's easy if the atomic event is "the form". It's much harder if each form contains multiple decision points. Don't you also need to...

There's two levels of security, if you will. The bit that's easy is managing access to a form. Design a set of user groups, and and users to those user groups. Then limit a form to a membership of a particular user group. That's easy - as all you have is a function in the open event of a...

@MarlonVisser0408 The trouble with spreadsheets is that they don't offer you the strong data-typing at the column level, that you get with a database field. Their really is no comparison. It's pretty bad that spreadsheets get used for all sorts of things where a database would make much more...

As an aside, if you don't really need 12dp accuracy, you could use currency format, which stores reliably to 4dps.

If you cant link a form and a subform by using the wizard, you might be able to manually set the linking fields. Alternatively, in the master form, you can use the current event to set a public global variable to the value of the linking field. Then change the sub form to use the public...

@Pat Hartman Yes, my switchboard does similar things to yours. My standard is 25 items - 3 columns of 8, plus a "return" option. I do have big commercial apps and do need that many options. I meant more what new functions are included in A365 that developers find indispensable, but which...

Even if it's academic it would be better to use the numeric ID to manage club members. In practice you would prevent duplicate names by adding a unique index. So if you created an index based on surname plus given name, and made that index unique, then access would report an error if you tried...

Whoa. Stop right there. It's a minor thing but I doubt anyone would design a system where a given name is unique, or even a given name plus surname is unique. Would you refuse membership to a second Jim? Even if you don't have a duplicate you wouldn't assume you would never have one. Anyway...

Really Access has been very good since A97. A2003 changed the horizontal and vertical structure of the database window (infuriating at first)and added some useful functionality. Further versions have added some further features none of which are absolutely essential. The tweak that lets you...

Well it might cause an issue. If you pass something to a procedure explicitly byval, and expect it not to be changed by the procedure, and then continue to use that thing expecting it not to have changed, it may well cause an issue if the procedure changed the original thing because even you...

I meant that it's not a problem that can be resolved by simply counting elapsed days, and adjusting for elapsed saturdays, sundays etc because of the nature of statutory holidays.

I know this is an old thread, and I may have replied already, but what I meant was this. Because I was so used to passing arguments to procedures byval, and not being able to pass amended values back to the calling code, I just developed a habit of never trying to change them within the...

The hard bit is eliminating weekends, and especially public holidays.

It became harder because initially MS Office was installed as 32bit by default. Now it's installed as 64bit by default although 64bit is rarely necessary. The easiest solution might be to get your client to re-install 32bit office. If they need your solution badly enough they might do that.

Seriously as a developer you most likely need to offer both environments. It's one thing having a 32bit database. Converting it to 64bit may be relatively trivial, but it may also lead you to real problems, if you've used tools that haven't been ported to 64bit. I'm pretty sure there's more to...