Search results

Hi Arnel, this is almost what I needed.. essentially I wanted this to work when the table is open. The table is linked to another database. And the form to fill is from this other database as well.. that's where my dilemma is at the moment.. Don't know if that's possible? I want that refresh...

Okay, I see what you mean. That does sound interesting. Will do some more research into it.

Mainly because the data that is on the FE is subject to change, and there was a requirement to have an admin keep data that had been processed on the FE verified via the BE. Oh so you're suggesting there need not be a BE user at all? It's just always been my understanding that changes made to...

Essentially the goal is for the front-end users to index information of files they are processing and the back-end user to verify those records match upto the metadata provided from a client. This verification doesn't have to be every record, just periodically over time to ensure things are in...

Hi, I'll try giving that a go. So is this suggestion to be made on the FE Master or BE? Thanks for your help.

Ok fair enough. Didn't realise it would be that complex actually. Sorry. Do you have a different approach I can take instead? Perhaps trying to coordinate signals/messages between FE/BE databases isn't efficient, but maybe there's a better way to sort of replicate that process? Where a backend...

When I mean add a record, I mean they use the form to create a record and that goes back into the table in the backend. Which is standard. Say that I have a user that uses the backend to monitor the work load of front end users who are working on the form. When the front end has created a...

Say that a user adds a record to the front end database. Is there a way to notify/prompt a message box in the backend database like: "This client version of the database has been updated, please refresh to see the latest records."? And then the user clicks OK and this automatically refreshes...

Ok, sounds good. Thankyou!

Ok so, I only really need to fill out the Master and Local Destination fields? The rest aren't really required. Also there is a button "Files to Compact / Backup" When clicked, this opens: How would I set this up, so that I can create backups? Say I choose 1 backup generation to be kept...

Hi thanks. I understood that, I just removed the file location for privacy purposes. My actual question was more so around what the the other 3 empty fields meant.

Here you go: So the fields are just confusing me a little.

I don't know if any other threads have talked about this program. http://www.peterssoftware.com/aps.htm It's an application starter to automate handling of front/back end (Fe/Be) database startup requirements. Just wondering if anyone has used it before, and if it works well for them. Also I...

Oh right, I think I had read this somewhere too and that's why I confused myself here. But yes, this is just Access I'm working on, so tables/data it is! Thanks.

Yep, I thought so! Just double-guessed myself there. Makes sense why. Thankyou.

So I have a query that is running a delete blank records on form_open. Should that query be on the front or back end file? Also while I'm here, same question for Modules.. do those go back or front end? Thanks.

Yep worked like a charm, thanks for that!

Awesome, this is much easier! Thankyou!!

Hi, I would love to hear your preferred method of preventing the user from closing Access! I just did it the API way because I got a lead on it from someone else's post.

Thanks for checking back with me!