ACCESS FEED: Oktober 2023

Senin, 30 Oktober 2023

[MSAccessProfessionals] Table Name Change

Hello friends,
Years ago in a very bad lapse of judgement and at the direction of my boss, we gave names to tables that reflected the system we were using. The system is long gone and we are moving away in 2025 to a new system. In the mean time, we are moving all tables to SQL as the back end. I would like to begin renaming the tables to a more clear and standard naming convention. Some of the newer tables we developed are standardized, so they are good now. The current naming convention is as such.
R&D-EMPLOYEEHISTORY
R&D-CURRENTEMPLOYEES
R&D-FMLAELIG1
R&D-LeaveFields2New

I would like to remove the R&D- and make them camel case with no spaces. I copied a database and tested it out with the auto-correct on. It worked like a charm, but all object dependencies are erased. Is there a way to not lose the dependencies or will they eventually be rebuilt after opening it a few times?

Thank You for your assistance

Jim Wagner

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Selasa, 24 Oktober 2023

Re: [MSAccessProfessionals] sql list

Happy to help!

Paul

Sent via mobile device

-------- Original message --------

From: smiley2004_10 <cas23121964@gmail.com>

Date: 10/24/23 6:03 PM (GMT-05:00)

To: MSAccessProfessionals@groups.io

Subject: Re: [MSAccessProfessionals] sql list

thanks Paul, that would like a treat. It is just so annoying that it was so simple.

Re: [MSAccessProfessionals] sql list

thanks Paul, that would like a treat. It is just so annoying that it was so simple.

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Sabtu, 21 Oktober 2023

Re: [MSAccessProfessionals] sql list

For starters there needs to be a space rather than a comma before WHERE. This should help:

https://baldyweb.com/ImmediateWindow.htm

Paul

Sent via mobile device

-------- Original message --------

From: smiley2004_10 <cas23121964@gmail.com>

Date: 10/21/23 3:02 AM (GMT-08:00)

To: MSAccessProfessionals@groups.io

Subject: [MSAccessProfessionals] sql list

What I'm trying to achieve here one menu set of buttons control the outcome of a list;

The user selects from the main menu (1)

Which place the number one in this case into the text box (2)

The user then clicks the hamburger icon (3) in which the category list appears sorted out by query

The list box should only show a category list as shown (5). But unfortunately the list turns up blank, or without the selection condition shows all.

The VBA

SQLText = " SELECT [dbtMenuSubList1].[Menlistid],[dbtMenuSubList1].[MListName] " _

& " FROM [dbtMenuSubList1],WHERE [dbtMenuSubList1].[Menlistid]= 1; "

Me.ListSubMenu.RowSource = SQLText

Could I please if you could tell how to achieve the above , and point out what I did wrong (office 365 64bit)

[MSAccessProfessionals] sql list

What I'm trying to achieve here one menu set of buttons control the outcome of a list;

The user selects from the main menu (1)

Which place the number one in this case into the text box (2)

The user then clicks the hamburger icon (3) in which the category list appears sorted out by query

The list box should only show a category list as shown (5). But unfortunately the list turns up blank, or without the selection condition shows all.

The VBA

SQLText = " SELECT [dbtMenuSubList1].[Menlistid],[dbtMenuSubList1].[MListName] " _

& " FROM [dbtMenuSubList1],WHERE [dbtMenuSubList1].[Menlistid]= 1; "

Me.ListSubMenu.RowSource = SQLText

Could I please if you could tell how to achieve the above , and point out what I did wrong (office 365 64bit)

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Minggu, 15 Oktober 2023

[MSAccessProfessionals] Using share point as a document storge for word, excel and mail merge more than one desk top

Hi

I understand, the reasons, not to run the access database from other sources, other than your desktop as you clearly pointed out.
But what Id like to achieve, is to use Microsoft access to view uploaded documents like PDF files, on to SharePoint, as well as Excel and Word files. And to also to mail merge with the Excel, along with word files, and save these files to another folder. Preferably to a folder that Ive designated for as client information, while able to view a list of stored documents associated with the clients folder.

At present, there are two users with their own separate Microsoft Access office 365 running on the machines, who would access to the templates. I do not wish to have these templates altered unless I altered them myself, or the other user does.
As I dont want the clients file that the template would be eventually saved to with extra documentation information to be corrupted if both are trying to use it at the same time. Is there a way of preventing two users opening the same document at the same time? If so, how? I would also like to know if I can use Microsoft Access to make new folders or list of folders on SharePoint? The idea of using SharePoint as the name suggests, is so both can users can view and use the one type of information and have an access to it, using Microsoft Access on each individual desktop.
It is possible to be achieved this out come? Which one of your courses would help me to achieve this and can I get a copy or do I have access even after I pay for it later on down the track? The reason I ask that is because I do not have the experience or knowledge you have accumulate over the, years. due to fact Im getting older and have different career, and feel that I would need to refer to it now and then.

The idea is to have a directory with templates of word and Excel files in which I can view on Microsoft Access using list view! If thats possible, and use those templates to do a mail merge and save them on another folder within SharePoint, e.g. clients folder to which I store the file, and with ability to email through to Outlook.
Is this possible?

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_