Recent content by dbDamo

Thats not the greatest/cleanest code but if you want to go ahead with it you should at least SetWarnings to True before you end the sub

I agree completely - not worth doing, especially if using Access as a backend because of the 2gb limit.

Thanks very much!

I'm currently using the environment("username") variable but if there is a better/safer way I would definitely be interested in changing it. Galaxiom - I have looked at the thread you provided a link to but cannot see any example? I would be grateful if you could give me the example

To get around this warning message you can install CDO and send directly from your SMTP server bypassing Outlook completely. For more information on this, please see my comment in this thread - http://www.access-programmers.co.uk/forums/showthread.php?p=923411#post923411 To install CDO, go to...

Try adding in:- objApp.Activate

Here is the code behind the 'Add Attachment' button:- Private Sub Command231_Click() 'Add attachments to Change Request On Error GoTo ErrorHandler Dim strFilter As String Dim strInputFileName As String Dim strSQL As String 'Check to see if any more attachments can be added...

Have a look at the sample I have attached to post 4 in this thread - http://www.access-programmers.co.uk/forums/showthread.php?t=197020

You wish to send a standard reply to every email you receive? Do your emails get imported into your Database once a day, at regular intervals or as soon as they are received? Once you answer these questions I am sure that I can help you

In the AfterUpdate event of your Date_Completed control, you could use the following code:- If Not IsNull(Me.Date_Completed) Then Me.Completed = -1 End If However, this does not check for a valid date so I would perform validation on the date too. See this example:- If Not...

Create a form that displays your information in Datasheet view. You can then place some code in the OnClick event of any controls you wish that will then open your continous form and display all information for the selected record by setting the link criteria.

It sounds to me like you are looking for the table relationships in the Front End Database, where all the forms, queries, macros etc are stored. The table relationships should be set in the Back End Database where the actual tables are stored, so I would suggest you look there. If my...

I would use:- Private Sub Form_BeforeUpdate(Cancel As Integer) If Len(Nz(Me.cboTypeofAddress,"")) = 0 Then MsgBox "You must provide data for Type of Address.", _ vbOKOnly, "ETA - Required Field" Me.cboTypeofAddress.SetFocus Cancel = True...

Yes you should definitely do that. Also look into ghudson's suggestion as this is probably what is causing your errors

and each user has their own copy of the front end on their local drive?