Search results

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!

Have you tried the opposite? Make the subforms really small/narrow and set Can Grow to Yes.

It's hard to say if you should use a bound form in this case or not. Typically, you should use a bound form when you can if the data on that form are stored in a table. If you didn't want the user to edit the data, you could make the form read only. As you already know, to use an unbound form...

Glad to hear you got it sorted out. Good luck with your project.

=DateSerial(Year(Date()),1,1) =Date()

Based on the title of your thread, are you trying to do this using CF? If so, the answer would be "it depends." What is setting the colour of control B? If it's another set of CF, then you can try to use the same conditions on control A.

You can use a script or third party app to set the trusted location in the registry.