Search results

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 :)

I have a Report that groups by year so I have a year on each page of the report. The report pages return records from today onwards. There is nothing in the Report header. In the Page header I have placed the title with the year incorporated into the one textbox. What I'm trying to achieve is a...

Works a treat thanks!

Oh! I just realised the ConcatRelated function is concatenating all the month regardless of the year they are in. I changed the textbox source to =ConcatRelated("ID",[txtRecordSource],"FYear = " & [FYear] And "FMonth = " & [FMonth]) but this returns all TaskIDs for every matching Year and...

This is EXACTLY what I wanted :D thanks heaps. All I need to do now is work out the Expression to use in the Report Grouping that was originally derived from the query and the count of those IDs you helped me with (they all defaulted to "1" for some reason). I'll take a look at those...

Hey thanks for this code, I have tried it and there is a bit where the code is in red font color: "GROUP BY Year([Release date required]), Month([Release date required]) " & _ "HAVING (((Year([Release date required])) = " intYear & " " & _ "OR intYear = 0" When I run this code I get a compile...