Search:

Type: Posts; User: nO_OnE

Page 1 of 12 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: How to call routines/functions from a different program

    Thanks for the quick response Shaggy!

    I was thinking about a few different ways of handling it - like you suggested, writing to a CSV file or something similar, or I could even write data to the...
  2. How to call routines/functions from a different program

    Hello,

    Here's my scenario: I have a computer, which is away from the operations desk, that runs some displays (PI ProcessBook displays, OSISoft) which are cast into another expensive corporate...
  3. Thread: drop-down box

    by nO_OnE
    Replies
    1
    Views
    806

    MsOf10 Re: drop-down box

    You could try using bookmarks: https://msdn.microsoft.com/en-us/library/office/ff821971.aspx
  4. VS 2005 Re: Problem adding data to database access 2007 after deleting the data from database

    Not entirely sure what you are saying, but if your ID field is auto-incremented, then you can't set it or reuse an ID.

    It looks like your delbtn sub is deleting it straight from the database -...
  5. Re: [ACCESS] Open another subform within subform control

    There are many, many different ways... It's hard to follow your details, and what exactly you are trying to get.

    If you just want the subform to display only a record that matches a selected...
  6. MsOf13 Re: How do I clear out the "Tap icon" message when I set a placeholder image

    There's probably a method of a control you have to set to change the message - I don't mess with powerpoint much, so you'll have to look it up... Perhaps something like:
    ...
  7. Re: Office 2003 - Access - VBA written report isn't moving control properly

    That is odd. I don't have Office 2003 anymore, I'm running 2010 and 2013, so I can't exactly compare them.

    I would check to see if there are any properties that are preventing it from being...
  8. Re: Office 2003 - Access - VBA written report isn't moving control properly

    That is not really telling me us much. Without providing us with all the pertinent code, and information, such as what those values are supposed to be vs. what they are, I don't know what to tell...
  9. Re: Office 2003 - Access - VBA written report isn't moving control properly

    The first question would be: what is 'tmpLeft' set to?
    A powerful, and useful tool in vba, is to use the 'Immediate Window' (which you can find under view), and use debug.print to print values of...
  10. VS 2013 Re: Windows applications to control camera using switches

    Ok, Thanks.

    I was just curious because I just started getting into Arduinos: http://www.arduino.cc/
  11. VS 2013 Re: Windows applications to control camera using switches

    I'm just curious, but how are you getting the computer to recognize the switch states?
  12. Replies
    1
    Views
    1,070

    MsOf10 Re: Data Binding confusion

    You don't have to have the data bound directly to the form as you describe - most of the time with Access I prefer not to.

    You can update that specific field, on the databound form directly, and...
  13. MsOf10 Re: Excel VBA - conditional copy and paste unique cells across tab

    What issue(s) are you having?
    What is in the cells that you are trying to copy - are they formulas?
    What do you mean by copy them but not duplicate them?

    The one thing I seen off the bat is that...
  14. MsOf10 Re: Access Force two text boxes to always equal 100 percent

    You can do it in the textbox's events (you'll have to do it for both textboxes where you enter "GroupA's number" and "GroupB's number")
    Assuming GroupA's txtbox is named textbox1, and GroupB's is...
  15. Replies
    1
    Views
    865

    Re: Data Entry Form Issue

    One of the issues in Access with dealing with forms that are directly bound to tables, is that any change you make in any of the fields on your form updates the table, wheither you tell it to save it...
  16. Re: What is "Object Required" when trying to create a folder

    You probably don't have the references set to use the Directory functions/methods - I can't remember which reference you need for it, but you can do the same thing with functions/methods within the...
  17. Re: Access : Update field in table for a selected item

    I prefer doing it in VBA - you have more control over various things...

    Here is a code that queries a "Training Dates" table, and returns records that match "TestDate" with the selection in a...
  18. Re: MS Access 2010 Code to Set Object to Excel Workbook

    You can try something like this:


    Dim wb As New Excel.Workbook
    Set wb = Excel.Workbooks.Open(rs1!WorksheetName)


    This is assuming that the FIELD 'WorksheetName' contains a valid path...
  19. Re: MS Access 2010 Code to Set Object to Excel Workbook

    The first thing I would recommend, check your references (everytime I switch Windows versions and Office versions it always gives me issues):
    Goto the VBA IDE, click on tools, and reference. You...
  20. Re: [Excel 2010] Automation Project Problem

    That's how you learn my friend :)

    It looks like 3Com has put a lot of time into this for you...

    Most of us on here are here to guide individuals to help them learn, not do it for them, but you...
  21. Re: [Excel 2010] Automation Project Problem

    What's with the last couple of statements at the end of your first sub?


    Call MySendKeys("{F2}")
    Call MySendKeys("~")
    DoEvents
    'VBA.SendKeys "~"


    You are calling a...
  22. Re: [Excel 2010] Automation Project Problem

    Another thing I noticed, you don't need to select the cells to write to them, it takes up more time...


    Your first sub needs to be re-written:


    Sub HandleBlueGreenFormulas(ByVal bcol As...
  23. Re: [Excel 2010] Automation Project Problem

    http://stackoverflow.com/questions/12391786/effect-of-screen-updating
  24. Re: [Excel 2010] Automation Project Problem

    The application.screenupdating should not have any effect on your code - The only thing it does is saves processor resourses by stopping the Excel Window from constantlly updating while your code is...
  25. Re: [Excel 2010] Automation Project Problem

    Good call - This is a very large post, and it's hard to keep up with everything.


    dcebb2001,
    It would be very beneficial to post ALL of your current code so that we may see if there is anything...
  26. Re: [Excel 2010] Automation Project Problem

    No, it does not change anything... All it does is prevent it from graphically updating the Excel Window.
  27. Re: [Excel 2010] Automation Project Problem

    No.

    You set it to false in the beginning so it stops updating.

    Then you run your code.

    Then you set it back to true so you can see the changes - It is very important that you return it to...
  28. Re: [Excel 2010] Automation Project Problem

    Here is a link to the MSDN site about it:
    http://msdn.microsoft.com/en-us/library/office/bb221605(v=office.12).aspx
  29. Re: [Excel 2010] Automation Project Problem

    It keeps it from updating the Excel window every time a value changes - it saves your computer from having to process that information every time, thereby speeding up the entire process.
  30. Replies
    6
    Views
    1,006

    Re: How to make part of textbox uppercase...VBA

    Never mind - I should have read the whole problem.
  31. Re: [Excel 2010] Automation Project Problem

    It would be faster if you turned off the screen updating - In your code, Excel will process each cell through your loop, and everytime it changes it will process the change, and update it in the...
  32. Replies
    1
    Views
    1,412

    VS 2008 Re: Get PDF Zoom Value

    This probably isn't what you want to hear, but since your screen shot shows that you are opening a file in Adobe Reader, you may want to check out Adobe's Developer website:...
  33. Re: Creating daily Log file - need nudge in right direction

    Lol, glad to be of assistance!
  34. Re: (VB.NET Addin)Change all data types in range to string

    The information you provided is not very clear - Don't know really what you are doing.
    It would be beneficial for you to clarify exactly what you are trying to do, provide the code that you are...
  35. Re: Creating daily Log file - need nudge in right direction

    You might want to check out the MSDN How Do I video series. This is the link to the VB videos:
    http://msdn.microsoft.com/en-us/vstudio/bb466226.aspx

    Scroll down about 3/4 of the way down, and...
  36. Replies
    1
    Views
    714

    VS 2010 - Working with Excel Data

    Hello,

    I am looking for an faster method to import excel data into a datatable.

    My problem is that we have an old set of spreadsheets that are being used as forms for data entry, and have many...
  37. Replies
    2
    Views
    857

    VS 2012 Re: Combobox - Multidimential Array

    That was simple enough.

    Thanks .paul!
  38. Replies
    2
    Views
    857

    VS 2012 [RESOLVED] Combobox - Multidimential Array

    Hello,

    I am working on an aspect of a program to import data from an excel spreadsheet. The primary issue is that the data from the spreadsheet will be coming from different people, and has the...
  39. Re: Querying Access database while converting data

    If all of your data follows the same scheme, then yes, it would'nt be too hard.
  40. Replies
    1
    Views
    1,170

    MsOf07 Re: Need Access Form design help

    Is the meetingattendees a queried combobox where you joined first/last name (makes it more complicated and will determine how you can solve your issue).

    What I would do is add "Guest" to the...
Results 1 to 40 of 458
Page 1 of 12 1 2 3 4



Click Here to Expand Forum to Full Width