4 bits of help please

[quinnb]

Hi i am designing a database for reminders - a car has a service - 11 months later a reminder letter/email/text gets sent to the customer
Q1 - i have had to use two lines for the address though in 99/100 one line would do so when i create a report for the letter there is a big gap in the address - how do i get rid of this gap whist keeping the field in the report

Q2 - i have a prefernce control group - so 4 options email, letter, text, all 3. How do i based on this grey out cells i dont need - i,e select email address field greyed out etc

Q3 How can this be automated so every day say at 11am the database automatically sends the letters to the printer, email, text etc etc what i would like it to do is print the letters then save 2 CSVs one for mail chimp and one for the texts,

Q4 if i specify in my control that email is preference then the cell is un-greyed see above - how can i then make sure an email is entered, same for address etc



Q5 When entering the date of the service it isnt greater than today?
Thanks Brian

[June7]

Q1 - expression in textbox to concatenate two fields with Chr(13) and Chr(10) to force carriage return. Use IIf() function and or + character for concatenation, example:

=[Field1] & Chr(13) + Chr(10) + [Field1]

Q2 - don't understand, grey out field where? A textbox on form?

Q3 - a VBScript file can be called by Windows Task Manager. The script file can run procedure in Access db, review https://stackoverflow.com/questions/...ernal-vbscript

Q4 - use VBA code to validate entries, use If Then Else structure

Q5 - can use Validation Rule property or again, VBA code

[quinnb]

thanks for this but can you make it more specific please?
Q1 - My fields are ADD1 and ADD2 - where exactly do i enter the code - and whAT is the exact criteria pls
Q2 - greyed out should read cell disabed/enabled based on the criteria from my options group
Q4 sorry what is the code? / validation text and Q5

[June7]

Q1 - I said expression in textbox and then I provided an example without criteria, try it: =[Field1] & Chr(13) + Chr(10) + [Field1]

Q2 - explore Conditional Formatting of textbox and combobox https://support.office.com/en-us/art...5-44E43B05E22F

Q4 - this could get a bit complicated and more than one way to structure the code which depends on what you want to happen, something like:

Sub someButton_Click()
Dim strMsg As String
Select Case Opt1
    Case 1
        If IsNull(Me.Field1) Then
            strMsg = "Email"
        Else
            'code to send email
        End If
    Case 2
        If IsNull(Me.Field2) Then
            strMsg = "Address"
        Else
            'code to print letter
        End If
    Case 3
        If IsNull(Me.Field3) Then
            strMsg = "Phone"
        Else
            'code to do something else
        End If
End Select
If strMsg <> "" Then
    MsgBox "Enter " & strMsg
End If

modify as appropriate for your situation

Q5 - Validation Rule property like: <= Date() Or Is Null

[quinnb]

#Type! is what is displaying on the report? have entered =[add1] & Chr(13) + Chr(10) + [add2] on to ADD1 text box control?

[June7]

What is name of the textbox? If it is ADD1 then this is same name as field add1 and causes circular reference error. Rename the textbox to something like tbxAdd.

[quinnb]

What is name of the textbox? If it is ADD1 then this is same name as field add1 and causes circular reference error. Rename the textbox to something like tbxAdd.

Ok i have done this and all it does is put the first line of the address on both fields - so 123 somewhere street appears add1 which it should but also line two as well

[June7]

Don't understand. Show sample data.