Recent content by pcampos

  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

    I have tried that but it cannot find those terms... I also looked for the respective msgbox but al it has is a reference to the respective msgbox and a number. here is an example of a reference to a msgbox but not to the actual msgbox Option Compare Database Option Explicit Public eh As New...
  5. 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?
  6. 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...
  7. 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...
  8. P

    Search Function Clearing all objects from my form

    Thank you very much... that has worked very well as well.
  9. P

    Search Function Clearing all objects from my form

    Wow... that has worked. It was the very first reason, i had AllowAdditions for the form set to No, I changed to yes and now it works. I have however a new question... On the same form I also have a GoTo Next record button but when i am on the last record if I keep pressing the button it throws...
  10. 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.
  11. P

    Question Sum Fields in 2 different tables

    All Problem resolved... I didn't realize that i strated the same thread in what i though were different forums
  12. 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