Search:

Type: Posts; User: BillBoeBaggins

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

  1. MsOf07 Re: disable print and save as command in power point

    Crap. Sorry for the bad advice then OP.

    On a non technical note, where is the presentation being shown where you cannot control the printing?
  2. Re: SQL Stored Procedure not fully loading into DataGridView

    Have you Executed your Sproc in you SQL client to make sure it is acting as expected?
  3. Re: Datatable or Array - VB2008 and MySQL

    IMO. Why do client side handling if you don't have to. Use a UNION with the first query returning the "details", and a second returning Your Cat 5 totals?
  4. Replies
    3
    Views
    8,170

    Re: Importing mdf, ldf files into MySQL

    http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

    Lots of good info in that link. But this section is what your really after...
    Excerpt:
    "There are a wide variety of...
  5. Re: Where does a Temporary table get stored?

    Actually, I believe the table gets removed as soon as the connection/session is closed.

    http://www.tutorialspoint.com/mysql/mysql-temporary-tables.htm

    I believe the "master" db owns them, since...
  6. Replies
    1
    Views
    490

    Re: Bubt on sql string

    Why not use the built in Access functions for dumping data into CSV files?
  7. Replies
    2
    Views
    519

    MsOf07 Re: Activate Macro - External Program

    I am not grasping the context.

    Which program/workbook is doing the opening?
    Which program/workbook macro is supposed to fire that does not?

    Can you describe the order of your events and what...
  8. Replies
    5
    Views
    550

    Re: PivotChart Axis fail

    Can you make the numbers more reasonable? You know how much you look at census data they don't show 42,000,000 they will show it as 42 stating that the number represents millions. That would be a...
  9. Replies
    5
    Views
    521

    Re: Annoying...

    What event do you have the code under? Mine fires every time I open any document.

    Private Sub Document_Open()
    MsgBox "Dude, Test."
    End Sub
  10. MsOf07 Re: disable print and save as command in power point

    Alright, I could not find how to view the events for a Slide in a presentation so I only got so far... however. I see this event below.


    Event PresentationBeforeSave(Pres As Presentation, Cancel...
  11. MsOf07 Re: Psting a picture into a cell

    ActiveSheet.Shapes("Picture 31").Select
    Selection.ShapeRange.ScaleWidth 1.41, msoFalse, msoScaleFromTopLeft
    Selection.ShapeRange.ScaleHeight 1.41, msoFalse, msoScaleFromTopLeft
    ...
  12. Replies
    6
    Views
    970

    MsOf03 Re: MS access 2003- update null fields

    So am I reading this right?
    If me.field1 Is Null Then Null Else Me.Field1
    ......
    So I take it the field is not true Null it is "", but you want it to be loaded with Null if "". So your Nz is not...
  13. Re: Tracking updates to db via datagridview updates

    I am not entirely sure that the DataGrid fires off "SQL Code" as it does stuff. Perhaps create your own control so you can issue the SQL and track it..?
  14. Re: a DB file I have never seen - SQL Server 2008

    Could you mark this thread Resolved please?
  15. Re: [Access SQL] Best way to Save 'Edited' Multi Table records. (Many-to-many)

    Sorry for the late reply.

    I am a control freak so I would do pretty much everything in ADO. I would use linked tables for showing limited quick Select/results queries.


    I have no proof to...
  16. Re: Name of cd included in cd-rom :wave:

    So you want a webpage that access the users CD/DVD drive, indexes the files, then stores them? Is the web server the one with the drive where you will be indexing the files, as I think that is the...
  17. MsOf07 Re: Psting a picture into a cell

    Not going to work then. To the best of my knowledge, images are owned by the sheet, not by a cell.

    Create a small VB app with an image object that can click and paste into, then a text field for...
  18. Replies
    1
    Views
    413

    Re: Minimizing Workbook question

    Identify the event that gets triggered from open via tray and then refer it to the method/event that you trigger upon opening?
  19. Re: OLEDB provider for MySQL + vb6

    I have experience with MySQL but I couldn't give you performance comparisons without looking them up. However, there is no network traffic difference between sending an Update command to SQL Server...
  20. MsOf07 Re: Psting a picture into a cell

    I am guessing that the cell cannot be an owner of a picture.
    What about storing a file path?
  21. Replies
    6
    Views
    970

    MsOf03 Re: MS access 2003- update null fields

    What is "Nz" is that a custom function or a function I have never seen before?
    What errors are you getting, or what is it doing that your not sure why?

    Can this "Nz" function accept Null...
  22. Replies
    6
    Views
    5,202

    Re: phpmyadmin with visual basic

    I agree with Ians. If your already going to the web anyways, might as well make it all web based. Unless of course you have a need/business reason for making it a VB App.

    Personally, I like PHP...
  23. Re: Tracking updates to db via datagridview updates

    Log what happens when the Update (or other relevent Event) event is triggered?
  24. Replies
    4
    Views
    468

    Re: Best way to query these results

    Alright, so you already know how to get the results, and know how to display them. Now you need to take those results and dump them in another database, correct? Just loop through your dataset and...
  25. Re: a DB file I have never seen - SQL Server 2008

    http://www.file-extensions.org/ndf-file-extension-microsoft-sql-server-secondary-data-file
  26. Replies
    6
    Views
    1,015

    Re: Hard Excel to Access problem

    I guess I am not understanding your problem exactly.

    Db1/Tb1: User Info, ID field auto number
    Db2/Tb1: Billing Info, ID field auto number, user_id number

    1. Pull User Info from Excel Top
    2....
  27. Re: [Access SQL] Best way to Save 'Edited' Multi Table records. (Many-to-many)

    Yep. That would merely be my preference though, if you prefer to store SQL in your code go for it in an Acces environment. If this was compiled code, I would definitely use a Sproc.



    That...
  28. Re: saving userform results from vb to excel

    Alright, so on your User Form, you have 8 displayed records, and you want the information on the form in row 7 to be displayed on row 7 (eight if you include headers) in Excel?
  29. Replies
    6
    Views
    1,015

    Re: Hard Excel to Access problem

    Who owns the data stored in Rows 14 +?
    You have a loop for the "Preparer" information that leads me to believe that there is multiple people, do they get a copy/ownership of the data in 14+?
  30. Re: [Access SQL] Best way to Save 'Edited' Multi Table records. (Many-to-many)

    Yep. Using a Stored Procedure.


    Yep. You could display them to the user and show other details for them to confirm the deletion. If you want.


    For Access, I would probably (depending on...
  31. Replies
    0
    Views
    420

    Recommend a book please

    I am trying to get back into the swing of programming and I whenever I visit Barnes & Nobles I look for books in C# or SQL with an emphasis in MySQL. However, I have a preference for the books that...
  32. Re: Error occoured while Import TXT in sql 2005

    Is this a script that recreates the tables and then appends the data, or just a raw data dump?

    Because if it is a raw data dump, the "settings" your looking for are just where they should be under...
  33. Replies
    2
    Views
    672

    Re: SQL Cast problems

    Can we see your code where you are utilizing CONVERT?
    Is this SQL Server or...?
  34. Re: [Access SQL] Best way to Save 'Edited' Multi Table records. (Many-to-many)

    If it was me, I would prefer to actively track what they delete or delete then refresh as they do it. I 120% do not like the idea of removing records from a database based off what is no longer...
  35. Replies
    8
    Views
    674

    Re: Stay and listen?

    A thought.. possibly a wrong one. What if the server ran an app to send notifications to the clients when an update happens? So rather then X number of clients bumping against the server at...
  36. Replies
    6
    Views
    621

    Re: Easy String question

    http://www.vbforums.com/showthread.php?t=395267
  37. Re: Crystal Reports v10 - Summing fields, values may be null

    I gave you code (whoops) in Inline IF format. You need to convert it to your syntax/flow.
  38. Re: VBA - Excel ('03) Userform event handling

    You are right, not possible. But found a thread for emulating a Control Array in VBA.
    Understanding events. IV: A substitute for control arrays in VBA
  39. Replies
    3
    Views
    1,039

    VS 2008 Re: System Wide Mouse Hook

    Google: vb.net mouse hook
    4th Link.
    How to set a hook in Visual Basic .NET
  40. VS 2008 Re: [EXPRESS] Open listening connection? (Like Console)

    Complexity is relative. Windows or Console depends on your purpose.
    Start here:
    Using the Winsock Control in Client/Server Applications


    What are you trying to achieve?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width