Search results

> go Entra only This can be enforced in Azure Portal > your SQL server resource > Settings > Microsoft Entra ID > check the box for Support only Microsoft Entra authentication for this server.

> how do you ensure that the database stays up to date with any changes or additions That can be very tricky. Let's consider how others like MSFT do this. The Windows API is one of MSFT's code libraries, and it has been VERY constant with regards to the public interface. They have to. If they...

Do you want to return records from the table that match the array values? If so, you can create dynamic SQL string with the IN clause: Sub testDynamicSQL() Dim sql As String Dim aryCodes() As String Dim varCode As Variant aryCodes = Split("code 1,code 2,code 3,code 200", ",") sql...

If detecting Preview > Print is difficult, one new idea is to not have a Preview button. Perhaps the DATA can be previewed (in some form / subforms, not trying to faithfully show what would be printed), but the only way to get a printout is to click the Print button, which then allows user to...

This requires a fairly complex query. You may want to post the essential parts of your db so we can do it for you. If you want to first delve into it yourself, here is a starting point: http://allenbrowne.com/subquery-01.html. And another one...

I would add a field to the form's underlying query, which would show a True or False value depending on your criteria. Then the CF expression is super simple.

> This does not work, at least not reliably. :-( I thought about it later, and feared what you experienced. Is the ReportHeader_Print event any better? Of course reports don't need to have a ReportHeader section, but you could add a hidden one. BTW, I heard back from my report friend, and he is...

Try this instead of the last line: Me.Parent.SetFocus Me.Parent.txtProductCode.SetFocus

A simpler solution would be to ask the user "Did it print OK y/n", but I presume you have already ruled that out. Did you also rule out offering 2 buttons, one for preview and one for print? You would still have to deal with Ctrl+P after preview, but that would be the only keystroke to catch...

> data is transferred to the subform Please show us that code. It appears that this code is setting focus away from the parent form.

At the very least I would take down that link.

To see how SQL Server resolves your query with 4 LIKEs, run the statement in SSMS and turn "Actual Execution Plan" on.

Not really. Such queries cannot use indexes. They are "non-sargable" if using a 5-dollar word. What I would do is use 4 search terms rather than one. After all, the user knows if they are searching for a name, street, city, or state. State search field could be a dropdown of all the possible...

If you have a DoEverything procedure, you probably also have procedure arguments that drive how the proc runs. E.g. public sub DoEverything(arg1 as string, arg2 as long) if arg1 = "A" then 'Code to do Thing1 goes here. elseif arg1 = "B" and arg2=99 then 'Code to do Thing2 goes here This is...

Re https://www.access-programmers.co.uk/forums/threads/how-to-register-library-reference-from-vba-code.334747/post-1978920 It appears that you know how to create a .NET loader DLL. I don't think Albert's are in the public domain., but maybe he will make them available in this post. But still...

https://www.opentext.com/produits/gupta-sqlbase Looks like you can get a free trial of that database engine. Install, and try to mount your file as a database.

> it is a server database, not anything that would create a single database file Actually, that is not impossible. SQL Server uses 1 file for the entire database (OK, and a Log file, and you CAN use multiple files). You would need a SQLBase or similar server installation, then try to mount...

I see SYSTABCONSTRAINTS, which points to SQLBase, according to Google.

Not too large to upload to an online file service like OneDrive or DropBox, so interested parties can download it and take a look. I might want to take a crack at it. What can you tell us about this database? How old is it? Is it a single table, or multiple? What is the subject matter? Is the...

I would suggest to hold off for now. Let's see if my suggestions in response #3 reveal the issue. If you have to upload, make a copy of the database and only include the tables and fields necessary for this issue. Sensitive data should be anonymized, e.g. FirstName1 rather than Suzy.