Recent content by gmatriix

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...

I am going to check but I thought I got that one....just a sec

Thanks, Yes I do that if there is a error I need to see.

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

Thanks, I took out the real file name....this is just for example purposes

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...

Thanks Alot! I think that did it!

I think I may have figured it out....I adjusted the print margins and it split into 3 columns....I have to use print preview to view it tho..

I though of that too....but there is no where to custom adjust the margins...that I can find

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? ??

going to give it a try