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!

  • Congratulations bkrike 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: *

  • Users: steve728
  • Content: Threads
  • Order by date
  1. steve728

    Brwose dialog in an Access???

    How do I add a Browse button to a form for selecting a specific file on the current user's hard drive? Thanks, Steve728
  2. steve728

    Is form open in background?

    Please provide me with a code sample of how to detect if a form is open in the backgrund or not. Thanks, Steve728
  3. steve728

    I'm trying to copy a photo into an OLE Object data type field???

    When trying to copy a photo into an OLE Object data type field I get the error message "The OLE server isn't registered. To register the OLE server, reinstall it. How do I do this??? Steve728 MS Access 2000 Win XP OS
  4. steve728

    Where to find help on creating group headers/footers in forms?

    Can anyone show me where to look and learn how to create group headers and footers in a continuous form? I know all is possible but is it really feasible? I know how to do it in reports but forms??? Steve728
  5. steve728

    How to format a time value into a 24 hr one.

    I want to convert a field's string content of "6:00" to "18:00"). Do I use the use the format() function? Will someone show me how to do this?? Thanks in advance. Steve728
  6. steve728

    How to export a table to Excel within a stored proc?

    Once I'm done gathering data into a table I need to export it to an Excel Spreadsheet or a .csv file. Is it possible to do this from within a stored procedure? If so please show me an example of the typeical code. Thanks in Advance! Steve728
  7. steve728

    How to get around special characters???

    I'm having a problem updating the storage.memo field with the contents of Forms![Storage Data Entry]!TxtMemo) because of special chars within it (i.e. ##, ' + *, etc.) Please help me solve this issue. If .TxtPurse.Value > Me.TxtPrior Then strMemo = "-" & Now() & " Increased pocket from...
  8. steve728

    Looking for a good T-Sql testing textbook??

    Can anyone refer me to a good textbook that provides easy to more complex T-SQL tests with answers provided to check the results? The book would hopefully include the tables required or would use the common MS examples.
  9. steve728

    I need a good reference for working with Nested Ifs

    I noticed and confirmed with other users that Crystal Reports XI easily gets confused when you work with nested Ifs. You must help the program by using parenthesis and semi colons. Will someone please refer me to a good reference for learning how to overcome this problem? A textbook or better...
  10. steve728

    How to display 2 alternate colors in the detail of a report?

    I want the detail section to display two colors off and on within the detail section of the report. How do I do this? A formula?
  11. steve728

    Where to find examples of TreeView control w/ vb.net?

    Can someone please refer me to a good source of examples developing vb.net TreeView controls. Steve728 VS.Net 2003
  12. steve728

    If (@Job_Name = N") SELECT @Job_Name = NULL ???

    Will someone please explaing what the following line is doing? If (@Job_Name = N") SELECT @Job_Name = NULL I'm used to seeing more like: If (@Job_Name = 'N') SELECT @Job_Name = NULL Thanks, Steve728
  13. steve728

    What is with Else : Syntax ??

    In my current employer's VB.NET coding I frequently see the following conditional coding: If memvar = True Then Do something... Else : Me.TxtBox.Text = "DuDah" Is there any reason, advantage to using the above versus the traditional syntax of: If memvar = True Then Do something... Else...
  14. steve728

    Basic question about Dim statement???

    Two questions about the following: Dim s, fldCode$ 1. What happens when you don't define the datatype like above? 2. What does the $ signify at the end of a memvar? Thanks, Steve728
  15. steve728

    How to loop thru multiple rows selected in a listView?

    Will someone please provide me a sample of code that will show me how to loop through multiple row selections made within a listview? Thanks in advance, Steve728
  16. steve728

    How to reference a specific column in a listview.

    Basically I need the right syntax so that I can display the value in the listview's 2nd column: MessageBox.Show("You selected FieldCode: " & Me.lvMOCApps.Column2) VS.NET 2003 Steve728
  17. steve728

    How do I create multiple column combo boxes?

    Will someone please either show me how to create a multicolumn combo box with Visual Studio .NET 2003 or refer me to a reference on how do so? Thanks in advance, Steve728
  18. steve728

    How to call stored proc from command prompt?

    Will someone please refer e to help regading how to call a stored procedure from a command prompt? SQL Server 2000 - 2005. Win XP Steve728
  19. steve728

    How to call a SQL proc from within a formula?

    Can someone please provide me with a sample of how one would call a stored procedure from within a formula? Thanks in advance. Steve728 SQL Server 2000 Crystal Reports XI
  20. steve728

    I need samples of how to simplify Access's graphically nested Joins!

    My current employer has MANY graphically created NESTED JOIN queries. They drive me crazy with their complexities and normally have duplications. Is there a a reference some place on-line or a textbook that will serve as a good help in re-constructing them into a more straight-forward simpler...

Part and Inventory Search

Back
Top