Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Suraklyn

    How to clean up my VB code?

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

    Excel 2002 Charts

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

    Excel 2002 Charts

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

    javascript:history.back()

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

    The new commercial of Microsoft.

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

    remove scrollbar on homepage

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

    Low Virtual Memory Error

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

    User Controls

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

    User Controls

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

    Grouping Fields On Report Line...

    No problem. Just glad to help. -- Jonathan
  11. Suraklyn

    Grouping Fields On Report Line...

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

    Grouping Fields On Report Line...

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

    Grouping Fields On Report Line...

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

    Grouping Fields On Report Line...

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

    Round function rounding rules

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

    Data reports

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

    Round function rounding rules

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

    TreeView ?

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

    Want to populate a datagrid with a select stmt.

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

    DateDiff - Years

    Simply put, you guys astound me. -- Jonathan

Part and Inventory Search

Back
Top