Ok....
The hardisk is set to go to sleep after 0 mins and set to go to sleep on "Never"
I did notice something interesting tho......the "link state power management was on Med power saving mode" I am wondering if this is causing my link to go to sleep when it is not being used....I turned it...
Yes indeed....I have went into the setting and the PC is not supposed to go to sleep but somehow the drive sleeps or disconnects until I click or it or something........I prob won't get up a 3 in the morning to click on the drive to make sure its alive....lol😆
yes I thought about that but once you check the drive....and say it is not available ....I can just end the code....but I want it to run....I guess what I need to do is keep the drive alive somehow
Hello All,
I have been having this annoying problem when my code run at night on my VDI machine.
I believe when the machine goes to sleep the path to the drive is disconnected. So when it wakes up to run the code, I get this error.
I can log into the computer and run it just fine...
I like this idea!
I will will try to use it another time. I tried it however, it did not work. Thanks tho:)
I just went ahead and created another table and set it for no duplicates and appended the data to get rid of them.
I test with the wizard to make sure.
I was just trying to do it in a...
That is what I normally do and it fine but I think because of the joins, it still duplicating some data
In excel you can easily do this but I never had to do it in Access.
I select the "Main Number" because that is what I would want the filter to be based off of.
Is this possible in a query...
Hey Everyone.
I am shocked I have never came across this before.
I have a column like order number in a table and I just want to see the unique data based off that column.
I know to do district...but because of the data it still duplicates some columns.
How do I force it to only show unique...
Ok...I did it but when I went to choose 3 columns it did nothing.....just stayed in 1 column...
how do I get it to display only 6 records per column? ??