Search results

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.

This might work if I created a function that ran through records in the database and spit out pdfs or whatever the most appropriate format would be that could be stored and recalled from our Google Drive or MS One Drive. Ideally we'd have working forms on mobile but this at least gets everyone...

I have the latest Access and I don't think Access Web is an option anymore.

Probably.

Hey all, My team has a lot of functions that are done on spreadsheets and I'm eager to consolidate and simplify our processes with a new database. However, I want everyone to have access to certain things at any time via mobile devices. That may include various lists like a roster or financial...

You seem to know a lot about this. :unsure:

Other than the hot pink it looks okay. ;)

When the site was updated, we had Default and Shades of Grey (Blue Text). Even though it was much more than just blue text. Then you added back Shades of Grey and I switched to it. I see you renamed the other one to Shades of Blue.

The new Shades of Grey is even better than the old one.