Search results

  1. P

    Outlook linked table

    Hi there... Can please someone confirm if a linked table to outlook only updates if outlook is open? Is there a way that the linked table can be refreshed without having to open outlook?
  2. P

    Extract text between certain characters

    Hi there... I have a field that contains the following data: FirstName:Pedro LastName:Campos Restaurant:BI Strand Location:North Month:March I need to extract the data into different fields like this: Field1: Pedro Field2: Campos Field3: BI Strand Field4: North Can someone explain how to...
  3. P

    Run Macro without opening database

    Hi there... I have a back end database with an autoexec macro to import data into one of the tables. How can I have the autoexec macro running wihtout having to open the back end database?
  4. P

    Nortwind Traders

    Hi there... I have used the Northwind Traders Database as a template for my own Database. I have a problem where some of the MsgBoxes called in some functions have "Nortwind Traders" on the title. Does anyone knows where the Message boxes are kept and how to change the title of these msgboxes?
  5. P

    Access 2010 does not open in shared mode

    I have a database originally created with Access 2007, but now that we've upgraded to Access 2010 the database does not open in shared mode and everytime i try to open it gives an message saying that i do not have exclusive rights. The database is in a shared network drive used by about 5...
  6. P

    Launch Query Builder from a Command Button

    Hi there... I am proabbly missing something very simple but I would like to put in my form a button that when clicked will launch the query builder wizard so that the end user can build their own queries? part two: I would like the above to be done but not allow the end user to save their...
  7. P

    Search Function Clearing all objects from my form

    Hi there... I've successfuly created a form which includes a search box. However when a user search for an item that is not in the data, all the objects on the form disappear and I have to close the form to start again.
  8. P

    Question Sum Fields in 2 different tables

    I have a 2 tables, one for parts received "tbl_received" and one for parts sent out "tbl_sent". On both tables i have the same product and i want to display on a form the difference between the 2 so that i know how many parts i have left: table= tbl_received field= part_received field data=10...
Back
Top Bottom