dramnath1981
Member
Hi,
I have a peculiar problem. I have created a userform and populating data in to it from Excel which is from a Access Database query. When I open the Excel file the form shows up and data is populating in a second. But if someone else is opening the same file, once when they click the "SHOW" button remains pressed and I can see excel flickers continouosly in the left hand bottom corner where a small icon and Ready appears.
I have to then stop the execution by pressing Ctrl + Break. But sometimes, it works in the same PC. Its not stable.
Can anyone tell me what is the problem?
To Explain you further this is what I am doing:
a) Click a button in Excel to show the Userform
b) Click "SHOW" button in Userform
(The moment Show is pressed, Data is fetched from Access Database and Excel First
row gets populated)
c) The Form Fields are linked to Excel cells in the first row and will show up once
when populated.
d) When the Show button remains clicked and hangs, I can see the Excel where the data is correctly populated. The only left out portion is show them in the form fields for which there is no coding as form fields are already linked. This is where the problem is.
I hope I am clear to you guys. Any help will help me in fixing this peculiar issue.
As i told already, I don't have this issue in my laptop. I see this only in other PCs. To your information these normal PCs have 2GB RAM. So I can't even blame the system slowness for this problem.
Please help.
Regards,
Ramnath
I have a peculiar problem. I have created a userform and populating data in to it from Excel which is from a Access Database query. When I open the Excel file the form shows up and data is populating in a second. But if someone else is opening the same file, once when they click the "SHOW" button remains pressed and I can see excel flickers continouosly in the left hand bottom corner where a small icon and Ready appears.
I have to then stop the execution by pressing Ctrl + Break. But sometimes, it works in the same PC. Its not stable.
Can anyone tell me what is the problem?
To Explain you further this is what I am doing:
a) Click a button in Excel to show the Userform
b) Click "SHOW" button in Userform
(The moment Show is pressed, Data is fetched from Access Database and Excel First
row gets populated)
c) The Form Fields are linked to Excel cells in the first row and will show up once
when populated.
d) When the Show button remains clicked and hangs, I can see the Excel where the data is correctly populated. The only left out portion is show them in the form fields for which there is no coding as form fields are already linked. This is where the problem is.
I hope I am clear to you guys. Any help will help me in fixing this peculiar issue.
As i told already, I don't have this issue in my laptop. I see this only in other PCs. To your information these normal PCs have 2GB RAM. So I can't even blame the system slowness for this problem.
Please help.
Regards,
Ramnath
