access table

  1. P

    Access 2019 Table of Future Dates

    Hello, I am hoping that someone can help me.... I have read some information about storing dates in an access table, but I am unsure about how to go about it. I am wanting to be able to lookup dates from a table based on a start date and a frequency (being weekly, fortnightly, monthly etc.)...
  2. 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...
  3. 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...
  4. 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...
  5. 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 &...
  6. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top