Comments by ChandraRam

ChandraRam 2-Jul-24 3:39am View

What is the SecurityProtocol set to?

ChandraRam 30-Jul-19 16:02pm View

Instead of a preview, try to display that data set in a datagrid, for instance, and see if that extra column shows up.

ChandraRam 25-May-18 15:35pm View

Thank you, will do that and share code here.

ChandraRam 25-May-18 15:35pm View

Thank you.

ChandraRam 25-May-18 15:21pm View

Yes, it is.

ChandraRam 25-May-18 15:14pm View

I have tried it after setting the permissions as full access to everyone - no luck. The program is able to create the activity log, so it can't be that it is unable to write to that folder.

ChandraRam 25-May-18 15:12pm View

The program is able to write the activity log, so I guess write permissions on that folder exist.

ChandraRam 25-May-18 15:00pm View

Thank you.

It already creates an activity log, which is how I know that the authentication passed. There is no error returned at the ftp download command, just that no file is downloaded.

ChandraRam 25-May-18 14:23pm View

Deleted

Yes, that is why I had mentioned that this program is similar to a console app, and does not have any user interaction.
Thanks for looking and your time, anyway.

ChandraRam 25-May-18 14:02pm View

Thank you for the reply.

The program is a console app - it downloads a file from an ftp url for further process. Specifically, the ftp download does not take place, when run from the scheduler. I know that the authentication has succeeded, but no file is downloaded.

ChandraRam 22-Nov-12 10:11am View

No, there isn't. However, you could set the parameters from within your program, with the error handling right there.

ChandraRam 22-Nov-12 9:32am View

How are you calculating the "starting inventory"?

ChandraRam 25-Oct-12 14:03pm View

Charts, will be shown in the report headers (or footers) and/or group headers (or footers). Try to see if you can insert a group in your record, and include the chart there.

ChandraRam 25-Oct-12 13:55pm View

Whereas it displays OK in the report header?

ChandraRam 24-Oct-12 6:42am View

What happens when you move that chart to the detail section?

ChandraRam 2-Oct-12 16:09pm View

Can you give more information on what you mean by "new user"? Perhaps a simple date filter to filter out your dataset should solve it for you?

ChandraRam 12-Sep-12 3:54am View

The data that doesn't display correctly - is it from a database? If so, do you have the correct encoding for your database and tables?

ChandraRam 31-Aug-12 14:22pm View

Sure - post what you have done so far.

ChandraRam 30-Aug-12 10:42am View

I don't think so :) I have given you enough information to try it out on your own... do that, and then if you get stuck, post what you have done and I will help you further.

ChandraRam 30-Aug-12 10:37am View

Set a flag when you reach the text that you are looking for, and add to the list only when the flag is true.

ChandraRam 30-Aug-12 10:24am View

If you delete the paragraph, it is going to remove it from the document - do you want that? Or do you want to just not add it to the list box?

ChandraRam 30-Aug-12 9:32am View

You do that - and please post here...

ChandraRam 30-Aug-12 9:03am View

Well, I think you haven't understood me at all... The response data is coming from a COM port, right? I have been asking you to read the response directly into your structure.

ChandraRam 30-Aug-12 8:59am View

The first format statement
temp = Format(temp, "dd-mm-yyyy")
is not really necessary.

Try this:
strSQL1 = "SELECT * FROM AllProjects WHERE [StartDate]=#" & temp & "#"

ChandraRam 30-Aug-12 8:57am View

I think the delimiter is # (not single quotes) for Access tables.

ChandraRam 30-Aug-12 8:55am View

Why do you have one byte extra for each field? "RE" is just 2 char, right? Similarly for all the fields...

After fixing this (and getting it to compile ;), if, as you say the data is ASCII, then parse->TreatedBloodVolume should give you the value in a string. Like so - "10.20", for instance.

ChandraRam 30-Aug-12 8:49am View

Right. What happened to the header info? The first 6 bytes? If that is part of each response, you need to have that in the structure as well... as I told you right at the beginning :)

ChandraRam 30-Aug-12 8:41am View

The report filters for supplier correctly? Check that your parameters are actually being applied to the report - you can do this by temporarily displaying the parameters in one of the report sections (report header, for instance).

ChandraRam 30-Aug-12 8:40am View

Have you managed to create the structure? Do you know how to create structures that hold strings (characters)? If yes, post what you have done here and I will attempt to go from there...

ChandraRam 30-Aug-12 8:31am View

You said it is stored as ASCII, right? If so, just create a string of the specified length and you should have it?

ChandraRam 30-Aug-12 8:17am View

I have no idea what your data is like - you mention in your question that it is all ASCII, so it should be a matter of just reading it as strings, right? Why don't you put it into the structure and read it to see what you actually get?

ChandraRam 30-Aug-12 8:10am View

Create your data structure to include the _complete_ response (including the "header" information), even if you do not want to use them further.

So, your structure should start with:
Type - 2 bytes (to store the "RE")
Flag - 2 bytes (not sure what this data is since you do not mention that)
MachineNumber - 2 bytes
Status - 1 byte
....
and so on.

HTH

ChandraRam 30-Aug-12 7:59am View

What have you tried so far? Where are you stuck?

ChandraRam 16-Aug-12 9:45am View

Explain "dynamic report" - do you mean create the .rpt file itself? If so, then that is not possible. Crystal Report structure is a closed architecture.

ChandraRam 16-Aug-12 7:07am View

You should post this in the SB - will probably get a lot more responses (and a few relevant / good ones as well :)

