Search results

Me too, I don't need the wizard.

I don't agree that there is no need to create an accde of the front end. If you want to protect your design elements, it's well worth doing. It also prevents users modifying the front end.

In passing, it's quite handy that rich text is still just text, so a rich text string will still be displayed with any Access version.

I was able to put together an image display function, but I can't recall where everything came from. It took a lot of fiddling to get it working, and in my case it takes a few seconds to show an image, but it is working now. It uses WIA - a reference to Windows Image Acquisition library. It...

The other day I realised that all the files in my documents folder C:/users/myname/documents had moved to my OneDrive. I must have clicked something to move them, but I can't think what.

Thanks all for the responses. @plog I think that sort of nails it. I had wondered whether Power BI could replace an Access database of itself, but it doesn't sound like it can. We currently generate reports etc using a dashboard/menu system to select pre-defined report examples. The...

@theDBguy Thanks Guy. I sent you a PM.

Someone at a client mentioned Power BI yesterday. Is that a useful addition to an Access based system. Does anyone have any useful explanatory links please?

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