Recent content by russmann2000

I have EdgeBrowserControls on forms that work/render correctly; they also render correctly on reports in ReportView, but cannot render fast enough for PrintPreview. They used to work, but for some reason the no longer do. I suspect something happened with an update to Office 365 or Access. Is...

Thanks so much for the help. I’ll check your suggestions and post the results later.

My main form (form view) and subform (datasheet view) are linked by ID. I can click on a record selector in the subform and the main form updates with the appropriate record. Since the subform is in datasheet view it has the ability to sort like a normal table (from the headers). When I sort the...

Thanks so much. That solved it. I tried a similar subquery earlier, just didn't do it correctly. I need to step away from the code sometimes, this was way simple and should have caught it. :banghead:

I want to list both the ID, and the CODE. It’s possible to have more codes, but I only want CODE 1 and CODE 2. If I use the sql in the original post, it gives me just the ID (obviously). I know it’s correct because I already know which IDs have which codes. It’s obviously necessary, I wouldn't...

I edited. I want the ID and the code. I want all of the IDs with both CODE 1 and CODE 2. 1, Code 1 1, Code 2 And so on. If I do like the code on the original post it lists all of the IDs just fine, but if I try to get it to list the codes as well, I get nothing.

I have a table with EMPLOYEE_IDs and a column (EMPLOYEE_CODE) with more than one value for the same EMPLOYEE_ID. I'm attempting to pull all of the ID's with more than one EMPLOYEE_CODE, can get it to list the ID's, but if I try to add the CODE I get nothing. This is what I have if I just want...

BRUH! Thanks so much, works perfect!

I have code I'm using to import a folder full of excel files and spitting out the data onto a word document. The code works good on the first run, but doesn't load the other files. I use the Dir() function to load the files in the folder but also use the Dir() function in another process to...

I have hundreds of spreadsheets that I will end up importing. All have the same cells I will be pulling, so adding a second sheet to each of those wouldn’t be feasible.

It's not making any sense to me at all. Thanks anyway.

I'm not understanding how that pertains to my original post of wanting to select specific cells in an excel spreadsheet, and importing that data to a table.

I have an excel file that's been designed like a form with data in cells that need to be imported to an access table. The cells are all over the place and are in no particular pattern. I know how to do imports on simple spreadsheets, but this has me left scratching my head. Is there a way to...