As long as there enough to replicate the issue.
No workbook?
That is essential don't you think?
DB is too late for me.
I can still work with the workbook if you supply that and a DB of my own.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I removed what would have been the first reply because I thought I was being dense. After waiting for others to add clarity that I still don't have, I must ask:
You're opening a connection to an Access database ( with cnn variable) and then trying to reference ActiveSheet (an Excel object) after making that connection, but Access has no such thing such as "ActiveSheet" and I see no reference to any workbook in that code. How is that supposed to work.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Micron,
O/P said in post 12 I shall point out that the macro is ran from excel and saving the name into a column on a cell in access. (not sure if this matters)
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I guess if I had made that first post y'all wouldn't have had to wait for post 12 to find out. Kinda surprised that no one asked before then but it didn't seem to matter. I guess my problem is that I did first look to see where the thread was posted and it is in Access forum.
I just figured the connection was from Access to Access. My bad I guess.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
ok, its unlocked now.. took me a while to figure it out
HI, MOKE123 that was the answer, it does work, for some reason it didnt work when i tried it the first time (Probably my lack of knowledge, dont really know what i did) but i tried it again and it worked! thank you all for the replies. Thread solved, and rep added to all that replied, thank you all again Welshgasman and Micron.
this works:
rst![Name] = trim(Sheets("Quote").Range("C1"))
I did first look to see where the thread was posted and it is in Access forum.
So did I but you would think there wouldn't be much of an issue with something as simple as Trim()
Why is the vbe locked?
Why are the tables hidden?
You need to change the field name for the Field "Name"
You should have gotten an error msg when you made the table
If this helped, please click the star * at the bottom left and add to my reputation- Thanks
Glad you got it sorted.
You may want to consider using access to link to your excel file and work from access.
https://support.microsoft.com/en-gb/...source%20cells.
If this helped, please click the star * at the bottom left and add to my reputation- Thanks