Search results

  1. B

    DLookup as ControlSource through VBA code

    yeah its a good feeling to get it to work...!
  2. B

    DLookup as ControlSource through VBA code

    This worked! "=DLookUp(""Sku"",""OrderTable"",""ItemNumber='"" & "Forms![OrderForm]![ItemNumber]" & ""'"")"
  3. B

    DLookup as ControlSource through VBA code

    Ok I tried your code and got this as the control source: =DLookUp("[Sku]","OrderTable", "ItemNumber = "" & Forms![OrderForm]![ItemNumber] & """)
  4. B

    DLookup as ControlSource through VBA code

    The issue is that it is the control source for a field in a datasheet. When I set the control source manually =DLookUp("[Sku]","OrderTable", "ItemNumber = '" & Forms![OrderForm]![ItemNumber] & "') it works, but if I set it through VBA it doesn't do it on an itemNumber per ItemNumber basis.
  5. B

    DLookup as ControlSource through VBA code

    Below is my code: I run the above code and the control source is now: How do I change my code so I see the below in my control source:
  6. B

    Open webpage within Form

    I ended up using the Microsoft Internet Browser Active X control. I did something like: Me.WebBrowser0.Navigate "google.com" Thanks!
  7. B

    Open webpage within Form

    How do I open a webpage i.e. google.com within a form? I found articles on openning a webpage but not within a form. Thanks! bruno
  8. B

    VBA show Windows Logged On User's Email Address

    I have a MS Access 2003 application where I need the current Windows logged on user's exchange email address. Do I need to query Active Directory to do this or is there a simpler way? We have different domains in our organization and querying AD would be cumbersome. Thanks, Bruno
  9. B

    How to not allow text to number conversion?

    When I export my MS Access 2003 Report to excel, using the Analyze with Excel, the UPC text column i.e. 0023456789 00 88 converts to a number field and has the zeros truncated and some are even in scientific notation. How do I retain the text format and not allow for the number conversion...
  10. B

    Question Access 2003 with Linked Tables does not work on Dell e6420

    I have MS Access 2003 installed on a Dell e6420 Windows 7 32bit. When I open my mdb file with linked tables, MS Access shows not responding for about ten minutes then shows my forms, if I click on the anything on the form, it takes about a minute. There is nothing wrong with the mdb file as I...
  11. B

    Does Access 2010 still have the Memo truncation issue?

    Thanks Bob. So I guess I'll let my boss know that it doesn't make a difference if it's Access 2003 or Access 2010?
  12. B

    Does Access 2010 still have the Memo truncation issue?

    Sorry.... here is a better explanation: In Access 2003 when a user click analyze with excel on a report, the 280th row has a field that is over 255 characters and all the other fields before that is less than 255. The problem is that Access 2003 uses the first 25 column to guess the data type...
  13. B

    Does Access 2010 still have the Memo truncation issue?

    Does Access 2010 still have the Memo truncation issue: By default, Access scans the first 25 rows to guess the data type of the column. Thanks!
  14. B

    DLookup within DLookup not working

    Hi this is working: =IIf(Forms!GARF!GARFsubForm![finished_good_#]<>"", DLookUp("[CustomerSKU]","ItemCustomerSKU", "ItemNumber = '" & Forms!GARF!GARFsubForm![finished_good_#] & "' AND Customer = '" & Forms!GARF![customer] & "' AND Company = '" & Forms!GARF![company] & "' AND MarketingSeason = '"...
Back
Top Bottom