Hai,I had developed on project entitld as resume handler in vb.net 2005 and ms access 2000.In this we are storing the candidate details who are all applying for job in our company.It will entire details of the candidate.I want to add another advantage in my project.If I select a candidate name a Rep...

We are migrating all our crystal reports from Crystal Enterpise 9 to BO X1.I used the BOXI Import wisard to import all the reports from CE 9 to the new BOX1 Server Successfully.But currently the reports are pointing to a old database, whereas we need them to be set located to a new database. Is the...

Im using a report with a sub report to show the result on a web survey. The main report is used for making the selection (for instance: show only people that answers A on Q1 and C on Q2 ), and the sub-report should present the data. I would like the main report to generate an array of people and sen...

Hi, I want to implement a pixel detection in my program, so it does something like this:Check the pixels (rgb, or what ever, I don't mind) in a certain (given) location in the screen (100,100) and compare it to something else, so I can use it so:[Define pixels location and stuff here]If pixels...

Hi all.Here's my problem:I have a main form (actually, the only form in my project) with a treeview. The treeview is populated on the form load with informations from a text file that is downloaded using a tcp connection. That's all working fine.Now i'd like to change the mouse cursor...

I am having problems with my dynamic array, I have a function to find the UBound of the array and if it is equal to or greater than a variable then it adds 10 to the variable. It is also supposed to find the next avalible array section to put a variable in. My problem is that when I try to load th...

i have two Running Total Fields<br/>Total NWN and Total Keyed<br/>how can i add these two Running Total Fields?<br/>and how can i connect mysql to crystal report?<br/>thanks

HiI created a program using VB6.0 and i made a setup file for it. When i tried to install it on other PCs, it worked fine under Admin accounts but when using Limited account user, the program couldn't open because the database was not opened. I got this error message (Microsoft DB Engin couldn...

Hello I am trying to create a program that uses the webbrowser. I have two buttons included on this program one thats called play and one thats called stop. The webbrowser is linked to a snapshot image from an ip camera. When the play button his hit I would like to have the webbrowser refresh con...

Hi, i have a problem with report.papersize when printing in crystal report.at first i'm using crpaperfolio value for used with printer that has default folio setting.. but yesterday the printer was replaced by printer which don't have default folio setting..so when i print the result is no...

hello,I am trying to save to a .txt file...First I have:1 command button (command1)1 Textbox (text1)1 .txt file (file.txt)I want to be able to enter text into the textbox and when I click the button allow the text which is entered in to be saved to the .txt file (file.txt).The .txt file may already...

Hi All,I have a program that works alongside another program.At the moment i have to have two seperate programs as there are two versions of the program 13 and 14 that i want it to work alongside. Both programs i have written are exactly the same bar the dll being used (which are not backward compat...

Hi,sorry i can't find a good example or thread about this.basically, i want to catch the FileNotFoundException.how do i do this please?i have the followingOn Error GoTo ErrorHndSet obj = CreateObject ("...");ErrorHnd:'how do i test that the error is a FileNotFoundException here...

Hi all,I have problem with RichTextBox control in vb 6.0 I need to drag text/picture/mail message, files & drop them onto richtextbox.When user double clicks on that file in richtextbox the corresponding file should open(as the richtextbox control may contain multiple files dropped on it).Is there...

Hi!Im creating a report with a manual running total in a main report. As a condition to the running total, Im having a sub-report in the details section bringing a shared boolean variable back to the main report.My problem is that I dont want the sub report to be visible. Have tried suppress it, but...

how to copy from the string to the structure ?? it can be using win APIand different how to copy from sctructure to stringEvery time i am using operations on files to be able to fill correctly the structuresHow works function "Get"? It attributes nice to the structureBuf=010000000800000004004E6F6E65...

Does anyone know of a method to hide a window before it appears or before it is sent a window message such as WM_SHOW.I am thinking this is going to require some message stream monitoring (hooking) and I am wondering if someone can point me in the right direction of a specific API function to use or...

I have just installed Office 2007 and changed the references in a VB.net program to use the new settings however the program will no longer function properly on a computer with an earlier version of office. how can I make the program function with older versions of office?Thanks in advance for any h...

Hi,I have a DLL write in VC , in this DLL a function is declare follow :BOOL InitMyDLL(LPWORD Alpha, LPWORD wrdpack); now i want use this function in my VB project , but any type get for LPWORD (Inteeger , long , double ,...) and run my project when this function call get this error :...

Hello.I have some problem in cross tab,I'm creating cross tab like as follow.On Row displaying s_Questions On Column displaying d_DateOn Summarized field dispaying s_ScoreOfQuestionOn perticular date client will ask 10 question to it's user and give score betwen 1 to 10 for every question....

hello <br/>please could anyone help me to insert an image into crystal report if I saved the link in the database . I tried to change the type to "ole object" it works, but i don't have to change the type in my project.

plz help how to update a MS Access DB through recordset with values from text boxes using JET.OLEDB.4.0 database engine.

Following code gives wrong answer;Option ExplicitPrivate Sub Command1_Click()Dim a1 As Single, b1 As SingleDim t As Singlea1 = 31.4b1 = 32.1t = b1 - a1Print ta1 = 1.4b1 = 2.1t = b1 - a1Print tEnd SubIt should print 0,7 two times, instead of that it gives 0,6999989 and0,6999999. If I change variable...

HiI using VB.Net 2003 with simple SQL commands in my code.Now my application open the Access database file with no user name or password but i need to add this support to the MDB file so my basic questions re:1. How can i add via code a new user + his password to the MDB file?2. How do i open a MDB...

Hello I've been going thru Ged Mead's charting articles and they work in VS 2003 but not in VS 2005. The line chart in particular. I am getting no errors but on the chart it has a solid blue horizontal line for the points instead of nice random points. I've tried to vary the data numb...

Ok, So I wanted to get this correct, I can inject a dll into MY own vb program, the dll is programmed in C++ and has this function:void __declspec(dllexport)__stdcall Send(UINT Message, WPARAM Wp, LPARAM Lp){ HWND hWND = FindWindow("MapleStoryClass", "MapleStory"); MSG Msg; Msg.hwnd = hWND; Msg.lPar...

Hi there,I'm working on a small project that requires me to load PDF file within a form. Just look at the picture below and you will get what I'm saying. http://img.photobucket.com/albums/v373/nightmareb/PDFform.jpgIf you have any solution, please let me know. Thank you...

I have a VB6 App using Access 2000 Database. Frequently, it will lockup on some of the users machines forcing the server to be rebooted.The server is actually just one of the PC's which shares its Access Database with 3 other users.When one PC locks up, it causes the others to stop functionin...

Hi All,I am new here on this forum , i have a database of student registered for 2007-2008 with field of student names and term and i need a formula to show me distinct count of students registered for the following 1)Students registred for both fall and spring2)Students registered only fall not fo...

Many Point of Sale program use this format for flexgrid. I use vsflexgrid and i try to clone but i have problems.<br/>Please Help!!!

I would like to know if it's possible to create a report that would react to user events. I would like to allow the user to click on a any value and produce a new report that would explain how this value was calculated. <br/>Thanks<br/>Rufen

Hi, Wonder if anyone can help me:I have a report that has a crosstab which populates a large number of columns across the page. This works fine and can be exported to excel etc.The report also contains a sub report which too contains a crosstab. However the page size is restricted to the size of the...

Dear Gurus:<br/>how can i cleanup an exception occurred in Try section or don't throw the exception to the caller? <br/>i try to start a process and if it fails, i would like to do something else and not throw any exception from here. <br/>Thanks,

I need to change the following string formula to be Right Justified it is currently print out as Left. Can anyone help me change it.//firstpay e-name 40 digitsStringVar T1;StringVar T2;StringVar ExStr;NumberVar L;NumberVar X;T1:=' ';X:=Length(T1);Ex...

Hi guysI have a problem with my module, here is the code:Sub ReadLanguages()Dim Language, caption As StringLanguage = ReadIniFile(App.Path & "\EN.ini", "Language", "Language", "")Form1.caption = ReadIniFile(App.Path & "\EN.ini", "Language", "Title", "")ElseLanguage = ReadIniFile(App.Path & "\FR.ini"...

I have an application that has been working in a Production environment for a few years now. I need to make some tweaks to it and I'm at the testing phase and all of a sudden, I'm getting a Path/File Access Error with the filename in question being one of those vb*.tmp files (it's a...

Hi everyone, I have two tables "TableA" and "TableB" TableA has 9 columns and TableB has 4 columns. I created a new table "TableC" with 5 columns. I want to copy 3 columns from TableA(with its data) to TableC and Copy one column from TableB to TableC . I added a new column to TableC and this column...

Hello all,Problem #1: Please could anyone show me the code to add a new worksheet to my existing workbook.Problem #2: I want to assign my old worksheet name to the new worksheet(NewxlWksht), then Delete the old worksheet(xlWksht)Below is what I'm currently doing:Set xlApp = CreateObject("Exce...

Hi there, Server Database: MS SQL Report Database: MS ACCESS Report Viewer: Crystal 9.0 I have a Report Viewer Program w/c i always install(Create Package) to each workstation every time i made modification. Is there a way (vb code) to install only this program once (t...

When I restore a minimized form from a command button on another visible form by frm.windowstate = vbNormal, the form restores and gives focus the the control on the form as it should. However when I attempt this same code from a tray icon, the minimized form pops into view, but NEVER gains focus...

Hi,I'm new to Crystal. I sure hope someone will be able to assist me in this fairly easy problem. I have sets of data that returns values for each of the 4 quadrants. An example:Quadrant A: 7Quadrant B: 20Quadrant C: 8Quadrant D: 2The above is for Group 1. I also have a Group 2 with its own dat...

I have a doubt to link USB BT-4500 scanners and USB keyboards with VB 6 programming.If one of you know let me know commands and way to link them together.<br/>thanks,<br/>Dulika

hi guys, i am quite new to .net programming and i have to do this task which when i want to add information a pop up box will display and i will add the information in, once okay it will be displayed in a data grid. any suggestions or opinions on how do i use the pop up box and get them to add into...

hi,<br/>can anyone tell me how to do rounded button with gradient color inside?<br/>OM.

Hi to all, I am using the Custom-Multi column report which is selecting from theReport Gallery. Inside the detail section-printing section, there are only 2 options. 1. Across then down 2. Down then across. But my requirement is some thing different fr...

I have a collection that has an entry and a key.I can see if an entry exists by the Contains method.How do I get the index of the element so that I can use the item method? Can the index be the key (A string)How do you properly create this collection?Isn't:Dim myCol as Collectiongood enough?Mus...

Hi, Still working on this **** report, its getting to be beyond a joke now. Its format just changed again (you all know the score).The first problem i want to deal with is to get a count of the short stops we are having.I have set up a running total that is like soField to summarize = tblDowntime.DT...

I have the following problemhow do I change the backcolor of a tab of the SSTab objectIt has a property backcolor but that changes the backcolor of the object en not of the tab pageI would suspect there is a property somewhere, but if there is one it has eluded me.Does anybody know is there a proper...

Okay, I am pretty new at this, so this may be obvious, but here's what I want to do.I have an Access database that can be used to reserve resources. The user inputs a date range and then checks off what they want to reserve. It looks like this:StartDate .............EndDate .........Laptop......

Hi,<br/>I just wonder - Is it possible to have VB6 client listening to non-default event interface of a COM?<br/>It seems that 'WithEvents' keyword supports only default event interface. <br/>I'm not so familiar with VB. Please help.<br/>Thanks in advance.