database

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. Z

    Changing Databases with a dropdown

    If i have 10 different MS Access databases linked to a workbook. Can you make a drop down just to select which database to work off of ? My thought is to have the databases be selectable in a dropdown and for all the information for that database populate a predetermined sheet. then all...
  8. D

    Getting External Data From Access

    I created a split DB that is used throughout our small office. A couple of my coworkers need to move some of data to Excel from the tables in the back end that is housed on a shared volume inside of our LAN. First I setup the connections Using the basic "From Access" wizard, but that tool...
  9. Nelson78

    Ideas about how to produce reports from a database

    Hello everybody. I've just taken charge of the database you can see in this link. From this db, updated day by day (see column N), I have to produce some reports. https://imgur.com/wHb7VtH First of all I want to specify that my predecessor used to manage the reports with formulas, for this...
  10. J

    Need a program to auto update of SI.No in Excel database

    Friends, I am developing task based database using VBA, I also developed user form similar to Data Entry (DE), * For that I need a program to auto update of SI.No in database automatically incremental immediately after invoking the DE User form using last SI.No in the (particular row)...
  11. S

    Access Database Form Wont' Allow me to Update Records

    I'm ultimately trying to setup an access database form, that has current data in it from an imported excel file that can allow updates. I have the form built but when I try to type in the fields it says "This Record set is not updateable". I do keep trying to setup the primary key but it won't...
  12. E

    Using VBA to lookup a value and write back to that row in a different sheet

    Forgive me here guys. I'm completely self taught but have zero knowledge of visual basic and have come up against a problem that I believe can only be solved by visual basic I have a worksheet of customer information called "data" I then have another worksheet called "Agent View" The agent...
  13. kelly mort

    Verify if item exists with a given ID

    Inside column CA, I want to count if the input from a textbox exists with a different ID. Textbox1 is for the ID and Textbox2 is the item name. I am doing this verification during the update process. That's after I have clicked on a listbox to load my textboxes. I don't want same items...
  14. P

    Auto Fill a Form from a Database

    I have created a database for job lines in a plumbers that I work, for tracking new jobs. The database is completed using a data entry form to provide a new job number to a job. I have also set up a blank job line that gets printed out to give to the engineer that is going to this job. I have...
  15. A

    Method for maintaining listbox possible values

    Hi, I'm usually an Excel person and not so much an Access person so please forgive my stupid question: I plan to build a database which in various forms rolling up into various tables I want to control selection choices a user can make. Some of these list might be 3 options long, some might be...
  16. M

    VBA delete from SQL DB syntax

    Hi, Snippet of code that fails is bold in below. BTW INSERT INTO works. DELETE FROM (see below) does not. -------------------------------------------------------------------------------------- 'Opens connection to the database cnn.Open ConnectionString 'Timeout error...
  17. J

    VBA userform to check duplicate but ignore blank entry

    Hi everyone, I'm a relative newbie at all this but I have created a user form where a specific numeric entry is required in column d. So I need a code that checks the database for this number to prevent duplicate entries however some of the time this number is not always available and will be...
  18. I

    VLOOKUP based on drop down list

    Hi, I need to select a value from my drop down list and the code will look at three values in a database then put them in three next to where the drop down list is. Here is the info for you. Worksheet is called TEST Drop down list is in column B Cells awaiting data are in column C, D, E Table...
  19. C

    Create database and league table based on products from multiple worksheets

    I have a document with worksheets named WK01 to WK52. Each week I want to paste a series of data in to these worksheets. The layout and format will be exactly the same each time. Only the data will change. In column E of the week worksheets there will be a name of a product, column F the...
  20. L

    ODBC Connection to Access in 365

    Hi, I have a file in which I created a new ODBC connection to a query in our Access DB in Office 365 by going to Data > Get Data > From Database > From Microsoft Access Database and searched for the query and added it. It works fine and refreshes for me; however, my peer is getting an error...

Some videos you may like

This Week's Hot Topics

Top