database

  1. V

    Help Filtering Data

    Tossing this out to the Excel geniuses of the community. I need help creating a spreadsheet where I can associate an author’s statement to multiple keywords. I’ll have hundreds of individual statements with multiple keyword associations for each statement. I need to be able to search for those...
  2. A

    School Project

    Dear friends i am in need of some help. i am quite new and learning. i have done some work on it but dont know how to continue now. So basically i have a ''master'' called sheet that has a list of students from A6 TO A36 and their student ids from B6 to B36 and from C6 to C36 to have their...
  3. R

    Duplicate Databases (2 worksheets) - No Master

    Can there be 2 identical Databases (2 worksheets) that synchronize both ways (insert to 1 updates 2 / update 2 - updates 1)? Here's the scenario I want 2 worksheets to be identical, where one sheet will contain A-P and the other Sheet will contain Q-Z. But if I update Worksheet 1 or 2 they...
  4. P

    Saving and consult images with macros

    Hello dear, it is a pleasure to be part of the Mr Excel community. My query is based on the following: I have a budget management system made in excel that uses a spreadsheet to make a certain budget and saves the information of each budget in another spreadsheet that is used as a database to...
  5. E

    How to check this database for duplicates?

    Hi all. I prepared a small example database but it seems that I'm not allowed to post an attachment so I'll try and explain my dilemma by using one of the above tables. <tbody> A B C D E F G etc etc etc etc 39 6 23 34 2 7 26 8 3 35 18 22 7 23 2 39 6...
  6. N

    VBA copy/paste data based off of column headers

    Hi everybody Long story short, I work for a construction company and I am in the process of making things much more efficient. I have built a small database in Access and have a connection pulling all that data into my workbook. Currently my database has 70 columns and will be expanded to...
  7. D

    Looking for samples of Client List Database where Dates and/or Number of Visits can be tracked

    Hello all. I'm a basic Excel user trying to create a spreadsheet for a friend - also a basic Excel user - who owns a dog grooming business. It will be your standard client list, with a few special columns like: Special Needs (like muzzle - will bite, or soothing oatmeal shampoo for skin...
  8. I

    Part of my code has stopped working

    Morning, I have a worksheet called INV that when i select the drop down arrow in cell G13 i see a list of customers names. These names are on another worksheet called DATABASE of which is in the same workbook. Selecting a name then copies certain cell values from the customers entered info on...
  9. gheyman

    Updating Linked Tables to Back End Problem

    I have a Back End (BE) with all my Tables. When I am solely in the Front End (FE) Database everything runs fine. As soon as another user opens and uses the Front End database the database somehow is loosing the links. We get a message that it doesn't recognize the back end and we have to...
  10. T

    disable design view in Access

    I am trying to disable the design view so user cannot make any changes. Greatly appreciate if you can help or what other option I can do to protect my database from being modified. Thank you!
  11. E

    Exporting only one row from a spreadsheet into a database in Access

    Im trying to find a way of exporting one row of data from a spreadsheet into a database in Access. I ideally don't want access to open in this process as it sometimes causes everything to not respond. I had though about a simply recording a macro to copy & paste one row into access but I think...
  12. J

    Run Access Function from Excel without opening database

    Hi, I have the following working code in Excel that inserts a record into an Access database table. Can it be re-written so that there is no open/close of the database application? Sub New_Job_DB_Test() Dim r As Range: Set r = wAdd_Job.Range("New_Job_Record") With...
  13. S

    Auto generation of serial number in user form

    I have a database in sheet 2 with certain serial numbers and a userform in sheet 1 that allows me to manage this database, including adding new entries. Each entry needs to have a unique serial number. The serial number can not be duplicated. The serial number follows this format TARA-SS-001. I...
  14. J

    VBA Code for C&P from two workbooks into a Master Workbook

    Hi all, New to this board, and hoping to get some good advice. My team conducts a lot of data pulls to create reports, and they are all very time consuming. I'm trying to better educate myself in becoming more efficient in excel. One of the reports we do, is a Reconciliation between two...
  15. B

    What guidelines I should follow while editing ‘Globe with blue arrow’ table

    Hi I understand ‘Globe with blue arrow’ tables are liked to external tables. Have few of such table in my database. What pre-cautions I must follow when trying to play or edit such tables. For example, if I try to check ‘Design View’ of such table, access gives me warning. Table is a linked...
  16. bs0d

    ADO SQL Query - Multi Users, Schema Name Required?

    I created an Excel workbook that uses ADO query a database on our SQL server: Set myConn = New ADODB.Connection Set myRS = New ADODB.Recordset strConn = "PROVIDER=SQLOLEDB;DATA SOURCE=db_server_name;INITIAL CATALOG=database_name;INTEGRATED SECURITY=sspi;" myConn.Open strConn...
  17. K

    Split Access Database Keeps Crashing

    We recently upgraded all our systems to Windows 10 64 bit and Microsoft Office Professional 64 bit. We were using a split access database with Office 2013 which was working perfectly. Since the upgrade, when using the database on one of the systems, it constantly crashes and then Access...
  18. B

    Keeping ADO connection open at all times

    Hi, I have an application built from an excel userform where users connect to an access database to pull and write data. However, now we have a decent amount of users using this program I want to keep track who is in the program. The best way I could think of was to create a second database...
  19. M

    VLookup on 3 Columns Formulae

    Good Morning Thanks for Reading I have two spreadsheets one called Switch Info and the other Database Master, I am looking from the Database Manager to the Switch Info Both Have three columns called Login (Column A), Device (Column B) and Numbers (Column C) First Formulae I need a lookup to...
  20. M

    ODBC Microsoft Access Driver Login Failed

    Hello All, I have an excel workbook which is linked to an Access Query via the Data>Get Data Essentially, each morning, as new data becomes available I right click and hit refresh and it updates for me. The past couple of days I have started to receive the following: "ODBC Microsoft Access...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top