ChandraRam 13-Aug-12 2:50am View

Crystal Reports supports utf8 so displaying Gujarati should not be a problem. What have you tried and what problem are you facing?

ChandraRam 13-Aug-12 2:48am View

It is highly unlikely that somebody is just going to give you the code for this. Do some study, either from a book or online, on what constitutes a client-server program, and how you can apply that to your current requirement. You could start with numerous examples found online and modify to suit.

Also, you have included the VB6 tag... are you planning to develop this app in VB6 then? I would suggest you look into VB.Net.

HTH

ChandraRam 13-Aug-12 1:37am View

If you want to call both functions, one after the other, from your button click, write another function that has just the two lines - one call to each of the functions.
HTH

ChandraRam 11-Aug-12 13:27pm View

Not sure if I understand your exact requirement... can you not create the report with the chart in the group header (or footer)? That way, you will get multiple charts generated, one for each group of data.

HTH

ChandraRam 8-Aug-12 7:00am View

You will anyway need to distribute the DLL file. So long as Excel is able to find it in the path, it should work fine. Just add the function declarations your VBA project, with instructions when distributing, to place the DLL file in the same folder as the Excel file.

ChandraRam 8-Aug-12 6:42am View

For your sample data set, can you show what the actual values of ?? should be?

ChandraRam 31-Jul-12 8:50am View

Can you place the code to re-size your chart in the Workbook_open event? Crude, but it will at least work :)

ChandraRam 12-Mar-12 8:08am View

What have you tried so far? Post your code and say where you are stuck...

ChandraRam 2-Mar-12 8:15am View

Well, if you can't use the Windows task scheduler, you should have your app running all the time. Since you do not want it to interfere with other apps that the user may start, you should have it minimized to the system tray. The polling (checking) for current time is so that your app can perform the specified task at the required time. Code samples for all of these tasks are available out in the interweb.

ChandraRam 1-Mar-12 13:36pm View

The program does exactly what you have asked it to - the parameter is set outside the loop, so it will only contain the last value.

ChandraRam 6-Feb-12 2:16am View

SelectionStart is a property of the text box. Did you look it up?

ChandraRam 13-Jan-12 7:40am View

Then post code that you tried and ask for help with specific bits - you should not expect to get the complete project's code done for you.

ChandraRam 12-Jan-12 7:16am View

What have you tried so far? You will get millions of hits if you do a Google search for this.

ChandraRam 11-Jan-12 15:26pm View

Can you paste the code you tried with the TableLogonInfo here?

ChandraRam 11-Jan-12 15:01pm View

What have you tried so far?

ChandraRam 11-Jan-12 8:34am View

What have you tried?

ChandraRam 28-Oct-11 8:56am View

Why not set the MinValue to the current date every time that form is loaded?

ChandraRam 28-Oct-11 8:49am View

Post code you have done so far

ChandraRam 20-Oct-11 15:33pm View

When it is a binary file, there is no concept of "line by line". Do you want to read a text file?

Btw, you should probably be using VB.Net instead of VB6 now.

ChandraRam 18-Oct-11 10:07am View

Are you using the code as is or have you made any modifications? Like I said earlier, did you debug and check whether the object is valid?

ChandraRam 18-Oct-11 8:09am View

It looks like "wrdMailMerge" is not available. Have you checked that the object is valid? Post the code used to create this object.

ChandraRam 17-Oct-11 14:45pm View

Google will give you loads of samples for this. What have you tried?

ChandraRam 8-Oct-11 15:29pm View

Search for "Word automation" - you should find loads of samples.

ChandraRam 8-Oct-11 15:28pm View

Have you tried using a sub-report for the graph?

ChandraRam 28-Sep-11 10:37am View

It is not the down-voting I mind, but would be good if there was a reason for it, and it was specified here. Will help me learning as well. Thanks

ChandraRam 28-Sep-11 6:47am View

Google for XMLDocument and DOM. You should find quite a few samples there.

ChandraRam 19-Sep-11 11:12am View

If you still have access to Foxpro, perhaps you can "pack" the data tables?

ChandraRam 19-Sep-11 10:59am View

Check if you are able to actually connect to the DB using the parameters you have provided from within the code. Use a connection string containing these details and make sure that a valid connection is created.
HTH

ChandraRam 25-Aug-11 9:12am View

Do you mean horizontally or vertically?

ChandraRam 24-Aug-11 10:55am View

Why are you calling CreateObject when the object type is already known? In other words, why use late binding, when you have already typed the variable? And, nowhere in this snippet is the code bound to a version of Excel (except in the dialog filter, when you are not allowing .xlsx files).

ChandraRam 17-Aug-11 9:02am View

Isn't this the same as your previous question? Maybe you should wait until somebody who knows why can answer you, instead of posting the same thing over and over...

ChandraRam 16-Aug-11 3:52am View

Not very clear... what do you mean by "for all paper print"?

When you design a report, you need the specify the paper size, correct?

ChandraRam 16-Aug-11 3:49am View

From the four possible overload functions, you can see what types are acceptable as parameters to the ReadXml function. None of those match the type of the variable "xmldocument" that you are passing as parameter.

ChandraRam 16-Aug-11 3:44am View

That still does not answer the question I asked - please check in the design of your chart what limits you have set for the Y-Axis. The two values you say are showing - are they the lowest / highest two values?

ChandraRam 9-Aug-11 11:02am View

How are you fixing the scale for your Y-axis?

Comments by ChandraRam (Top 70 by date)