Archive for February, 2012

How to remote access a NAS drive over the internet as a virtual drive letter?

Saturday, February 25th, 2012

Tried VPN and webDav for hours and hours and hours. Can’t get it to work. Internet guides not helping. There must be an easier way?

Need to enable satellite office to access headquarters NAS as virtual drives. There is a PC that is always on…to act as a server. Not looking for a remote desktop/logme in solution. Your help would be greatly appreciated.

I would look at hamachi. Its a product that is now controlled by logmein. It sets up a vpn and then you will be able to share the drive and it will then be able to be mapped and will be accessible when logged into the vpn. Hamachi is free. Remember that you will need to turn on sharing on the computer that is hosting and the drive itself needs to be shared.

https://secure.logmein.com/products/hamachi2/

How to create a search text box in Microsoft Access 2007?

Sunday, February 12th, 2012

I have created a table and query in Microsoft Access. In the query I am able to search in criteria to filter out relevant information. However to make it more user friendly I want to be able to have a text box "pop up" whereby people can enter information without having to go through the hassle to get to the query design view. Any idea of how to help?

this is called parameter queries there are youtube videos and such but here is a link to explain.
http://www.fontstuff.com/access/acctut01.htm

I need help with access SQL.?

Saturday, February 4th, 2012

I am making a access database and I am working on a search and edit mechanism.

I need to select a row from a table in a query, that has an ID selected from a list box.

So I need to do something like:

SELECT Person.First_name, Person.Last_name, e.t.c.
WHERE Member_Key = [Forms]![AccountList]![list6].selection

You~re almost solved your problem. Your query should be like this:

SELECT Person.First_name, Person.Last_name, e.t.c.
WHERE Member_Key = [Forms]![AccountList]![list6].value

Hope it helps.