Search results

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 =...

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...

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...

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...

Hi all, I am having trouble with the concatenate function code on the Allen Browne website located here http://allenbrowne.com/func-concat.html I am using the textbox controlsource method on a report: =ConcatRelated("ID", "qryFutureReleaseDate", "FMonth = " & [FMonth]) The report is based on...

Hi all, I have a "search as you type query" that I have created based on the sample database here: http://www.access-programmers.co.uk/forums/showthread.php?t=188663 In addition to the search code I have included filters on the form. When viewing the query it goes down 20 rows and I've been...

Hi all, I have a ListBox that uses two different queries based on a text box value. This is for security purposes. One query shows all records and the other query hides some records when there is a certain flag. When the user accesses the form the text box is given a value and the appropriate...

Hi all, I have a ListBox that has a two options for it's RowSource. This is based on the users login ID (based on the value of a text box on the form) and is used to hide records from certain users. The records displayed in the ListBox can be double clicked and loads a form with record details...

Hi all, glad to be a part of this forum, I'm working on a task tracking database and thought it would be a good idea to sign up for support and to help where needed :) Cheers!