database

Hi I've never really played around with Power Query before. I've written a large number of queries and someone very helpful has gone and moved the database to a different server. I would normally think that you would declare an object variable (let's call it qry) and then run a loop something...

I'm new to Power BI/Power Query and need some help. I connected Power BI to my database server and there is a field that I need to convert to date/time. The database stored the minute as the number of minutes since 24:00 on 31/12/1900. For example, 00:01 am on 01/01/1901 =1. I need to...

Dear All, I need help for building a Macro for my store balance for all products. My original excel file is here: https://drive.google.com/file/d/1dpASKSVYVb2BUu7HqSryIEsv-Yc31pSf/view?usp=sharing There are some sheets in the workbook. In the sheet named "Previous Database", I have arranged...

I'm having issues with the last part of my formula. I have two sheets, a results page (where the formula is written) and the Database page where all results will be stored. When I write this formula out on the database page, it works exactly how I want it to, just need it to work on my results...

Hi everyone, We create a lot of letters for clients and often find ourselves writing out much the same thing from scratch. I'm looking for a way to paste the text from the letters I write into a database spreadsheet, let's say column A, and characterise them with, say, up to 10 relevant...

I want to open my access database from my excel sheet which has the file path in a cell. Sub GetPath07() Dim FName As Variant FName = Application.GetOpenFilename(filefilter:="Access Files,*.acc*") Sheet1.Range("B18").Value = FName End Sub is there a way to open this database...

Hi guys, Macro basic level user here. I have created a macro but I need some help to get it a bit slicker as I have bolted it together like lego. I would also like the macro to repeat by looking at a list as opposed to me running it 200+ times. Current code: Sub NEXTINLIST() Dim v...

hi I want to get data from SQL, the problem is that in this SQL there are several databases each for different company the tables and model in each database in the same SQL host is exactly the same I do not need one data base but several all together finally I wish to create dashboard and...

Hey everyone, Although this account is new I have been around before and ive always gotten good answers and im hoping once again i may get some help. This question is about how to convert a single line of parameters into slightly different static parameters. I could quite easily create a...

We've been starting to have problems with some of the databases at work. For no reason that I've been able to discern, some of them have started to produce the "Unrecognized database format" error that is frequently mentioned online. So far, I've always been able to recover the database by...

Hi, is it possible to create a database in excel? What I mean is, can I save details from a worksheet to a different worksheet then I can query it up when needed? If not, can you suggest alternatives? Thanks

Hi all, I'm looking to replace a legacy system to select adverts from a database which uses some pretty beefy VBA code with a new system that uses criteria to take the information from the same database. My question is whether autofilters are a good idea or if there's an inherent fault with...

hello, can you help me with that code, i'm new with excel (you can say that, i don't know a thing about it), i just create this code by: copy and past from here and there,, without knowing excatly what it does mean.. but, he is work perfectly. now i have a small problem, the code is taking too...

I have a workbook that has 5 similar Sheets worth of data in columns A:U. Is there a way to create one giant database out of the 5 using VBA? Little out of my element and macro recording ability. Thank you

Hi, I am a creating an inventory database with about 100+ items. I am using a userform to select the ITEM PART via combobox, PO# via textbox and QUANTITY via textbox then enter it into my inventory database. What I would like it to do is search for the item number that was selected in the...

Hi all I have a excel database with a capture form (not userform - merely a separate sheet) running Macro to update a different sheet with the information captured in the capture form. Adding it to the last row. Now I need to find a solution to use a similar "capture" form or search form...

I have 2 worksheets.... In Sheet1, I have a list of 100 Static IDs ( they never change ) in Column D. Starting from D11 to D111 In Sheet2, I have a dynamic database ( updated daily ) of about 25,000 rows. Each ID ( from Sheet1 ) will appear ONLY ONCE in Sheet2.ColA. Need a VBA to delete...

Hey everyone, I'm trying to run a dashboard with 3 different tabs as display and 1 tab as database. Each display tab has a dashboard containing a ListBox and 3 TextBoxes. The List receives the data from the Database tab and the TextBoxes receive it from the List. One of the TextBoxes displays...

Hi, Im having problems with my formula for my database see below =SUM(SUMIFS(Data!AA$7:AA102304,Data!D$7:D102304,"*Prim*",Data!H$7:H102304,">=3.01",Data!H$7:H102304,"<=3.50",Data!S$7:S102304,{"AmberH","GreenH"},Data!Z$7:Z102304,{"AmberA","GreenA"})) The returns i get from using the formula...

This isn't an "how do I do something" post (yet), but an "is it possible" post. I don't want to invest a lot of time and effort into trying to create something if it isn't possible, so I haven't even started creating a database yet. My background with MS Access is as a user, not a creator, so I...