Search results

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)

Welcome mdfOffman!

Perhaps this old thread on this forum can help you with some examples. Search and look up this threat: "Opening a form in a library and retrieving a returned value"

BBD, welcome to AWF!

Hello and welcome, Darshan

Hello and welcome, Benedict!