Comments by ChandraRam (Top 69 by date)

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

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.

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.

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

How are you calculating the "starting inventory"?

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.

Whereas it displays OK in the report header?

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

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?

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?

Sure - post what you have done so far.

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.

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

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?

You do that - and please post here...

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.

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

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

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

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.

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 :)

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).

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...

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

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?

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

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

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.

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

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

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

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

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

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.

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

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

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

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.

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.

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

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.

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

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

What have you tried so far?

What have you tried?

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

Post code you have done so far

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.

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?

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

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

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

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

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

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

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

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

Do you mean horizontally or vertically?

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).

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...

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?

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.

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?

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