Search results

The OP said that he Back End is stored on SQL Server Azure, so this link doesn't apply.

IMO the best and fastest option is to use a Pass-through query (if you don't need to update the tables)

You can set/unset this option if you use Rubberduck:

In VBA, executing a shell command with spaces in the path requires enclosing the path in double quotes. Here’s how you can do it in MS Access VBA: myPath2 = """C:\Program Files (x86)\VATECH\EzDent-i\Bin\VTE2Loader_ReqAdmin32.exe"""

The short answer is: No So you might be wondering: “What is the maximum number of objects in a database?” The short answer is: “Nobody knows it!” I’m going to explain what tests I’ve done and what the results are: I have developed an easy procedure that is able to create any number of new...

Sorry @The_Doc_Man, you are rigtht, both must be singular. These relations refers that a person can have several roles (client, customer, etc. ) and each role whith different attributes.

You can try to change the name of the VBA project from the VBE.

Look at the outputs, Arnel's solution and mine give different outputs.

I have several relations 1:1 with no issues. It is a way to organize your database. Example: Person 1:1 <- Clients Person 1:1 <- Customers Person 1:1 <- Workers Person 1:1 <- Contacts Person 1:1 <- Other stuff... ... Somebody could say that I could use only 1 table to store all the data but in...

Perhaps this threat helps you. https://www.access-programmers.co.uk/forums/threads/add-images-in-cdo-mail-message-htmlbody.304778/

Hello, Test this other example.

To get the VBA Project Name, you have to use: Application.VBE.VBProjects(1).Name

Perhaps this video helps you:

Welcome to AWF! Phuduhutswana

Perhaps this example will help you:

BeachBoy! Welcome to AWF!

Welcome acnycn.

The maximum number of modules (counting forms and reports with modules) in a database is about 5000 according Colin Riddington's article(according Microsoft documentation is 1000). Moreover, you can organize your application using libraries to store some objects. I have an application where the...

Perhaps you find this example useful. (Not fully testeted)

Perhaps this example helps you to find the range: (Updated version)