We have some elaborate VB Excel macros that pull data in from various files. Now that we have switched over to using box.com as our file system, we would like these macros to read/write the required data to files stored in B
View 1 RepliesI am trying to import a bunch of excel 2003 files all with A:H columns and they are under the same headings etc. into a table in access 2003 database. This is a module in access im making. Im using a file search to look for every file that begins with Format (which they all do ) to get at all the files in the folder path. is there a more efficient way to do this? somehow select all files in a folder? and import each to the same table in access? The DoCmd.TransferSpreadsheet seeems to take each file path individually so I'm not sure how to get each file name in the folder to import it.
I have this at the moment:
Sub Import()
Dim db As Database
Set db = CurrentDb
[Code].....
Ok I know this question has been asked to death but I still have not seen a good answer. I have created an application in VS2010 using VB.NET. In my application I have an error log that is an XML file located in the Public gstLocalErrorLogLocation As String = Application.StartupPath & "ErrorLog"that gets written to in the event of an error so I can trouble shoot application easier. My application also downloads files from our FTP site and puts the files in Public gstLocalDownloadLocation As String = Application.StartupPath & "download"So I have files that get read and written to as well and created and deleted all in the Application.StartupPath which is either "c:Program Files(Application Directory)(Some Directory)(Some File)" or "c:Program Files (x86)(Application Directory)(Some Directory)(Some File)" depending on 32bit or 64bit Windows 7.
After creating the setup I install it on my test machine that have both Windows 7 32bit and 64bit.Everything in the application works great till I have to write to, delete or creat a file in those directories above. I know it is an access issue and the UAC. This will get installed on numerous systems so the options I have seen to change file or folder permission on the computers manually is not an option.What has to happen is after I install the application it just works like when you install it on XP. Some post have suggested that you us a user with administrator privilages or group which is all fine and dandy but the user I have used to test the application has all of that.
So what I am asking is how do you create an application with VS2010 in VB.NET that after creating a setup package and installing on Windows 7 will just work with out "Access to the path c:Program Files(Application Directory)(Some Directory)(Some File) is denied." If I have to install this on 100 Windows 7 computers it has to be a concreate no manually doing anything just install and work like when we installed on XP.
Actually I want add some folders and files to MSI. Through custom action i want to copy that added folders and files to some destination/target folder.
View 1 RepliesHow can you access files in %appdata% through vb.net? e.g. C:UsersKuzonAppDataRoamingprogram. How would i access that file but on another windows 7 machine, also how would you do it on windows xp? I believe it is %Application Data%
View 1 RepliesI have spent couple of days searching the Internet for some hints, but I haven't succeeded. I need to enumerate all removeable USB storage devices and search for a file. It's important to say, I am looking for a device, which has no drive letter assigned - e.g. Garmin GPS etc.. how to enumerate the devices, indentify storage one and/or access its files?
View 2 RepliesI have spent couple of days searching the Internet for some hints, but I haven't succeeded.I need to enumerate all removeable USB storage devices and search for a file. It's important to say, I am looking for a device, which has no drive letter assigned - e.g. Garmin GPS etc..
View 2 RepliesI need to create a helpsystem for my work. There's two user types ... common users and admin users. The common user needs to se all stuff except admin stuff - admin must see it all.
I use Camtasia to make screencasts - AVI files, which I need to put in my helpsystem. Seams like I can't stream the AVI from embedded resources, so I guess I need to save the AVI files to the users harddrive.
I need to copy all stuff to the client PC in case of network problems.
how to I prevent common users going to their harddrives and watch admin AVI files?
I have been automating MS Project with VB.Net. I can open .mpp files and access all the objects I need. Now the customer has asked to open these files from Project Server. I cannot get MS Project to Open with the server connection.
View 3 RepliesI have organized some configuration in folders within Visual studio project explorer. When I release the application those files are copied into the same directory (including sub folders) as the exe.Consequently I can access those files with My.Application.Info.DirectoryPathDuring debug VS does not copy the files into the Debug-folder, consequently my files cannot be accessed with DirectoryPath
View 4 RepliesI am writting an application that stores data in an Access database. I can't put the files in the Program Files directory since standard users can't write to that folder. I can't use a 'user' folder since multiple users will need to access the same file. In addition to accessing the file, users on occassion will copy new versions of the file into the folder, overwritting the old file.Where should I put this file? I am thinking the ProgramData folder, but when I create that folder during the install, it is also read-only for a standard user.I'm lost as to where I should put a file that can be accessed by multiple users, that is read/write, and I can install the folder into the location. I don't think I have a programmatic way of installing a file into the Public users folder.
View 1 RepliesCan anyone provide the resource to learn making connection between computers over the LAN and retrieve files? EDIT: And can I browse the folders like its done in the local machine?
View 3 RepliesI'm writing a program to examine logs of various servers on our network..they're not on our domain but i can map a drive to them by authenticating each time from my LP (which is on the domain)
my question is... how do i perform that same authentication with VB..
[Code]...
i'd like to either have a pop up box to auth as i would when i browse to the remote PC... OR be able to set it statically in the code (the servers all have the same admin login + password)
If I have added an html file to my vb 2008 form app project - for use with the webbrowser control. What would be the correct syntax for navigatingto it from the webbrowser.navigateto method.
View 11 RepliesWhen I try to access the folder "System Volume Information" and other system files I get the errorAccess to the path 'H:System Volume Information' is denied.
View 1 RepliesI have just completed an upgrade of a VB6 app to VB.net (2008). Everything works as it should except for one (essential) part. I cannot open more than one instance of the built app without getting a file access error. Now don't laugh but my program uses Random Access files to store the data (i know, i know the 1990's called and they want their programmer back). Anyway I've been using this method since the early 90's and it's never let me down. Until now that is. VB6 allowed any number of users to access the files but for some reason VB.net gives the following error: The process cannot access the file "C:lah blah" because it is being used by another process.
View 2 RepliesI am working on a very simple program for someone and because it's been so long since i've programmed, I'm looking for an answer as to the best way to do the following.
My program consists of tracking incident reports and each report needs to have the data entered as well as the "paper form" linked to it that shows the members signature. I have everything completed on the program but how to get my file to link with the incident. I am using Access for my database and have been looking everywhere online on how to attachment documents within Access using the Attachment Datatype. So my question is.....
Should i find a way to import the file to Access, and if so, how do i do this, or should i just send the file path to Access as a text field, and then hyperlink the file when it is displayed on the report? I've never done anything like this and was just looking for some pointers.
I've inherited a VB.NET website and it won't compile because the class1 in the file class1.vb refers to class2 in a file called class2.vb. I get the following error when trying to compile[code]...
View 3 RepliesNeed to store JPG/GIF picture files in an access database table and then would like to retreive it and put it on a Word Document using VB 2005 code.
View 17 RepliesI'm new in vb.net (application). I need to access files or browse files using vb.net. Does anyone knows how can I do it?? I can use the listview??This is the process:I have a form and I need to browse folders and drivers (C drive/network drive...) in the same form. But how can I do that, how can I display the icons, file, etc. and open it in listview or any control in vb.net.
View 3 RepliesI'm looking for a solution to import or link logs (csv and txt files) to Access using ODBC. These files are in a directory and I would like to link each of them to a table in Access to analyze their content. I'd like to use ODBC rather than the Access' Import Wizard because I want to keep the possibility to change the format and/or delimiters of my files if necessary.I settled an ODBC Driver "Microsoft Access Text Driver" but when I try to open the connection in Access, I get the error "You cannot use ODBC to import from, export to or link an external Microsoft Office Access or ISAM database table to your database".This connexion works perfectly in Excel and enable me to get the data in an excel spreadsheet. I'd like to do the same from Access to use Access' functionalities!
View 3 RepliesHow to save pdf files into access database ?
View 4 RepliesIn VB3, I could open an Access file, select the table, specify the index and read a record in just that many lines. [code] If the customer's phone number was stored in Access as Phone, once the seek command was implemented, it was available as HeaderTb(Phone)In this example, OE was short for Order Entry, and the database contained the header files for all orders.I worked through the oft-cited tutorial to pick up the basics for database control, but it provides a means for the user to look over and work with records.But what if my application was more of a relational database? How do I instruct VB10 to access a record by its key and how do I use the data it comes back with?
View 9 RepliesI finished my application whith vb2010, this application uses a Access database. I have a problem because when I install my application he put database in de same path "program files" and this path is only read And my application crahed. I know how to installer put database in other path but I don't know how to tell my application to find this database.
View 2 RepliesI am trying to attach my mdf files to SQL server (using windows XP) but it gives operating system error (error 5), saying Access is denied to the dbMaster.mdf
View 1 RepliesI am trying to access my website and display the .mp3 files in a certain directory. Through this, i want to have windows media player play the selected file. Either through list box, or combo box. I have tried many different ways. How in the world am i supposed to do this? I do not just want to set the windows media player url to a certain file, like i said, i am trying to get to select the file (in some sort of dialog box) and play that.
View 4 RepliesI have a program that needs to access the files that are open by another program on the computer.When my application comes up I can easily see if the other application is running with the .net Process.GetProcessesByName method
Dim MyProcesses() as Process = GetProcessesByName("AnApplication")
For Each Instance as Process in MyProcesses
If MsgBox("application is running - do you want to end it?", MsgBoxStyle.YesNo or MsgBoxStyle.Question, "Warning") = MsgBoxResult.Yes then
[code].....
The problem is that the Instance.Kill does not allow the application to end gracefully. In VB6 you could use the SendMessage API to send a close message to the application and it would end gracefully - i.e. give the user the normal closing prompt. This just slays the application - leaving any open files in their potentially incomplete state, etc.
We have an app that needs to access network resources. It's written in VB.Net. The application can't access the files on another server via a UNC path. How can we find out what user the application is truly running as and how can it be changed? We tried this KB from Microsoft... but it didn't work.
View 1 RepliesHow to access controls from class files in app code?
Markup:
<%@ Page Language="vb" AutoEventWireup="false" Inherits="shoppingCart1.ShoppingPage" CodeFile="ShoppingPage.aspx.vb" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
[Code]...
I am trying to convert a VB5 program to VB2010 so that I can continue to support it on my new PC. My copy of VB5 was an upgrade from VB3 which was an upgrade from VB2 which came on floppies, so I can't just install every preceding version as my new PC doesn't have a floppy drive.I have accepted that I will have to design all the forms from scratch (whatever happened to twips?) and will have to go through the thousands of lines of code line-by-line, but I have hit a brick wall when it comes to random access files. One such file is defined in the Declarations section of Module1 thus:[code]....
I soon found I had to change Type to Structure, but then in the declaration of transrec, transtype acquired a wavy blue underline with the error message: "'transrec' cannot expose type 'transtype' in namespace 'Treasurer_2010' through module 'Module1'.So if I can't use the structure in the module in which it is declared, where can I use it?