Search results

  1. 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:
  2. 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
  3. 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
  4. 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...
  5. 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...
  6. 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!
  7. 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