Search results

  1. W

    Auto Outlook Export

    I found the following code below: Im using outlook 2003, i wish to export all content of an email and properties just like the outlook export action. My email accounts are either POP or IMAP. How can I amend the following code to do the job?! Sub Command0_Click() Set nms =...
  2. W

    Transfering emails to Access database

    Im using a POP connection - that anything to do with the problem ?
  3. W

    Transfering emails to Access database

    Hi, I have tried running this code to see if I can something similar working. I get the following error message: "method or data member not found" (on the first line) Set nms = Application.GetNamespace("MAPI") strFolder = "inbox" what does this mean?
  4. W

    Auto Outlook Export

    Ps. I dont want to link the tables... Unless I can somehow program a form so that a user can create the link using a form/buttons etc.
  5. W

    Auto Outlook Export

    Hi access experts I would like to automate the following function available in Outlook using a button on an access form: - User specifies folder and press button to: - Export emails to Access table - I would like to maintain the default map - Create a new table Please help - Im way behind on...
  6. W

    Get Data from Email Body (Outlook express)

    No reply Iv had no replys... anyone suggest another forum or info source? thanks
  7. W

    Get Data from Email Body (Outlook express)

    Dear All I have expereince in VBA Excel. I also run an estate agents, I am stuck in a loop of inputting lots of data manually to my spreadsheet from client emails. I recieve automated emails (fixed template) from verious website portals containing client details. We are talking about...
  8. W

    Access - Freeze - Crash

    Hi I have a number of forms which the user can navigate through. On leaving a form some code is executed. My prblm: sometimes the application will freeze and not allow any control. I have to ctrl-alt-del. I have not used the echo command - could it be to do with setting focus to an object...
  9. W

    List Box - Fix columns when scrolling

    HI I have a list box which sometimes needs extensive scrolling to the right to see other data. Im wondering whether I can freeze the first few columns (key info) so I can trace the other data when scrolling. (i.e. like in an Excel spreadsheet) any suggestions please or code tricks?
  10. W

    List Box - Freeze Columns When Scrolling

    HI I have a list box which sometimes needs extensive scrolling to the right to see other data. Im wondering whether I can freeze the first few columns (key info) so I can trace the other data when scrolling. (i.e. like in an Excel spreadsheet) I dont mind what coding if I have to - any...
  11. W

    Speed - changing between forms

    just for the record... setting the forms visible property to false instead of closing enabled me to hide the form very quickly and bypass the time consuming 'calculating......' forms![name].visible = false
  12. W

    Speed - changing between forms

    Hi I have a form with two graphs, when i close this form to open another the speed is very slow. the form displays the action 'calculating....' i believe its because of the graph - the only object with data attached. The graphs rowsource is updated using vb. The rowsource is intially set to a...
  13. W

    EPOS / Stock Control System

    we have drawn up a spec for our system which we will develop according to our clients requirements. We are after some working examples to get more ideas.
  14. W

    EPOS / Stock Control System

    Hi Has anyone got a usable or demo version of an off-line EPOS and stock control system. Its for an academic project - i need some ideas. It would ideally be used for a small shop selling a number of products. Transactions can be calculated and stored, purchase orders stored etc. Ive...
  15. W

    Access 2003 Developer Extensions

    Visual studio tools for MS Office: is a collection of software add-ons for Visual.Net and Access. You dont need to have Visual.Net to install the Access Developer extentions (setup wizard, package & deployment wizard etc). This will simply run on Office Access 2003. The package also includes...
  16. W

    Launch Word.Doc using eg.Code

    Hi I have been using the following code to open an Excel file. I wish to open a Word document - can i siply adjust this code? Ive tried but no luck... rgrds Set oapp = CreateObject("Excel.Application") oapp.visible = true Set wb = oapp.Workbooks.Open("C:\imports\testfile.xls") set ws =...
  17. W

    Hide default menu bars

    where and how would i use this ??
  18. W

    Hide default menu bars

    Hi I have set some start-up properties for my access application. I am trying to eliminate ALL access tools bars.. my application runs in a run-time environment - do i need to create extra vb code to remove the default tool bar: (Menu Bar) ?? regrds
  19. W

    Deployment Wizard Help Required

    Hi I am using the deployment wizard to package the Access application in a run-time version. I worked through a test-run of the wizard and installed the application on another machine. I noticed that when the user selectes the access help buttons on the packaged application - no help...
  20. W

    Find Record (first Few Characters Of Key Word)

    Hi I have developed a form - with a text box for the user to input a character string.. e.g. "productZ" or "038482" I am hoping to requery a list of records using the user search criteria.. Because the user will not always enter the exact character string - im thinking of basing the...
Top Bottom