Forum Discussion
Len_Lane
Jul 03, 2023Copper Contributor
Creating an Access Table from an Excel Worksheet with only one 55 character Column
I have been trying for days to take the names of Blood Samples, between 7,700 and 7,900 records and put them into an access table. The Worksheet has only one column, which is the name of the lab tes...
- Jul 08, 2023
When I moved all of the programs over, they all bombed.
Vba program? how did you move it?
copy the only one .accdb file to flash disk and paste to your Win11 from the flash disk .
Or send email attachment.
You have a VBA program already?
peiyezhu
Jul 08, 2023Bronze Contributor
When I moved all of the programs over, they all bombed.
Vba program? how did you move it?
copy the only one .accdb file to flash disk and paste to your Win11 from the flash disk .
Or send email attachment.
You have a VBA program already?
Len_Lane
Jul 08, 2023Copper Contributor
Priyezhu
I have not been able to get to that area should I decide to go in that direction.
I would need to go to an event on clicking a button. IT has been at least 15 years since I did it and it was only once.
However I cannot even get to the event because of the way Microsoft has the security set up.
The only way to do the is with a command button.
If I remove the security (enable) on the database it will not let me use DIM
We have done all of these things to try to protect entities however over 4,100 hospitals got hit with ransom ware. So did we really help the situation?
Old NASA Kid
If I do not enable the database it ignores all of the Command Buttons and probably all of the other events.
I understand security as well as anyone and bypassing the firewalls and files is one way, however I am not permitted to mention the second, but I can say that it is night and day different than using some form of database.
Maybe this is turning out to be another form of security intelligence, Just too many changes, but when IT programmers with the VA tried it, a huge number of medical issues came up.
I have not been able to get to that area should I decide to go in that direction.
I would need to go to an event on clicking a button. IT has been at least 15 years since I did it and it was only once.
However I cannot even get to the event because of the way Microsoft has the security set up.
The only way to do the is with a command button.
If I remove the security (enable) on the database it will not let me use DIM
We have done all of these things to try to protect entities however over 4,100 hospitals got hit with ransom ware. So did we really help the situation?
Old NASA Kid
If I do not enable the database it ignores all of the Command Buttons and probably all of the other events.
I understand security as well as anyone and bypassing the firewalls and files is one way, however I am not permitted to mention the second, but I can say that it is night and day different than using some form of database.
Maybe this is turning out to be another form of security intelligence, Just too many changes, but when IT programmers with the VA tried it, a huge number of medical issues came up.