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?
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...
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?
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...
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?
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...
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...
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...
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.
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...