Search results for query: *

Just off hand, you should be able to make Subs and Functions for your Select and Insert statements. For example... 'Get the Average from StrColumnName dblAverage = queryDB("SELECT AVG(" & strColumnName & ") AS dblAverage FROM " & strTableName & ";") 'Get the...

After more playing I finally figured it out. Thanks. -- Jonathan

I'm no Excel user, but I find myself needing to do some charts. I have three sets of data, one of which I want to be used as the independent/x axis. Then the other two sets of data would correspond to the appropriate point on the x axis supplied in the first set of data. The axis I want...

Yeah, this probably should be posted in an ASP or VBScript forum. Anyhow... try starting a thread there, and then post a link to it in here so we can follow. You might also want to post the code you have handling the submission so we can see what's going on with the data when submit is...

You cannot expect a software developer to release perfect programs all the time. It's already been stated. There comes a time when the project is so complex, bugs are unavoidable. Is it reasonable to expect software developers to release the safest and most bug free software they can? Yes...

IE and Netscape are the most used browsers. For IE, 4+ has good CSS support. For Netscape, 6+ has good CSS support. The latest version of Opera has good support from what I can tell, and I think the version before that did as well. I haven't tested them, but the latest versions of Mozilla...

Virtual Memory is just a page file or a swap file on your hard drive that is essentially treated as if it were RAM. If I'm not mistaken, the VM setup is a little different between Windows versions. The earlier releases use a specified drive for VM. In that case, you basically run out of VM...

That is exactly what I was talking about, and that will also let me expand to a few other ideas. Anyhow, thanks! It's always fun being new to different languages. There's never a shortage of things to learn. -- Jonathan

This is just something I'm playing with at the moment. Suppose I create a user control that contains both a flex grid of some kind along with a text box. I then add that user control to a form. I'm trying to find a way to modify certain aspects of the grid contained in the control just added...

No problem. Just glad to help. -- Jonathan

That seems to do the trick. Assuming I'm following what you're saying... I'm ignoring the quantity field in my database and taking a count of how many records there are of each part type of the same dimensions. The output would be like your example above. It has a list of all part types...

Just from the top of my head, you may need to do two levels of grouping. First you'd need to group by part type, then you'd need to group by the dimensions. Then you could use aggregates to accumlate the quantity and throw a field into your details section linked to the aggregate. I haven't...

Here's what I've done. I'm not sure how your database is designed, so I used a pretty simple and straight forward database. I used an Access database with one table that had 5 fields: part_type, width, length, depth, quantity. DE setup ---- 1.) DE connected to Access db. 2.) Added Command...

Seems like all you would need to do is group by your part type. In your group header, you can throw in a field that displays the part type; in your details section, you can throw in your fields for length, width, depth and quantity. You shouldn't need a field in your db to contain the overall...

Well, the search I ran found this at Microsoft: http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q189847& It states Round uses business rounding rules. I don't know these rules, so I couldn't state whether this is right or not. The deals you describe do go along with the things I've...

There is a KeepTogether option for each section in Data Reports. Just set it to True, and it will keep everything together and not span a section across multiple pages. -- Jonathan

After a quick search, I'm now aware that the Round function rounds using business rounding rules. I'm still trying to find out what these rules are. Is anyone here familiar with what these rules are? -- Jonathan

I've never messed with any tree view, but here's what comes to mind. I'm assuming you mean you want to know which of these was clicked last? Just set a flag each time either one of them is clicked. If A is clicked, set your flag to one thing. If B is clicked, set your flag to something else...

Maybe try using a MSFlexGrid? It's not bound to a data control and should give you the grid that you're wanting. You'll need to populate the grid yourself, but that's no big task. -- Jonathan

Simply put, you guys astound me. -- Jonathan