You're wandering through the city when you come across an empty office building. Have you done anything unethical?
You pull on the door, and it opens. You stand outside for a moment. Have you done anything unethical?
After a brief pause, you stick your head inside and look around. Have you...
Virtual CD can mount a CD as a drive letter on your PC, and it can import ISO files.
http://www.virtualcd-online.com/default_e.htm
(I think that WinISO can do the same thing.)
Your operating system would see the data as if it were on a CD mounted in a real CD ROM drive.
It is my understanding that the packet encryption/decryption process is fairly processor intensive. It is certainly true that accessing a server via a VPN is dramatically slower than accessing the same server over the same connection without the VPN.
There are too many variables to make an...
Make sure that the user name you are trying to connect with is marked for "remote access". (It can look confusing - the prompts may lead you to believe this is only for dial-up access, but it is required for VPN users, too.)
If this is not it, open the Event Viewer (Administrative...
Sorry, Paul!
Here - try this line in place of the one with "(w/ your parameters)":
DoCmd.TransferSpreadheet acImport, acSpreadsheetTypeExcel9, "TableNameToPutDataIn", filename, True
Some things you may need to change:
1.) Replace the text TableNameToPutDataIn with...
Actually, there's at least one line in there that you're going to want to change. The line:
ofn.lpstrFilter = "Text Files (*.csv)" _
+ Chr$(0) + "*.csv" + Chr$(0) + "All Files (*.*)" + Chr$(0) + "*.*" + Chr$(0)
would better suit your purposes if...
I have some code that you can drop into a module (which I found right here on Tek-Tips) that allows you to do this. (I wish I could find the exact post that I copied this from so I could give proper credit - I have done several searches, but I cannot find the specific post or FAQ.)
In Access...
I apologize - the "Advanced" button is available for a Text Import, but not for an import from an Excel file.
You actually need to use the "TransferSpreadsheet" method, which does not require an import specification.
Mea culpa.
If you want to stick with javascript and posting the form to an e-mail address, your options are limited.
Here's a trick. Make two forms on your page - one with all of the fields, and a second with one hidden text field and a submit button. When you submit the second form, send it to a...
I think I understand what you're trying to do.
There is a data file which is the same format every time, but with new data. You want a user to be able to press a button to import the data automatically.
Look at the "DoCmd.TransferText" method. You will need to create an import...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.