Search results

This code works perfectly by opening a window and allowing you to select which file to attach to an email, but I'm looking to modify it so it automatically selects file types of my choosing (or even them all using *.* for all). Then to attach without having to press "Open" on the browse window...

Thanks to some great pointers here. https://www.access-programmers.co.uk/forums/threads/attach-all-files-in-a-folder-to-an-email.328699/#post-1888665 and http://allenbrowne.com/ser-59alt.html I have managed to fudge together a routine that reads the contents of a given folders into a table. I'm...

Hi all, I've searched in vain so thank you in advance. I want to declare a variable which points to a folder and then have an email created with all files in that given directory attached. They'll will be different names each time, but I want them all attaching automatically. Kind Regards

Im trying do do what I think should be simple i.e. calculate the number of days in a given month but I cannot work it out. Any help you be appreciated.

Hi, I'm sure I'm not the only one who wants to do this but I'd like to have a button from my control form that exports my query to a SharePoint folder rather than a standard local or network location. I've tried trying to define a string but it really doesn't like the whole url https:// string...

Hi, In a one to many situation, i wanted to pull a data set that will give me the last 3 results but present in 3 columns rather than 3 rows. So my example would be... Reference Note1 Note2 Note3 XXX Text Text Text Now I know I could have a formula...

Hi, I'm trying to get a formula in my query that full pull the last 12 full months + month to date. I've been using... DateAdd("m",-12,Date()) And Date() But this doesn't give a full month for April 2020 (which is the 12 month cut off) Cheers

Hi, On my report, I'm looking for what id presume a simple formula that gives me % increase / Decrease of the month on month figures as per the example below… Jan 100 0.00% Increase Feb 120 20.00% Increase Mar 150 25.00% Increase Apr 90 -40.00% Decrease May 105 16.67% Increase Jun...

Hi, I'm looking for a VBScript I can run with the windows scheduler that will... Open a Access DB with an mdw file AND... which has a database password So far I have... "C:\Program Files (x86)\Microsoft Office\Office15\MSACCESS.EXE" "C:\Dir\DATABASE.mdb" /wrkgrp "C:\Dir\MDWFILE.mdw" /user...

Hi, This is turning out to be very difficult. I simply want a button that when clicked will compact and repair the current opened database but without using sendkeys. Thats it, but all the code I can find appears very complex.

Hi, I have a form that certain fields are returned from a temporary table (that the contents are firstly deleted and then refreshed every 5 minutes). this causes the 3 fields to show #Deleted until a timer then refreshes the forms query. The form does work really well and is 10x quicker than...

Hi, I have a crosstab report that returns the last 3 months data and works perfectly. The issue is that time old problem where my column heading are year/month and move each month i.e July19, Aug19, Sep19 to Aug19, Sep19, Oct19 (when run in October). How can I dynamically create these? Cheers

Hi, I'm trying to return the last 3 full months of data up to current date, so if today is 24/10 the return would be between 01/07 to 24/10 i.e the criteria will always give me the full 3 months and the current month to date. Thanks in advance

Hi, I have a form which gives me my outstanding ledger to which I can make payments against and creates a payment basket (which has a unique reference) in a temp table prior to posting. What I want to do is run an append query that appends an exact copy of all records relating to that basket...

Hi, I have managed to create a task using windows scheduler which opens Access and runs a macro. The macro runs if I manually enter the Logon Password (which is set under "Manage Users & Permissions" > User and Group Accounts) under Access 2016. Is there a way to set this password in the...

Hi All, So I have a simple query that returns various data (including a Long Text field), except the field cuts off at 249 characters. Anyone come across this? Is there a solution for this? I'm using Access 2016 Thanks in advance Steve

Hi All, I'm really struggling here with Null values! I have a query (outstanding amounts) which feeds a subform and in turn a main form. This works well and the values are presented as they should. My issue is however when the query returns null i.e there is no outstanding values for a given...

Hi All, I currently have a small Access DB and looking for best practice settings in a multi user environment (20 users). My current settings are... Default Open View = Shared Record Locking = No Locks Other Options (which I'm unsure if relevant)... OLE/DDS timeout = 30 Refresh Interval = 60...

Hi, I have a field called "Status" and if this is set to a certain value (e.g Awaiting Approval", I want to prevent users from locking a row out and making changes. The reason for this is that managers routinely run update queries which set various values if they approve the input and if users...

Hi, I have several update queries that run to update various parts of my DB in a multi user environment. Problem is that when a user is in a record the query wont update that record due to record locking. Can anyone please help with a work around for this. Kind Regards