Recent content by brianborn

Thank you Bob as this is exactly what I needed. I'm learning more every day.

I have a field in a table that represents a bin location for inventory items. Within this string of characters are 2 digits that represent a product code. The product code will group similar products like screws, paint, aluminum, etc. I would like to create a parameter query to be able to enter...

Thank you so much Bob. This was a field that I recently added to my table and I did not add it to the Record Source Query. Once I did that, everything works perfectly. Your are awesome!!!

This worked in that I do not get the same errors as before, but it does not include ContactAddress2. I modified your code as follows and get an error with "Enter Parameter Value" for "ContactAddress2". With you doing the hardest part, it seems like it would be simple to copy/paste to add another...

I moved and tried it in both header sections and the detail section. I still get the same dialog messages. Also I decided to delete the textbox and add a new one, that did not work either.

I cannot upload the DB because of the data inside. Although I'm a student trying to learn, this is a database I created for work and it has confidential data in it. I can attach an image. http://screencast.com/t/RhsrxXEZdv

If this makes a difference and the reason that the code doesn't work, I really do apologize. I've been working on a lot of different parts of my database and made a mistake of typing form instead of report. You put way more effort into providing code than I thought it would take and I feel real...

Thanks for all your effort Bob! This was really more than I expected and I almost feel like I should pay you for the time. I copied the code and pasted it into a new module, added the code to the field's control source and when I switched to Report View, a dialog box opened with the title of...

If not too much trouble, can you help with the following code? This is the code I have on another form. =Trim([ContactName] & ", " & [ContactAddress] & ", " & [ContactCity] & ", " & [ContactState] & " " & [ContactZip] & ", " & [ContactPhone])I tried both... =Trim([ContactName] & ", " &...

Thank you! This works perfectly! I really do appreciate you helping me out with this issue. Have a wonderful day! Brian

Thanks Bob! I tried you code and received the following error. "You must enclose IIf function arguments in parentheses." I tried adding parentheses in places that seemed logical to me, but without success. Does this error make sense to you?

I'm having a little trouble knowing what to search for to find an answer, so I'm hoping someone here will be able to help. For a novice like myself, it is difficult, but for the experienced, this should be a piece of cake. On a report I have the following code to concatenate two fields...

Having the database working the way I want is more important than making sure it will work on the web. At least at this point it is. I followed the directions on the link you shared and it works great! Thank you!

I now have a blank form with 2 subforms, but I'm not sure what exactly I need to do to set the filter. I've made it far learning Access with the basics which includes tables, queries, forms, and reports, but really just venturing out with macros and VBA. Some additional details that might make...

Thank you for the information. It's been a busy day here at work and this might have to wait until tomorrow morning to try it out. I like the option of having the + sign as it appears on the table to be able to open and collapse the details you want to see, but this form will be used by another...