Search results

To circle back on this -- this is included with a MS 365 Business plan (pricing is per user), so it's a much better deal than subscribing a la carte. Also, while you can build a standalone app, you can also put it right in Teams if you're using that: This is some really impressive stuff MS...

Please do share your thoughts on the above question. Thanks.

@TJ01 thank you for the update. I am going through this process myself per my recent post: https://www.access-programmers.co.uk/forums/threads/is-access-the-right-solution.315123/ So if I can change a couple of variables: If you were not willing or able to spend the time to learn PHP, and If...

It depends how your business is set up, but here's what I do: Database resides on an internal (government) network Database is .accde - no one has the .accdb except for me This .accde is locked down - bypass is disabled, ribbon is disabled, options menu is disabled, right-click menus are...

Monospaced fonts are best for coding...

I mentioned this before. I know it exists, I just don't know how to get it. Microsoft uses it in their Access help.

Users who are above my level and thus outside my rights to train. It's too bad.

I mean it's new to these folks at my workplace. They don't seem to trust Access because a previous database they made was a disaster. It wasn't set up for multiple users which restricted entry to one person at a time and they kept trying to use an unbound form which was throwing all kinds of...

Yup...the new thing seems to be SharePoint with forms feeding into spreadsheets. One-way, non-normalized, 5000 record limit so they have to manually move rows somewhere else, lack of customization...it's a mess.

I have this working satisfactorily now: If Me.LastModified >= Now - 0.01 Then Do the above. As stated you could also try a requery of specific fields on the record list instead of the whole recordset. I have not tried that. But with the last modified and Now optimization only new and updated...

One method could be to use my last modified date on the form. If modified >= date - 0.5, then do the requery and recalc. Otherwise, just close the form. That way just viewing records older than 12 hours ago is still fast.

I will try the on change first, thanks. I don't see how an after update on the record list fields would work as they wouldn't be updated to trigger anything. Come to think of it on change probably wouldn't work, either. I want to act based on a change to the recordset.

I agree with this and the above that people generally can't conceptualize "what ifs". Only an access developer will truly understand what they have in mind, so people need to see it working in its completed form to have their eureka moment. If you try to pitch this up front, it may sound nice...

I'll add that I would prefer it to only update the list if there are updates to make, thus saving resources when just viewing then closing a record without making changes. I'm not sure how to do that. Can we detect if there are any changes to the recordset after the requery and before the...

I'm in a similar situation in that my team needs functionality that we simply are not going to get from corporate due to the investment. That's where Access comes in and with careful development can be a brilliant solution that costs very little. Of course, they have a lot of apprehension...

Well, I'll be damned if it doesn't work. However, even though the recordset is requeried, the changed field(s) don't change until you leave the selected record using tab or other means. Another step would be needed to make it "instant". The other problem is new records appear in place of the...

I will try the recordset requery and report back the results.

Yes, and I appreciate them, but of course not all options are going to work. AppSheet and PowerApps sound close to what I'm looking for and will take some further investigation to be sure. I also found Amazon has one called Honeycode. I would like to have both a desktop Access database and...

Not really interested in remote desktop. We don't need to pipe in the full desktop application.

Looks promising, but I worry about using spreadsheets as a database. I'd prefer to work with relational data. I found Quick Base, but their pricing makes it not feasible.