Recent content by ram_rtg

Hey NauticalGent, Thanks for your help so far. I have managed to resolve the DMax issue by incrementing the value of the customer ID by one instead of running Dmax+1 again. The reason why it was failing (I think) was because there was no real-time or persistent connection to SP. Even...

Thanks for your help. The message is a MS VBA information one. It is coupled with the Enable content button in the Yellow bar. Please see attached.

I am using MS Access to automate a process which involves opening multiple MS Word files. I am trying to find a way that I can open them via VBA without any warning messages coming up. If someone has to sit here and click OK it defeats the purpose. I know I can use Application.DisplayAlerts =...

Yes that is correct. I had to link the list afterwards. I was using the autonumber PK ID field however I have had to remove that as I was advised it was not good practice to have an autonumber as a meaningful field. So I had to programatically create autonumbering using Dmax+1. Also if I have...

Hey thanks for all your help, I have moved the data to SharePoint and after many hours tinkering and playing around I think I may have stumbled on solution regarding the number of character restriction. As a part of the migration process I had ran the query that identified all the records that...

Thanks for your help. I have just tried a compact and repair however the error still persists. I'm thinking that perhaps I need to get to the data tables whilst there are no users accessing the database to ensure just in case that is affecting something. In order to identify which records had...

Do you mean that the "Enter" keys are the equivalent of 4192 characters? There wouldn't be more than 20 of them in each memo field.

Hi everyone, I want to convert the back end data tables of my split database (Access 2013) into SharePoint 2013 lists. The first step I did was to make those tables local to the database then build the database sub-site on SharePoint. I then proceeded to export those tables to SharePoint by...

I need a Link checker that can scan through a page and ignore the links that the JS will rectify when the page loads but still identify the others that are broken. I don't need to use Access. I started off with Excel initially however I generally find Access to be a bit more faster so I...

It's a nice simple interface so I downloaded it and running it now however I still think it will not be ale to incorporate the JS that fixes incorrect links once the page is loaded.

I've used Xenu in the past and it was pretty good however it's a bit slow for our website and doesn't take into consideration the JS used to rectify the incorrect links when the page is loaded so there will always be some more work after I run it.

Hi everyone, I'm wondering if anyone has attempted to use Access to identify broken links on a local website. I know there's a lot of tools out there that already do this but I would like to build one using Access. I searched the forum and looked in the sample databases but couldn't find...

Welcome to the site, Hopefully you get the answers to your questions :)

I just want to add my experience with this. The code above works perfectly however in my case I just needed to adjust the "Top" distance. I was able to simply change the "Auto Center" property of the form (under Format tab 12th one down) to "No". This will allow you to manually position the...

Thanks Paul, you've come to my rescue once again :)