Visual Basic

FirstPrevNext

file.exists but not accessible KreativeKai4-Feb-05 2:17 KreativeKai 4-Feb-05 2:17  We've found that if you have logic checking the existence of a file and you don't have access to the folder, the logic simply comes back as not exists. For example if there is definitely a file called test.txt on the H:\ drive root directory and we don't have access to that drive the following logic simply executes the else part of the logic. if file.exists("H:\test.txt") then msgbox("It exists") else msgbox("It does not exist") end if How can we check if we first have access to a specific directory or drive? Any help is appreciated. Lost in the vast sea of .NET Re: file.exists but not accessible Dave Kreskowiak4-Feb-05 5:57 Dave Kreskowiak 4-Feb-05 5:57  You just did. Since you can't see the object, you can't get your access rights on it either. If you try to get your rights to the object, Windows will come back with something like "We can neither confirm nor deny the presence of H:\, let alone your rights to it." RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: file.exists but not accessible KreativeKai10-Feb-05 4:32 KreativeKai 10-Feb-05 4:32  We found that the following code worked well. Try ……… Directory.GetFiles("c:\test") ……… Catch ex As UnauthorizedAccessException Msgbox(“Sorry you’re not able to access the file….. yada yada yada”) End Try Thanks for your assistance! Lost in the vast sea of .NET Re: Minesweeper with 3 tier Dave Kreskowiak4-Feb-05 6:00 Dave Kreskowiak 4-Feb-05 6:00  You might want to try asking a question we can answer. None here will "guide" you in creating an entire application, since that is way beyond the focus of these forums and beyond the capability of a forum for that matter. If you have specific questions about problems your having, great! We can do our best to try and answer them. But a generic statement like "I wanna write an app." is not going to help you at all. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome DB Merge question from newbie pedros733-Feb-05 23:11 pedros73 3-Feb-05 23:11  I have a standalone application written in VB.NET that uses an access DB. The application is portable and used by several users on differnet machines. I want to be able to sync the portable DB's with a master DB. Is Replication the only way? The DB's are password protected at present. I can think of a way using replication with JRO, but that seems a bit old hat now. Please help DB Merge question from newbie pedros733-Feb-05 23:10 pedros73 3-Feb-05 23:10  I have a standalone application written in VB.NET that uses an access DB. The application is portable and used by several users on differnet machines. I want to be able to sync the portable DB's with a master DB. Is Replication the only way? The DB's are password protected at present. I can think of a way using replication with JRO, but that seems a bit old hat now. Please help Re: DB Merge question from newbie Dave Kreskowiak4-Feb-05 6:07 Dave Kreskowiak 4-Feb-05 6:07  Yes, replication is about the only way your going to accomplish this. You can either use the Replication facilities built into Access or use a 3rd party utility to do it, or come up with your own scheme and code. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Crystal Reports Logon problem Alan Hallett3-Feb-05 22:38 Alan Hallett 3-Feb-05 22:38  Is anyone else having problems with logon boxes when trying to show a Crystal report? We have an application which stores data internally as a set of collections. When we need to print the data on a report, the application loads the data into a set of tables within a dataset, applies the logon information, writes the data to each table, assigns the relevant report to the Crystal report viewer and .Shows the report. All of this works and has been working for months. Yet a recent deployment on a Win XP Home (SP2) machine invokes the logon box for a single table at the reportviewer.Show statement. I.E. the table has already been logged on to - and data has been written to it. Other tables in the dataset do not suffer the problem. Other reports suffer the same problem - a single table, not always the same one, requires a logon at .Show time. And all other machines continue to work OK. I can see from searches on the net that this logon issue for datatables and Crystal is problematic - so what gives? Is there a known issue here? Any ideas/info gratefully received ... Re: Crystal Reports Logon problem Joel Parmer8-Feb-05 7:21 Joel Parmer 8-Feb-05 7:21  Greetings Alan! I too have suffered from the dreaded log on window appearing when it is not expected to . What *sometimes* helped me was to "verify database" to force Crystal to look at the data source again and clear up any issues that may exist. Hope that helps! Joel Parmer Re: Crystal Reports Logon problem Alan Hallett8-Feb-05 21:27 Alan Hallett 8-Feb-05 21:27  Hi Joel And thanks for your reply. The problem is, as you say, maddening. I have now reported the issue to Microsoft Support - who seem to agree that I'm not the first to suffer it. Watch this space and I'll report what happens. I'll try the 'verify database' you mention but I must admit that I'm not exactly sure what you mean. How would I do this? Many thanks Alan Re: Crystal Reports Logon problem Alan Hallett12-Feb-05 2:19 Alan Hallett 12-Feb-05 2:19  Problem solved. I reported the whole thing to Microsoft Support and, after a lot of trying this and that, it appeared that the merge modules shipped with VS.NET 2003 had problems. Crystal have made available a fixed set of modules available at http://support.businessobjects.com/fix/merge_modules.asp Installing these (on the development machine) solved the problem. listbox to textfile johnjsm3-Feb-05 22:37 johnjsm 3-Feb-05 22:37  Hi, I have a program that looks at a folder for a specific type of file and if its there it adds it to a list box. I then have the list box contents output to a text file. Everytime a file is added to the list box its added to the text file. Only problem is that when the file is removed from the folder its removed from the list box and textfile also. I am trying to find out a way to write the contents to the text file but when the files are being removed it will not remove them from the text file. Can anyone help with this Thanks Re: listbox to textfile Dave Kreskowiak4-Feb-05 6:09 Dave Kreskowiak 4-Feb-05 6:09  Then change the code that write the data out to the text file to compare the data in the listbox with the data loaded from the text file. If there are delete records in the listbox, just don't delete them from the text file. If there are existing records in both, don't add it again. If there is new data in the listbox, add it. Why is this so hard? RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome round function in VBA Stephan Wright3-Feb-05 22:13 Stephan Wright 3-Feb-05 22:13  Hy everyone! I do have the following situation <br /> DIM myint as Integer<br /> DIM myreal1 as VARIANT<br /> DIM myreal2 as VARIANT<br /> <br /> myint = myreal1 / myreal2<br /> VBA in Excel does the following: If myreal1/myreal2 < xx.5 then round to next LOWER integer if myreal1/myreal2 >= xx.5 then round to next HIGHER integer But I do want the result to be round to next LOWER integer EVERYTIME! meaning 0,95 should be 0 and 0,45 aswell In C there is a function name floor() which does this, but I could not find a similar function in VBA. If anyone knows the relevant function in VBA please let me know. Thanks! Stephan. Re: round function in VBA Stephan Wright3-Feb-05 22:53 Stephan Wright 3-Feb-05 22:53  I just found out myself. it's the int() function in VBA Stephan. Re: round function in VBA Just Greeky Creek3-Feb-05 23:30 Just Greeky Creek 3-Feb-05 23:30  Public Function Ceiling(ByVal X As Double, Optional ByVal Factor As Double = 1) As Double ' X is the value you want to round ' is the multiple to which you want to round Ceiling = (Int(X / Factor) - (X / Factor - Int(X / Factor) > 0)) * Factor End Function Public Function Floor(ByVal X As Double, Optional ByVal Factor As Double = 1) As Double ' X is the value you want to round ' is the multiple to which you want to round Floor = Int(X / Factor) * Factor End Function Determine DLL/EXE Version number nikneem20053-Feb-05 21:17 nikneem2005 3-Feb-05 21:17  Hello there, I'm having problems reading a DLL Version number. I used the System.Reflection in order to load the assembly, and then read the version number. No problem, it works fine! But since we cannot unload, the dll is locked untile my app shuts down. My app is a WebService, so won't shut down every second Is there another way to get the version number of a dll/exe, or to unload an assembly so that it's overwritable again? Thnx I love it when a plan comes together Re: Determine DLL/EXE Version number Dave Kreskowiak6-Feb-05 3:53 Dave Kreskowiak 6-Feb-05 3:53  You can check into creating a new AppDomain and loading your .DLL into that. I don't have any example code, because frankly, I've never done it. But, I have seen it discussed in the c# Forum about 6 months ago. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome determining active node on clustered servers MagicGirL833-Feb-05 20:35 MagicGirL83 3-Feb-05 20:35  hi.. how can i determine the active node on a clustered server on a vb.net project? each cluster has 2 nodes for example: server1a server1b server2a server2b server3a server3b and the active nodes are server1a, server2a, server3b i'm trying to develop a project that will list just the active nodes .. any idea would be greatly appreciated. msn: cute_leny@hotmail.com Re: determining active node on clustered servers Dave Kreskowiak4-Feb-05 4:29 Dave Kreskowiak 4-Feb-05 4:29  Are we talking about a Microsoft cluster, Novell, Linux, ...? For a Microsoft cluster, the easiest way is to use the Cluster Automation objects. You can start by reading the documentation on them here[^]. Microsoft clusters also don't have an "active" node. Nodes are either up and available or down for some failure or administratively down. You can find out which nodes are "available" and which are "down". RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: determining active node on clustered servers MagicGirL836-Feb-05 12:03 MagicGirL83 6-Feb-05 12:03  hi there.. thanks for replying... yeah we're using Microsoft Cluster. i'll try that and see what i can do from there.. thanks for the help...really appreciated by a newbie like me.. Re: determining active node on clustered servers MagicGirL839-Feb-05 18:41 MagicGirL83 9-Feb-05 18:41  Hi there.. I’ve seen the link on the documentation of server cluster API’s from msdn but it seems that it was just applicable for windows server 2003 and codes for C++. We only have windows 2000 advanced server. I’m developing remotely from the servers and I really have no idea how to access and manipulate these APIs using asp/vb.net.. Can you give me an idea how to do this in asp/vb.net? I’m really a newbie with this technology.. hope you can help me.. thanks.. more power.. Re: determining active node on clustered servers Dave Kreskowiak10-Feb-05 6:10 Dave Kreskowiak 10-Feb-05 6:10  The API calls work on any Windows Server 2003, Windows 2000 Datacenter or Advanced Servers, or NT4 Enterprise SP# or better. I think your looking at the WMI objects. Those are Windows Server 2003 only. You can call the cluster API's from VB.NET just as you can call any of the Win32 API functions. There is very little information on using the Cluster API's in VB/VB.NET, so it's definately going to be a research project, trial-and-error kind of thing. There is no known example code either. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: determining active node on clustered servers MagicGirL8310-Feb-05 12:30 MagicGirL83 10-Feb-05 12:30  yeah.. i've also done some research and so far i have not seen any codes/project like this before..got really no idea how to do this and i'm stuck with this project for 2 months now.. anyway, thanks a lot for your time and goodluck to me.. Can anyone tell how to get Active Window heeren3-Feb-05 18:15 heeren 3-Feb-05 18:15  Hi guys, can anyone help me to get Active Window, I want its properties like Height x Width and its position. like Corel Capture. can anyone help me for this Heeren hiren_Sb@yahoo.com

Last Visit: 31-Dec-99 18:00     Last Update: 6-Jun-24 18:13 Refresh ᐊ Prev1...4216421742184219422042214222422342244225 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.