Recent content by SnaveBelac

I have resolved this issue but have never found any reason for it to occur in the first place. There were some other problems with the server I had just built and after much testing an cursing I discovered a faulty motherboard. This was replaced and the OS was re-installed. After that the...

Thanks for the response. It is happening to all messages at all times. Not a single one has been delivered. The internal mail works correctly, the SMTP server works correctly, the problem lies with the POP3 connector. I will investigate the 3rd party solutions - it is annoying havng to fork...

I have set up SBS2003 and set up the POP3 connector to download external mail from certain mailboxes. The mail is being downloaded sucessfully by the POP3 connector but then does not get delivered and gets put in the "failed mail" folder. An Event Error is logged (id 1061 and/or 1062) saying...

In you exchange system manager open the default recipient policy and add your external domain as a new SMTP address under e-mail addresses policy. Set this as the primary and your users mail will be sent "from" this domain. If you have your users set not to update from policy you will have to...

Glad I could help ;) ---------------------------- SnaveBelac - Adventurer http://www.hostpipe.co.uk

Please post your code, the error and on which line it occurs otherwise we will have no way to sort the problem out. ---------------------------- SnaveBelac - Adventurer http://www.hostpipe.co.uk

If you could provide some details to the link between the back end prcessing and the subform recordset we could do what you require. I am assuming you mean the "record selectors" to the left of the subforms details records. ALternatively you could use a progress bar to show progress, and I...

Same thing happened to me in XP/Access 2000. Never fixed it. Have upgraded to 2003 now - will see if it rears its ugly head . . . . ---------------------------- SnaveBelac - Adventurer http://www.hostpipe.co.uk

If I understand correctly, you want to display data in the subform relevant to the data on the main form. If you link your main and subforms via the master/child fields, the sub form will automatically update in response to the record displayed on the main form. Alternatively you can access...

Once or twice I have seen Access change the variable names in an expression to match that of the textbox name. I have no idea why this occurs and I feel it is unlikely that is whatis happening here but I thought I should mention it. What I am saying is, check your expression to make sure...

Your XRef table should only store the unique IDs (primary keys) of each of the other tables (as well as a PK of its own). Any other data can be retreived from the relevant table as necessary. Presumably your competitoridnum and competitorpartnum are stored in the competitors part table. Your...

You need to specify which form to look for your form variables and your criteria must be in the form of an SQL WHERE clause. Assuming your unique field in your qry is [InvoiceID] Private Sub Form_Current() me![txtDocInv] = DLookup("[InvoicedToDate]", "[qryInvoicedTD]", "[InvoiceID]=" &...

Hi Ryan I would suggest using the "WeekDay" function and a loop to find out if any day between your start and end is a Friday/Saturday/Sunday and then using a time comparison to assess what hours are being used up on those days. Obvioulsy if it is a full day then you know the hours otherwise a...

You need to use Word Automation from Access to open your template and add values based on your Access data to the template. This is typically done using bookmarks or cutom document properties. I have found this code sample to be very useful when I started doing it... (about 2/3 down the page...

This problem still haunts me - anybody have any idea at all ??? Cheers ---------------------------- SnaveBelac - Adventurer http://www.hostpipe.co.uk