records

Hello all, I have created a workbook that inputs data from a different workbook via external links for columns A through F. I also have input data with no links in columns G through I. I need to constantly update the linked worksheet which could remove or add rows of records. I need a way to...

Hello everyone, I'm having some trouble getting this code to do what I want. I have an excel spreadsheet with a few tabs. On sheet 1, there are record names in Column A. The names are duplicated from Sheet 1 on to Sheet 2. Sheet 2 has a table of the records and headers that outline four steps...

Hi, I am trying to write a line of code to autofilter that will return the correct number of records if these records "contain" a certain criteria. The criteria is provided by the user using a ComboBox that is populated with the relevant ID number of the record. There are multiple records in...

So I have a table of records. Each row is a record that contains 5 columns of items. I created these records manually, but now i need to identify any records (rows) that contain the same values across the 5 columns. See below: the first and third records are duplicates because they contain...

Hello everyone: I'm trying to delete all records in a RecordSet ADODB Object connected to a Excel Sheet, using two differents ways: Delete records using an ADODB Connection Object Delete records using an ADODB RecordSet Object Also, as far as I know MS recommend to use the 2nd So, what...

Hello all, I'm trying to do a count of records that are "In Process" in column J, but only count once for each PR reference in column Q. For example, there may be 4 "In Process" records, but three have PR1 and one has PR2, so I'd want to count 2 i.e. not count the duplicates. Cheers, Jed

I receive an excel file each week that has the race of individuals noted as a single six character Boolean string (e.g., 100000 or 011000 or 000111 etc.). Each 1 or 0 is a "yes" or "no" to the corresponding races. First digit "White", second "African American" etc. As you can see, an...

Hello, and thank you in advance for providing input or advice if you can. I have a set of data that is almost 800,000 rows with multiple columns. I initially have to split the larger file up into smaller files to get it into ArcMap so I can spatially join the records and export it back to...

Hi, I'm fairly new to access and want to use it to store data which can be select queried from Excel. But also would like to update the records directly from Excel (only 1 workbook) So I seen you can create a linked table between a workbook and access, any data changed in the excel table is...

Let's say I have a workbook, Sheet 1 is called "Birds" and has everything you could ever want to know about birds. Column E is where I enter the type of bird in non-scientific terms, like Crow, Blackbird, Raven, Magpie, etc. These values are recurring so I could have several records for crows...

Hello All, I am hoping someone can guide me in the right direction. I am trying to delete records in one table based on query results from another table. I have two tables of interest: For clarity, call them Tbl A and Tbl B. Tbl B is entirely a subset of Tbl A with certain fields included...

I'm using PQ to get data from an external source. I'd like to change formatting for those records that are retrieved, but the formatting seems to disappear if I refresh. What are the recommended methods to keep the formatting during a refresh. BTW, I do have the checkbox checked that says...

Hi, Ive only been working in Access for a week so please be gentle :) This will probably be a silly question but here goes..... Im trying to create a search filter using a combo box in my access form. I have a table with multiple records. One of the table fields is called 'report type'...

I have a Field on my form that's a combo box. It defaults to "*". When the user makes selections or leaves it at "*" the value is used as the criteria in a query. My problem is that sometime the User will delete the value in the Combo box and then run the query. this ends up showing no...

I need to import bank statements and convert to excel, but in the conversion process in excel I get 2 or 3 columns for each line. In order to keep the records complete I need to merge all columns. There is way or formula that I can use to merge all the columns? Thanks in advance. Nick

Hi, In my company decided to upgrade excel from 2013 to 2016. Everything fine but now I have a big issue on reopening and saving old files. Actually it does open just when I want to save it (or save as...) I get multiple errors. When I open the "repaired file " I get this: Excel was able to...

I have a form that updates some records by pulling fata from 2 other tables. The first event worked with no issue pulling the brand from the "Items" table (It looks for the "ItemID" to match the records: Private Sub ItemID_AfterUpdate() Me![Brand] = DLookup("Brand", "Items", "[ItemID] = " &...

Hi All, I'm looking for assistance with a modelling question that I've hit a few times in Powerpivot: displaying only *related* row labels from the many side of the relationship, as a subordinate row label to the "one" side records. I have an example model screengrabbed that I think makes the...

Hi there - could someone please help me - I have been searching amongst many threads to come to a solution, but whilst there are many posts that help a little, I cant get the final result. I have a workbook that could have as many as 1000 lines. The data is formatted OK and ready to go...

I know there have been numerous posts about this error message, but none of the fixes has applied to me. I'm exporting to Excel from an Access table, and when I open it I get an error message prompting if I want to recover as much as possible. When I do, I see: Removed Records: Named range...