database

I am in the process of building a student database on excel which includes 30+ classes and 4 variables per class namely, 1. enrolled date, 2. city, 3. country, and 4. payment method. As this database will be used by a company that has no employee who can use excel well, I will have to avoid...

Hi, I have a spreadsheet with 40k rows or so which is added onto every week. Each row has an Employee ID, Employee’s Shift Number and Hours worked column (see attached image for sample data). The problem is that I have the work out the Hours worked from a database to which I have an ODBC link...

i have no clue to doing this man, i expect the output is to be the right chart, but on the left chart is what i’ve done i want the cell to still remain the same number even the row is deleted and if i add new no. it still going +1 i need your help guys

Hi all, I’ve been struggling with this for some time because I need to use formulas to automate the new database column, not VBA or power query. Essentially what I want to do is create a column that combines two other columns but the difference is appended to the bottom. For ease of explanation...

I have a data base of films, one field name is cast and some films has more than one value in one cell. Let say film A has Martin Speer|Russ Grieve|John Steadman|James Whitworth|Virginia Vincent as cast and film B has Lindsay Lohan|Gus Van Sant|James Deen|Nolan Gerard Funk|Amanda Brooks as cast...

Hi All, Currently, no field can be empty, when I hit save. My question is, how can I make it so that when Primed is selected and any other fields are empty it would auto writes N/A on the database when I click save? Function ValidateEntries() As Boolean ValidateEntries = True...

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 there, I'm not even sure how to title this question properly and I think it is best demonstrated with an image. I'm not sure if this can be done but I would certainly like to try. We have entries for various units (2026 is just an example). I would like to conditionally format the cells so...

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ1WILDERNESS FIRST AID LEVEL 1& LEVEL 2 PFG 15C02 AUGUST - 06 AUGUST 20212LOCAL0MAXIMUM PAX 203INTERNATIONAL20PROVISIONAL BOOKINGS204OFFICIAL BOOKINGS05CONFIRMED BOOKINGS06AVAILIABLE SPACE07WAITLISTED08NOOUTSTANDING FEES BOOKING STATUS PROVISIONAL OR...

Hello, all. I'm looking for some help on a thing I am working on. On sheet named "status" -which is also the database, you can see columns of information. Basically, what I need help with is I want the data to appear on the calendar I created on "Main Tab" in 1 condition: it is "Approved" as...

Hello all, I'm trying to improve the inventory management process at work, currently we're tracking everything through manual input (handwritten) using a form and then we put any relevant information on a sticky note and post it to the box. These boxes come in from numerous different places and...

Hello guys! I need to make a database viewer on excel, a simple form to show some infos in one place. i`m new with VBA, so i`m trying to do by myself, but every time i got stuck with the code. here`s the thing, there`s more than 1 sheet and i need to work with it dynamically and with a image...

I have a database spreadsheet where I need to pull key information from the master data. As you can see in the below screenshots, the goal is to return the "Part Number" and the only data I can match with are the "Kenn" and the "Part Code", "Kenn" can be directly matched with "KENN No" from the...

Hi; I made a workbook which contained the data of equipment (A to AZ) available from a Facility with 6 additional columns which has the latest maintenance date that is inputted by the maintenance foreman. In which the next date maintenance should be done is shown how close it is and a color...

The variables Option Explicit Dim objFSO, objFile As Object Dim objConnection, objRecordset As Object Dim LastLocalChange, LastDbUpdate As Date Dim DbFile, ConnString As String This part of the code sync to the database: Sub SyncToDatabase() DbFile = Sheet1.Range("M5").Value 'Customer...

Hey experts In our org, we have a big problem people enter all kinds of data wrong like name with spaces, name in short and ID wrong Until we figure out the solution, we are non profit, I am asked to come with a immediate solution and long term which I suggested is front end ( another story, I...

Hi I have been trying to search for a solution for days to no avail. Basically below code should take a specific value (C2) from ThisWorkbook and find if it exists in Sample Db (Column D), if it doesn't exist, it will populate a range of data (Column A to AI) from ThisWorkbook to Sample Db, if...

Hello! Here's a quandary I've been mulling over at work. I need to create a .xls that will: Connect to the org financial database, which is not editable and cannot be added to. Not a problem, as I have database access all set up. Display month-by-month revenue in a pivot table, with customer...

Hi everyone, Is it possible to display the number of grouped items as a value or as a bracketed suffix to the name? For example: Accessoires would show "Accessoires (12)" and Accessoires Indoor would be "Accessoires Indoor (39)" even though it is collapsed. Alternatively, B3 would show the...

Hi, I'm trying to connect to an SQLite database that contains financial information about various companies. The code will then put the information into a worksheet for me. Currently I am having to hard code the symbol of the company that I am wanting to search in the database for. This works...