Search results for query: *

Hi I need some help with an Exchange restore problem. I tried restoring Exchange Server from a back-up copy taken a few days back. I thought I had successfully done the restore until I tried mounting the Mailbox Store. Got several messages the main one being,c1041724. "An internal error has...

I have recently installed SBS 2003 and have deployed Outlook 2003 to the workstations that are running XP Pro. For 2 users, within Outlook 2003 on their PC’s they have access to their Mailbox plus the other persons. I have granted permissions to the various folders so that each person can read...

I have a couple of questions about contacts in Outlook 2003. I have recently installed SBS 2003 and have deployed Outlook 2003 to workstaions that are running XP Pro. The questions are, 1) I imported the old contacts into the system created public contacts folder(via a Mailbox Contacts folder)...

I want to create a Query using an SQL staement that can be run with VB. I am use to Oracle SQL where can you can write a SQL statement such as Create or Replace View as ... SELECT Statement. I Cannot find the equivalent within Access. Is this possible please? Thanks

Hi, dont know if anyone can help. I have had exchange server running on windows 2000 server at a clients site for about 2+ months now, with sending and receiving working OK at every hour and modem automatically disconnecting after 1 mins idle time. Over the last 3/4 weeks the modem is not...

Hi Guys I need some help.I posted this in another forum and received no replies, so thought I would try this one. I want to update Contact information in Microsoft Outlook 2002 from an Access Contact table that I have. I was originally thinking of writing code to export the relevant data to a...

Hi Guys I need some help. I want to update Contact information in Microsoft Outlook 2002 from an Access Contact table that I have. I was originally thinking of writing code to export the relevant data to a CSV file and then import into Outlook that way. I then came across the Linked table...

Has anyone had a problem with Shared FAx Service running on Windows 2000 Server with Exchange 2000 getting errors of "The Shared FAx Service failed to receive a fax" Event ID 32091 or 32034.When I look at the InBoxLog.txt, it suggests a "Reception error", which to me sounds...

Hi I need some help with a query. I have got 2 tables VACANCY and VACANCY_LOCATIONS linked as VACANCY.[vac:vacancy_id] to VACANCY_LOCATIONS.[vacloc:vacancy_id] There is a one to many relationship between the tables, ie for each record in VACANCY there could be multiple rows in...

Hi I am trying to use SUBSTRING in a query but every time I try to go to the Datasheet view I get "Undefined Function 'SUBSTRING' in expression. see below as an example, select CLIENT.[cl:client_id] ,substring((CLIENT.[cl:client]),1,20) from CLIENT I am using Access 2002. Having used SQL...

I have got a main form with a subform that is set to Continuous. What I want to do is hide certain fields depeneding upon values within the current record. Therefore if viewing the Subform and there are 4 reocrds the individual rows should display different fields. I have tried several ways but...

I am having a problem with a hyperlink type field when running a Union query. I have a field defined in my CLIENT_CONTACTS Table as a Hyperlink Data Type, which is being used for Email addresses. If I run either of the unionised SELECTS individually, which has this field included, I get the...

Hi a simple question. I am mail merging in Word (2002) using Access (2002) as the data source. I am using a query as the source. I have 2 problems, 1) The date format in Access is (dd/mm/yyyy) but when the date is brought across to Word it has the format (mm/dd/yyyy). ie 15/10/2002 is...

Hi I asked this question before and got no response. I assume that either the answer is so simple that I should know it or it cant be done. I am relatively new to Access programming and it's nuances so please bear with me. I have created a Search form for a Form/Subform combination to allow the...

I have created a Search form that displays the results of the Search to a results form. (This form is based upon a query). What I want to do is create a field on the Results Form that the user can check to select specific record(s). The Selected records will be processed further. What I cant do...

I have a table MAIL_MERGE which has a numeric field for batch_number. I have created a form for data input, which also has the field batch_number, what I want to do, is when a new record is created in the form, is to default the value for batch_number as the last batch_number (ie Maximum...

Hi I'm new to using Access, so this maybe a silly question. I will be running Mail Merge from Access to Word to send letters to multiple recipients based upon the "clients" table in Access. Is it possible that once Word Mail Merge has completed to automatically either update the...