Visual Basic

FirstPrevNext

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 Re: Can anyone tell how to get Active Window Dave Kreskowiak4-Feb-05 4:34 Dave Kreskowiak 4-Feb-05 4:34  You can call the Win32 API function GetForegroundWindow[^] to get that windows handle. You can then pass that handle and the appropriate structures to the GetWindowRect Function[^] or the GetWindowInfo Function[^] to get the information you want. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: Can anyone tell how to get Active Window heeren5-Feb-05 2:18 heeren 5-Feb-05 2:18  Thank ya Dave, I'll try this Win32 api functions. And can you tell me is there any other functions in .Net to do is instead of using Win32 Apis. Thank ya again Heeren Bhanushali hiren_sb@yahoo.com Re: Can anyone tell how to get Active Window Dave Kreskowiak5-Feb-05 5:02 Dave Kreskowiak 5-Feb-05 5:02  No there isn't. The .NET Framework BCL doesn't wrap the entire Win32 API. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: Can anyone tell how to get Active Window heeren5-Feb-05 5:09 heeren 5-Feb-05 5:09  Thank ya.. Dave, Thanx for your reply.. Well, can we chat .. or may i have your email ID Heeren Bhanushali heeren@fissionvector.com Re: Can anyone tell how to get Active Window Dave Kreskowiak6-Feb-05 3:52 Dave Kreskowiak 6-Feb-05 3:52  Nope. I only chat with people here at CodeProject. I do this in my spare time, which is rare nowadays. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Get value from a string array. japel3-Feb-05 16:09 japel 3-Feb-05 16:09  Took a file name broken up by delimitors the user picks and passed it to an array. strFile = Path.GetFileName(strFilePath) 'need to extract the filename without the full path strSplitArray = strFile.Split(strDelim) 'split file name & store it in strSplitArray strDirName = strSplitArray.GetValue(0) 'first element of strSplitArray will be the dirName If strDelim <> (strSplitArray.GetValue(1)) Then MessageBox.Show("Check Delimitor value equals the one used in the string.", "Check Delimitor", MessageBoxButtons.OK, MessageBoxIcon.Error) Exit Sub End If This is the code I am using to compare the Global Var the user picks as the delimitor to the one in the file. My_New_File.txt I got My out to make a new folder name with: strDirName = strSplitArray.GetValue(0) 'first element of strSplitArray will be the dirName So I thought replaceing (0) with (1) in the array I would get the delimitor but instead I get a "Index is out of array Bounds" error??? Web and book show the syntex is correct ??? What the???

Last Visit: 31-Dec-99 18:00     Last Update: 25-Sep-24 5:22 Refresh ᐊ Prev1...4217421842194220422142224223422442254226 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.