Replies

Try replacing ISBLANK(Ref) with Ref = “”
=IF(AND((AC3=””),(W3=””)),”88/88/8888″,(IF(NOT(AC3=””),AC3,(VLOOKUP(G3,’SA Info’!$A$1:$J$991,10,FALSE)))))

That worked! Thanks!

Jodi

The “Wizard” doesn’t let you select an unbound control as master field, but you can set it manually – just enter the name of the combo box in the Link Master Fields property.

Thanks so much! I knew it had to be something easy like that. That worked perfectly.

Jodi

We have an application form for our students to join our program. Currently it is in paper form. We would like to allow them to fill it out electronically. I was looking for a way that it could be submitted by the user and be emailed back to us in a way that would make it look like the paper form, only with the fields filled in. I thought maybe Word might be my answer. In the past, when I have put an online form up, I can get the information via email, but it is just the field input in a column. I wanted to make it look like it would if they filled it out on paper so that my secretary doesn’t have to write in their emailed answers. Hope this makes sense.

Jodi

(Edited by HansV to make URL clickable – see Help 19)

It worked when I changed it to this:

=IIf([Textbook]=No,Null,”TextBook”) & IIf([ClassNotes]=No,Null,”Notes” & Chr(13)+Chr(10)) & IIf([Calculator]=No,Null,”Calculator” & Chr(13)+Chr(10)) & IIf([NoteCard]=No,Null,”3×5 card” & Chr(13)+Chr(10)) & IIf(IsNull([Other]),Null,[Other] & Chr(13)+Chr(10))

I moved the Chr(13)+Chr(10) to the end right behind the falsepart so that it only adds the line if the statement is false. I got this idea from another message you posted which linked to an article at http://support.microsoft.com/?kbid=287685%5B/url%5D.

Thanks for solving another problem! You rock!

Jodi

Thank you so much. Your example was extremely helpful and I was able to do what I wanted.

Hans!!! You are my hero!

I was having the exact same problem, found this post, tried it and it worked beautifully!!!! I just thought you should know that someone was shouting “I love you, Hans!” to their monitor.

Have an awesome day!

Thank you so much!

This worked perfectly!

You are such a gem, Hans!

Jodi

Thanks for taking the time to help me with this. It looks great now!

I absolutely love this macro and use it all the time. However, I would love to add a line to it and have been trying all day but can’t figure it out. Is there a way to to add a line so that before each slide, it prints “Slide 1”, “Slide 2”, etc.? I know it has something to do with “Slide ” & sld.slidenumber or insertslidenumber but not sure where and how to add it into the macro. Would appreciate any assistance.

Jodi

This is exactly what I need, however, I’m getting an error and hope you can help. Here is the code I put:

Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim strSQL As String
Dim strValue As String
Set db = CurrentDb
strSQL = “Select * From Needs Assessment Where Needs Assessment.SID=” & Forms!frmperminfo!txtSIDHidden
Set rst = db.OpenRecordset(strSQL, dbOpenDynaset)
If rst.RecordCount = 0 Then
DoCmd.OpenForm “Needs Assessment”
DoCmd.GoToRecord acDataForm, “Needs Assessment”, acNewRec
Forms!Needs_Assessment!Grammar.SetFocus
Forms!Needs_Assessment!First_Name = Forms!frmperminfo!txtFirstName
Forms!Needs_Assessment!Last_Name = Forms!frmperminfo!txtLastName
Forms!Needs_Assessment!SID = Forms!frmperminfo!txtSID
Else
strValue = Forms!frmperminfo!txtSID
DoCmd.OpenForm “Needs Assessment”, acViewNormal, “SID =” & strValue
End If
End Sub

When I click on Command 155, I get an error that says Syntax Error (missing operator) in query expression ‘Needs Assessment.SID = 999999999’. Then it asks me to debug and it highlights the line that starts with Set rst =. BTW 999999999 is the correct SSN coming up. I’m wondering if it’s getting confused because my table and form are named the same thing. Do I need to put something after From to let it know that Needs Assessment is a table? I appreciate your help. I only know enough about VB to get myself in trouble.

Jodi

This is exactly what I need, however, I’m getting an error and hope you can help. Here is the code I put:

Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim strSQL As String
Dim strValue As String
Set db = CurrentDb
strSQL = “Select * From Needs Assessment Where Needs Assessment.SID=” & Forms!frmperminfo!txtSIDHidden
Set rst = db.OpenRecordset(strSQL, dbOpenDynaset)
If rst.RecordCount = 0 Then
DoCmd.OpenForm “Needs Assessment”
DoCmd.GoToRecord acDataForm, “Needs Assessment”, acNewRec
Forms!Needs_Assessment!Grammar.SetFocus
Forms!Needs_Assessment!First_Name = Forms!frmperminfo!txtFirstName
Forms!Needs_Assessment!Last_Name = Forms!frmperminfo!txtLastName
Forms!Needs_Assessment!SID = Forms!frmperminfo!txtSID
Else
strValue = Forms!frmperminfo!txtSID
DoCmd.OpenForm “Needs Assessment”, acViewNormal, “SID =” & strValue
End If
End Sub

When I click on Command 155, I get an error that says Syntax Error (missing operator) in query expression ‘Needs Assessment.SID = 999999999’. Then it asks me to debug and it highlights the line that starts with Set rst =. BTW 999999999 is the correct SSN coming up. I’m wondering if it’s getting confused because my table and form are named the same thing. Do I need to put something after From to let it know that Needs Assessment is a table? I appreciate your help. I only know enough about VB to get myself in trouble.

Jodi

Yes, I tried detect and repair and that didn’t work. No, I’m not using a parameter query.

Term is the semester in which the student had the appointment. I need to be able to select which term I want.

Thank you so much. That was it exactly!

Thanks so much! That did it!

Jodi