VBA Express Forum » Access Help
16 FOLLOWERS
This is a community for enthusiasts who are interested to engage in discussions on Microsoft Access. Furthermore, get help for making small VBA codes, report relinking code issues, and discuss how-tos.
VBA Express Forum » Access Help
1w ago
I have a customer a couple hundred miles away with about 10 users. Their database has corrupted. I need to reorganize it. And can do that by using a copy of the database. But I need to restore the copy of the database to the original location. There is a locking file preventing that. My customer claims there is no one currently signed on to the database. But the locking file remains.
Is there a way to delete the locking file? I'm SOL until I can get through this block ..read more
VBA Express Forum » Access Help
1M ago
There is a way to hide the tables from the users even when looking at a table view. I have a customer who I hid the table names from many years ago, but can't remember how it is done. I need to get back into some of those tables now, but can't see the tables in table view. What commands did I use to hide the table name originally ..read more
VBA Express Forum » Access Help
4M ago
I searched and tried a lot but cannot find out the solution for the problem.
Can anyone do me a favour with this, please.
https://drive.google.com/file/d/1lZE...ew?usp=sharing ..read more
VBA Express Forum » Access Help
4M ago
A user called me today to complain that the tabs at the top of pages that allow users to hop between screens in MS Access have disappeared. She's one of about a dozen users at this account, and none others have this problem.
Is there a setting in the setup that controls this ..read more
VBA Express Forum » Access Help
7M ago
hello everyone.
I have a dental clinic management database made in access. And I have an IoT project that can display data from a google sheet. i want one of my access table to be always in sync with that google sheet as i want to display it in the IoT project screen. it's only a couple of rows and coloumns. i tried codes from chatgpt using google api key. tried google form response id. nothing seems to work. can you help me with it? thanks ..read more
VBA Express Forum » Access Help
8M ago
Hi All,
This is a requirement of an existing code. The below code works and saves the attachment and also marks the read mails as Processed.
But I need to move these Processed mails from the Inbox to the folder, Archive_Proc. I am trying to Set the folder, objDestfolder as the destination folder for these processed mails to be moved. But I am getting object not found error (bolded line).
How to fix the code?
Code:
Dim olApp As Object
Dim MYFOLDER As Object
Dim OlItems As Object
Dim olMail As Object
Dim x As Integer
&nbs ..read more
VBA Express Forum » Access Help
8M ago
Hello.
Is there a way to have user and time stamp on a simple access file (*.accdb), that will be used by several users ( 5-6) that will just change and add thing in the file in different locations at the same time?
And actually if it can work this way without loosing info while saving ..read more
VBA Express Forum » Access Help
8M ago
Hi All,
We have multiple Access databases on our shared folder used by our team.
Now the company policy requires all shared folders to be on SharePoint.
Is putting Access databases on Sharepoint advisable for multi user environment? Does this mean a User has to check out to work on their edits and check in?
How to go about this since some of the FEs have their links to one Master BE. Will that cause any locking or performance issues?
Also, the databases contain sensitive personal data which makes me wary of SharePoint on account of security. How to restrict the security while in SP?
TIA ..read more
VBA Express Forum » Access Help
9M ago
Hi,
I have posted this on Mr Excel too Code to read Outlook mail with specific subject | MrExcel Message Board
So, apologies for cross posting!
Admins, Please delete it, if this should not be done.
I have this working code which reads the mail and its attachment into a local folder. It is working well.
But a new requirement is to read the mails with subject containing the words, Customer ID 1000 - Smith, JOHN P, where the word Customer ID is always static but the number and name is dynamic.
I am not sure how to resolve this as my modified code does not read the mail which contains the word ..read more
VBA Express Forum » Access Help
9M ago
I had sought help with Mr Excel in this thread link, Run Outlook rule | MrExcel Message Board
They asked me to seek help here.
We manually run a rule everyday, which executes a script in Outlook. This reads attachments in the inbox from folder, WeeklyProceedings Mailbox and saves the attachments to a folder in the shared directory, S.
The Access database imports these Outlook attachments files into a table.
Since this job needs to be done before all users log in, it is done manually by a User at 8.30 am everyday.
I am trying to automate and run this as a Scheduled task without manual inter ..read more