access table

  1. T

    Number Serial Numbers in sequential order by order of appearance

    I have a question about numbering rows of data in a Access table or query. I do not want to number each row but want to number each time a serial number appears in a table or query. I have already sorted by date and would like to have a reference in the table of each appearance of a Serial...
  2. S

    need help to import excel ranges to access tables with excel macro vba

    google is not helping with this problem. maybe i dont know enough about vba, but ive tried a few different vba samples and im getting nowhere. i have a sheet in excel that is used daily to track two different things. in the morning supervisors call me to let me know how many people they have...
  3. M

    Access Tables In Excel Cause Problem

    I have an Access 2010 database and I open several of the tables in an excel spreadsheet. All the tables are set to "read-only" in Excel. If I open a custom form in Access, I always get a warning, "You do not have exclusive access to the database at this time. If you proceed to make changes, you...
  4. M

    How to Read Data from Access

    I am using Excel and Access 2010. I am using the below code to get a record from an access table. How do I read what I got? It should select one record. How do I know when I didn't get any data? Thanks for the help Let ProvTxt = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & ThePath &...
  5. girlscout

    Push data from EXCEL into ACCESS form

    I am starting to learn how to connect between EXCEL and ACCESS using macros. And I've already figured out how to get my information from my EXCEL spreadsheet right into an ACCESS table. This works very nicely. What I'd like to learn how to do is take my information from EXCEL and put it into...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top