Search results

I fell victim to the "copy & paste" monster. :(

Ah, sorry about that... :)

Which version of Access is on the PC that is failing? Just wondering... PS. If you use the following code, do you still get the same error? DoCmd.OutputTo acOutputReport, "rptFinishedGoods", acFormatHTML, strServerFileShareDir & "All-FG not Shipped.html", True

Can you describe the main purpose for determining the IP address? Perhaps if the goal was known, someone can offer an appropriate approach. I was thinking of maybe using an HTTP request to get this info.

To see an example of what @Pat Hartman was saying, take a look at this demo. However, this version only uses a listbox to display the file paths. I'll have to find the one that uses a table and post it later. https://www.accessmvp.com/thedbguy/demos/listfiles.php

There's really no need to import the photos into a table. Access can easily display those photos from the folder on a report. All you need in the table are the filepaths. Take a look at Similar Threads below to see previous discussions on this topic.

Hi. Welcome to AWF!

Since the UserInfo table is automatically created by Access for linked SharePoint lists, the solution to this problem, if any, will probably have to come from the Access Team. I don't know of any workaround at the moment. I tried to ask GPT for some insight about this table, and below is the...

I can understand that. I use Access for other stuff too. I even used Access as FE to some SP lists before. But for this particular case, using only SP for the staff to submit their certs worked perfectly. The super is happy with it when compared to collecting them via email before.

Hi. As I mentioned in your other thread, I just use SharePoint for this with no Access front end, and we're fine with it. When you said 800, is that the total number? For example, we're required around 10 courses but with around 35 staff, that's only about 350 total certs per year. PS. I'm not...

Hi. Welcome to AWF!

Hi. Welcome to AWF! Splitting the database is a recommended best-practice approach, so you should do it anyway. If your database is already split, another recommended approach is to open and maintain a persistent connection to the data. Can you show us the design view of the slow query and post...

Hi. Welcome to AWF! I also have a certificate list in SharePoint and all I did was create a New Form, which is I think a new feature in SharePoint Online. I just put the link to the form in the site navigation and everyone was able to submit their completion certificates. I can view the list...

Maybe try the a GetObject() method.

I was going to suggest using a subform with the proper link on Serial and just use the following criteria in your query under the JobID column. <>Forms!FormName.JobID PS. You may have to requery the subform in the Current event of your main Form. PPS. Oh, and if you only want to see the...

Huh, I wonder if that's a new thing with newer versions. But like I said, I don't like exporting reports to Excel, because they don't usually retain the formatting anyways, so I prefer exporting queries to Excel instead.

@Gasman already told you how. I don't usually export reports to Excel; but when I did, I don't remember not seeing the header also exported. Do you have a complicated header? Does it have images?

The launch Excel bit is not necessary, because the OutputTo method has an argument to automatically open the new file after it is created; just set that argument to True. DoCmd.OutputTo acOutputReport, strReportName, acFormatXLS, strFilePath, True

Hi. Welcome to AWF!

@DHookom had the same idea (re: minimal height). Glad we could assist. Good luck with your project!