Forum Discussion
Creating an Access Table from an Excel Worksheet with only one 55 character Column
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？
I finally have a perfect Table with all of the names of the images.
It is a lot quicker working with the Access Community.
After speaking to the IT guys from Amsterdam on the phone a few minutes ago, they seem to be the most knowledgeable pathologists, I had to tell them we will go no earlier than Access 2010.
I know that the hospitals in the very rural areas have serious financial situations and that ransomware has taken a serious toll on them. However the problems that arise from rare instances, usually come from very rural areas in Africa and South America.
I am going to stick to Access 2016, do everything there and move that to the later updates.
The IT pathologists in Amsterdam feel the best image is 4821 in Horizontal pixels and 3456 in vertical pixels.
I have no idea of what I am going to run into and there could possibly be some deviations. That will be the decision of our four top hospitals in the U.S.
I am still not clear about the name of the medical slides and the images from the microscopic pictures being in different areas.
From what I can tell I am going to have to use an SQL query to work with the images to create a perfect image.
I got some ideas from the guys, but cannot seem to come up with the appropriate syntax and this has been my major problem all along.
Since the image is not in the table, just the name of the image, where is the image itself?
I have the smallest blood category which is only 33 of the about 7,500 that I am going to do my tests of.
Sometimes being new to Access, I feel like an idiot and sometimes confused. This reminds me of the old RPG that Burroughs came out with 40 years ago somewhat, a lot of confusing rules.
I need the format of the Instruction of the image to try to mess with, I may have to come up with a math formula.
You guys have been great and have more patience that I do, but I do have a lot of people breathing down my back.
FYI, Hospital research is no longer permitted to use Facebook by law. I am also going to check out the open source program you recommended.
Old NASA Kid
I have the smallest blood category which is only 33 of the about 7,500 that I am going to do my tests of.
What is your goal at last?
Or what situation do you want to automately achieve?
If relative to image rather than data analysis, it looks unnecessory to use any kind of database.
- I cannot find an .accdb File, Do you what folder (directory) it is in.
I have a VBA program, but I have not been able to test it.
Here it is:
Dim dbi As DAO.Database
Dim rst As DAO.Recordset
Dim ImgWidth As Integer
Dim ImgVert As Integer
Set dbi = CurrentDb
Set rst = dbi.OpenRecordset("Select * From Pictures")
Set rst = dbi.OpenRecordset("Select Top 1 Picture as ImgWidth, ImgVert([Picture]) as ImgVert")
rst.MoveFirst - Peiyezhu;
I have not been able to test this yet because of some problem with enabling the form or Database.
Here is the code I built with you assistance days ago:
Dim dbi As DAO.Database
Dim rst As Recordset
Dim ImgWidth As Integer
Dim ImgVert As Integer
Set dbi = CurrentDb
Set rst = dbi.OpenRecordset("Select * From Pictures")
Set rst = dbi.OpenRecordset("Select Top 1 Picture as ImgWidth, ImgVert([Picture]) as ImgVert")
rst.MoveFirst
Still having security issues and this application will probably not be on the Internet.
Thanks Again
Old NASA Kid - To get my VBA to work, I need to use a Command Button to fire it.
I am having some security issues because I cannot enter the query to try to test the VBA.
The State of Nebraska sent us a small test database, but I am too hung up on getting there to try it.
I do have an Assess Table with what I need to continue on, once I can get to a point where I can test the queries.
Thanks Again - 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. - They were put on a flash drive and sent to us..
The assembler programs are from compilers IBM created for NASA
They have used them for over 40 years.
We are also doing what the federal government wants us to do.
When I take screen shots, I copy the error using the Prt Screen key
I go to paste it some place and it does not show up for you guys to look at.
What is beginning to really bother me is what the retired Microsoft Engineers said about Office 365
I am praying we do not have politics in programming.
I am thinking about taking 365 out and going back to 2019.
Some of these small hospital programs have been working for years and now they do not work.
Microsoft wonders why peoplw do not upgrade.
I am also having trouble how Access handles things from outside Microsoft.
We called their Tech Support, paid $998.00 and got nowhere also.
I have programmed for over 30 years and have never run into anything like this. I did some IBM DB2, had no problems, but it was a long time ago.
I am going to remove Office 365 and go back to 2019 today.
Thanks for your help, if it was not for you I would have walked out on them.
I think I am the only programmer who has medical experience and the regular programmers made some very serious errors last year..
How do I take a screen shot and send it to you guys, also it would be great if someone had PC Anywhere.. 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？- I got a hospital computer in that is windows 7 and Office 2010. I moved them to another Windows 10 machine my friend is letting me use.
When I moved all of the programs over, they all bombed.
They work great on the 2010 computer.
They all bombed out on the Dim dbp as DAO.database
I guess I had to do something new with 365, can you lease tell me what I have to add?
Thanks
Old NASA Kid - https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-find-accessexe/709367ec-a936-4460-afbc-6a45ea20afdc?page=3
if you want to get image size,please have a look about imgSize.exe - I think they are in a folder. On my Windows 11 computer with 365, I have a field in the table for a blood test that points to the image C:\BldPht07\NameofImage.jpg
However it is just in one of 13 folders. I wanted to put it in an area where we can increase the ize, some of them from Central Asia are very small and hard to see.
This is why Nebraska sent us their file, because they ran into the same situation.
I am a little upset because when the new updates were installed, the old ones were not removed.
Can I use my Windows 11 computer with office 365 to accomplish the task and move it back to a Windows 7 computer with an older version of Access?
The internet is very slow today also.
Thanks for your assistance on this matter.
Old NASA Kid - peiyezhu
There is a new method world wide for looking at blood samples of patients
There are between 7,700 and 7.900 images.
These images come from all over the world. In fact we just received one from South Africa that the doctors cannot recognize. I have very littlee experience with Access and not much more with Microsoft.
We have managed to build an assess Table with all of the names assigned to the blood microscopic images. We need to go through the images with pathologists and see if they are clear enough to read. A medical research hospital in Amsterdam, complied the images (their names) and we now have them all in an access table.
We have several computers at our disposal, but most of them are Windows 7 professional.
My computer is Windows 11, with Access 2016.
On the computers including mine, I have created a form with a Command Button to go through the 13 different categories and and I am trying to create an SQL to examine the images for their size. The center in Amsterdam have determined that the best image will be 4821 Horizontal X 3456 Vertical. We will only be changing the number of pixels at the request of the pathologists.
When I created the form (which is perfect) I put a command button and when I clicked on it I want an SQL to convert the selected Image by the name of the image. However when I go to enter the evnt (where I want to put the SQL, Access bombs out, it closes Access, no message or error codes.
This hppens on Access 2013 and Access 2016. I could try in on my computer and when I get it to work, try to move it the the very small hospitals computers to see if it will work there.
I hope this will be clear enough for you I have four computers at my disposal, two windows 7 and a windows 10 and Windows 11.
Thanks
Old NASA Kid