Search results

If it's any use, I use this on close in multiple databases, to back up the various back ends. No problems, thus far. Function Backup_Backend() Dim strPath As String Dim strFile As String Dim strBackUpFile As String Dim strTempFile As String Dim strBackUpFolder As String...

I'll get on that now (before I get pulled onto something else). Many thanks.

I would assume so, yes. Looking at the db now, I think I may be able to recreate it with a very stripped down version and some nonsense data. What form is preferred for uploading? Zip files?

Thanks for the response. In order: Yes, it's survived that long. As I say, from the users' perspective nothing is wrong. It's only when changes need to be made. Any on the last few years have been small, so I made them and moved on to the next thing. It's only now that I have to make more...

Have you tried importing everything into a new, blank db? Takes longer than the compact and repair, but it's helped me in the past.

I had a similar problem, some time back. In my case, the db had also increased in size by a fair amount. Running a compact and repair fixed the problem. It turned out that one user didn't like the small amount of extra time it took for the back up process to run when the db closed (we're talking...

Much to my shame, I was pulled onto other tasks after posting this question and was never able to devote time to get to the bottom of it. Now, however, I'm back working in the same db and would like to try to resolve the problem before something more urgent comes up. In summary: I have an...

Okay, so the following works for what we need. It's a simplified version of what I was originally asked for, but it's going to do the trick. Background 1. Someone is sent an email with a link to a document they have to review. 2. A list of emails sent is stored in a local table 3. They reply...

Thanks a lot. That's exactly the situation we're in. I'll have to set aside a bit of time and work through that.

Thanks for asking. I don't have any experience of doing that, but I'm open to any method that may work.

I get the distinct impression that I'm expected to try to find a solution that won't involve SharePoint at all. The manager's a little disenchanted with it at present, so I need to start in that direction. The initial test is to see if I can send an email to someone, have them complete a field...

Funny how often that seems to be true - one hand giveth.... I had a feeling that was going to be the case. In your opinion, would it be advisable to sort out code to 'pull' the data into Access from the form or 'push' it from the form into Access?

We're not just using Access because some of the users, although within the same company, don't have access to the database. The Sharepoint option isn't working. I have no idea why, I've never used it and haven't been involved with the project until today. The database in question already send...

We already have Outlook, is the short answer. The manager found an article about collecting data using it and the idea stuck with him. I'll keep looking into it, today's only day one. I just wondered if I was missing something obvious regarding the erroneous version message. Thanks a lot for...

I have no idea, sorry. :( My 'technical' work solely involves Access. They just told me that the SharePoint thing wasn't working and asked about Outlook.

The reason I was asked to look into this is that our IT dept have been involved in a project for some time, trying to get sharepoint to do what we need it to, without success. My manager found an article about using Outlook and asked me if it could be done that way. It's mainly to store the date...

Damn. Thanks for that.

I have Access 2010 installed. I also have Outlook 2016 installed. The different versions are a company decision and I have no say in it. I'm making an attempt at creating a data collection form that will let me gather information received via emails directly into a new db. I've found a tutorial...

Finally, it appears to be working. The solution was to add a short delay (using a new sub procedure) in between the part that creates the query and refreshes the database and the part that checks if the query exists before exporting its contents. Changes shown in red. I tried with a long pause...

Thanks for the feedback. I was trying to get something to happen. Each time the code fails, I can see that the query does exist so I was experimenting to find out what would happen if it tried to delete it again. The one was a mistake. The move next used to be outside the if statement but I...