Search results

What exactly does that mean? I just tried this and although I thought I would get an error when I set the bound column to 0 but I didn't, the combo seems to work normally - displaying exactly what I selected and the textbox for the other column also displayed what it's supposed to. I can't see...

Just as another way of troubleshooting, could you try manually creating the pdf? So, on the affected machine, open the report in print preview. Then, click on the PDF button on the ribbon. Does it work?

You might be able to get away with using WiFi if the BE is SQL Server. Just a thought...

You can; but in a continuous form, it would reflect on all rows. Does it have to be a continuous form? This is not a problem in a single view form and also not a problem if the continuous form is read only. But if you want the user to see the dropdown, it gets tricky.

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.