database

  1. J

    Law Firm Needing Some Excel Help

    I have used many CRM and practice management systems over the last 20 years and to be blunt, I don't like nearly all of them. Eventually, I would love to convert this concept into a real working CRM app that would work well for those who are tech savvy and those that are not. However, because...
  2. D

    Excel vba userform trying to filter ado recordset

    I have an excel vba userform from which I connect to an adodb (ms access), But I am trying to filter on the date (Datum) field. Both via sql statement or the recordset.filter method but neither seems to work. Here is my code: Private Sub UserForm_Initialize() Dim con As Object Dim...
  3. D

    Excel userform edit database table

    I have an excel userform where I can search for and create new database entries in an ms access table. But when I try to edit existing entries it gives me an error that the object doesn't support this action. here is my code so far: Private Sub EditButton_Click() Dim con As Object...
  4. D

    Populate excel listbox with database table

    Hi, I am trying to make an excel userform that connects to an access database. So far I can search and create new database entries from withing excel. But I can't seem to populate my listbox with a selection of my database table. Here is my code for initializing the userform and fill the...
  5. B

    Suggestions for Building a Historical Cost Database by Project

    Overview: I'm in the construction business, and I'm trying to build a database to keep track of project costs by project. I classify costs using a 7-tier hierarchy that is roughly 250 lines long, though many will not be used on each project. I want to build a dashboard that shows the historical...
  6. B

    Applying values to a database based on multiple criteria sets

    Im sure this may be a bit confusing, but i have a database similar to the first image. What i want to do is, based on the data on "Info" ranges, apply a value to the "Value" ranges. For that i had formulas such as "=if(A1 = "A",1,0)" or "=if(and(B1 = "red",C1 = "pear"),1,0)" which would get me...
  7. A

    Automated email prompt

    Hi guys, i have threshold sheet and i want to excel send me an email about any material it will be out of stock so, i want a vba prompts to execute this issue to send me an email if there is a material is out of stock automatically. best regards
  8. C

    How to get automatic data that will update for foreign users.

    Hello - I’ve been tinkering around with a sheet at work and I’ve been using various sources for getting data into a specific sheet so a group of 50 people can use. The best way I can query my data is through Microsoft exchange and applying filters to a specific email with excel attachments...
  9. C

    Copying cell data to another sheet.

    Hello thank you for taking the time in reading my post, I just need a little help, Already copied the data from sheet3 to sheet2 My problem is how do I make it to a simple database, I can't find a code for when I put data on sheet3 the next line of data will move into the next row, it only...
  10. M

    Help : Inventory Database

    Hi, I'm trying to create an Inventory Count Database in Excel using a Macro/VBA. The concept is for the Count Team to enter in an Item Number and Bin Number (which I have Data Validation on to prevent typos/errors). The Item Description is a formula that will pull the description associated...
  11. K

    When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding

    When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding. i was follow this code but not working pleased help me : Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Me.Range("C8")) Is Nothing Then...
  12. Y

    Power Query fetching data from database for every query

    Hi, Consider the attached image. I fetch a few 100k records from a database into SER_Base_SQL and MC_Base_SQL I add Table.Buffer() as the last line of code for each query Then I reference MC_Base_SQL in a new Query DueAssesments and perform some operations After closing the PowerQuery...
  13. C

    Help Creating Database of Resources Used for Specific Groups

    I will preface this quesiton with A) I work in the K-12 education sector, and B) I have very limited knowledge of databases - BUT I do have a pretty strong knowledge of Microsoft Excel and some experience with Power Query. I know there is a lot of different resources regarding many of these...
  14. tjdrake

    Multi-User Access DB Table

    Hello Team, I've been struggling with this all week, and am running up against a deadline to make this work for my team. Here are the essentials: The MS 2021 Access DB sits on a SharePoint Server; The SharePoint permissions have been granted to Everyone; The code updates with a new record...
  15. C

    New to Excel

    New to the forum Hi there, I have started my first leader role at work and I am trying to come up with a shift report system for my group. I have a spread sheet that I have attached. I would like my day shift and night shift to record data on here every 2 hours and then enter it each day. I...
  16. L

    Power Query: Copy earliest date/timestamp for connected rows to each of those rows

    Hi, Please see attached mini sheet. I am trying to transform a table via Power Query. The input data can be seen in the columns A to E and the desired output from Power Query are the same columns, but also including column F. The table rows in the mini sheet are sorted (partially manually) for...
  17. A

    Error Code:3349

    Hi dear all, I have an error while importing data into acess database showing error 3349.please check the screenshot attached.
  18. A

    Searching DB and population of Data issue

    Hello Excel Legends, I have been working trying to build a code to do the following but I cant get it to work and i'm not sure if it is even possible. Here is what i was thinking. In Sheet 1 (RTW) is a form with a reference number at the top (E3) eg: 07/04 - this number is dynamic and is...
  19. J

    Set Focus on last entry in Listbox

    Hi everyone, I am wanting to set focus on the last entry in my listbox, after I have added to the database. Currently my listbox only displays when an entry has been made. The listbox shows the complete database which is fine, but I am wanting to set focus on the lastline as this is the...
  20. P

    Autofill Companies based on Industry

    Hello guys, I have a problem regarding a database. For my master thesis, I have to analyze about 1110 companies categorized into their industry and their headquarters countries: The dataset: Now for the analysis part, I created a separate sheet (which I linked to Capital IQ database to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top