Recent content by jgneely

I'm sorry, I had a missing parenthesis. It works now. Thanks a bunch :)

I got this: #Name? What happened and what is that?

I'm still in the dark. I found this example and tried using it and it is doing part of what I want it to do. Here it is: =IIf(IsNull(lastname])" ",[firstname]&" "&[lastname]&", "&[CompanyName]) This is what I get: Jane Doe, XYZ, Company. What I want is to show first and last name only if...

I'm sorry, but your solution is greek to me. How should I set up the IIF function to both concatenoate the first and last name fields and if they are null, to then use the organization field in this unbound field?

I am just a beginner in Access, so please be patient with me. Can anyone help with this situation? I've created a simple address database. I put a text field onto my form that will concatenate the first and last names of the contact for each record so that it is noticeable to all that are...

Can anyone tell me what went wrong. Just to warn you, I know nothing about Visual Basics. I was creating a simple table in design view. Then I decided to create a simple autoform and I received this message: "ActiveX component can't create object". I've never ever received this message and I...

Hay, Thanks! I never knew what that was for. I had the hardest time looking my question up in the Help menu. Again, I say Thanks!

Hi. My question is: Is there anyway to print the table properties in design view other than doing a print screen? This is probably a dumb question, but I would love to know how to do this if it is possible.