database connection

How can I have dates be on 8 Week rolling data but always start at a Monday? For instance this is what I did to get it to start from 8 weeks ago: But I would want it to actually start on 5/2/2022 because that was the Monday of that week.

Dear Experts, I am creating an excel tool that connects with an MS Access database stored in a remote location. Generally, it takes around 10 seconds ( sometimes faster depending on the internet speed) to run the query and get results back to the excel sheet. Currently, the form and the excel...

Hi folks, Currently I have a work related excel file (actually 4 copies as the DB grows) that has two parts: 1) A set of vba modules that loops through various arrays on multiple tabs to calculate and summarize results to a main dashboard. That works fine. 2) The raw data arrays from various...

Cross-posted at: https://www.excelforum.com/excel-programming-vba-macros/1355803-update-data-to-match-worksheets-instead-of-deleting-entire-workbook.html Reason: It has been up there for a few days now but no reply apart from my own replies. Link to work books...

Hi, I'm new Userform and when the form activate a dropdown list must be populate. I can't get my project to connect to the SQL database. With all my searches I found these code but I have no idea where to place these code. I have tried to place them in Userform activate but I get an error...

Newbie question: In a project with a number of subroutines and functions that query and update a database, is there an advantage (or disadvantage) to having just one global database connection that is opened upon initialization of the project and stays open until the project is closed?

Hi everyone I have a spreadsheet which has many connections to various databases, every month one line of the command text in a large number of these connections needs to be changed, i.e. from 'between 1222 and 5222' to 'between 5223 and 7234'. Currently this is done manually which is quite...

Hi everyone, I'm trying to connect my Excel workbook to a postgresql database. I've found this link on the internet but it didn't really helped me. https://support.office.com/en-us/article/Connect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4 In fact, they are...

Hi everyone I have a spreadsheet with a lot of tabs that looks up to a database and needs refreshing every month. However the command text has to be changed in each tab every month. I have worked out how to change the entire command text to a value in the spreadsheet but it changes the whole...

I am managing the volunteer hours for a volunteer fire department. In a nutshell, the member logs in to the website, fills out a form, and then at the end of the month, the admin exports the data. The website template provider doesn't allow us to change the export features, but we can change the...

Hello, I have a workbook that's set up to query a database and return values. I need to send this workbook to others who do not have access to this database. If you don't have access to the database, errors are returned rather than the values. What I need to do is somehow copy and paste the...

Hello, mrExcel! This is my first post, so please be kind. I have some moderate VBA experience. Here is the situation I am seeking advice on. I am part of a compliance team and I handle the 'automation' part. We are currently in the midst of a User Access Review that is being handled via excel...

Hi, Quite new to PP. I can already produce quite useful dashboards with slicers. Problem is that the reports need to go to a target audience (Exco) and they are not using PP (whole corporation is on XL2010). What is needed to be able to share the dashboards with connected databases? I tried...

Hey everyone, So I have a materials database made up in mySQL, which holds linked tables for materials, manufacturers and vendors. I also have a Bill of Materials (BOM) in excel, in which there are empty columns for manufacturers, vendors, etc. The goal is to have a Macro button that, once...

Hi I have two different access files. One is 2010 format where I have the form and another one is 2007 format where I have the table and this file is in a different path. Is it possible to search and pull the data from table to the form using a command button. If possible please help me with...

Hi All, The below code to connect excel to oracle database is showing run time error. Error at : src_conn.Open varConn Did anyone phased this issue before? Please let me know if anyone can resolve this issue.... :-) Private src_conn As ADODB.Connection Private Rec_set As ADODB.Recordset...

Hi I have a table in Access linked to 3 separate Excel sheets. They contain user forms which update the records in the table with information input into the form. Within the userform code, I'd like to do 2 things: 1. Update the records in the datatable with the user form info 2. Refresh the...

Hi, I am looking to connect to a Microsoft SQL Server 2008 db with VBA and pull data with SQL. I would be using Windows Authentication. I've tried googling but couldn't find any MS SQL SERVER 2008 specific guides on how to do so. I've found this but I am not sure I understand how it works...

Is there a way, in Excel, to determine if a table in Access exists? I have code which currently sets up a connection to Access and returns data to Excel from a Access table. However, if the table does not exist then I want the macro to do something else. Thank you.

Hello everyone, I have a table connected to a survey hosted on SharePoint. As new responses are added to the survey they are brought into excel. In the same workbook on another worksheet I convert the answers from the survey into values, tally the values and determine an overall score. Being...