Search results for query: *

I have written a database that creates a photo directory of people for our church. Right now each record points to a photo that is kept in the same folder as the .mdb file. This folder gets passed on from person to person as time goes on. Instead of having to make them use a set file path, I...

You guys are all great. Thank you so much for your help. Thanks to Junior1544 for helping me out of this mess.

Good thinking, but I did try that. I set the size of the field to the maximum 255 characters. I would really appreciate you taking a look. Thank you!

I have had many suggestions as to how to make a Browse button work in a form. The only one I could make work is the one from Microsoft's resource web site. But, I keep getting an error once I choose the file and push OK. It says that I don't have enough room in the field for the info I'm trying...

OK, it is working! BUT, it only lets the user select folders, it doesn't show what files are in the folder or let them choose an exact file. Can you help me do this? They will need to select an image file.

OK, I do all that and it gives me an error that says Ambiguous Name Detected: BrowseFolder and it highlights the words BrowseFolder.

OK, I gotchya now. Although, when I put the code in there, it gives me a compile error and highlights the .lblApt# as not found? Then it highlights the top line in yellow and puts an arrow by it. The top line was automatically written as: Private Sub Report_Page()

OK, under EVENT in the Properties of the report, I don't have an On Format option. I have On Open, On Close, On Activate, On Deactivate, On No Data, On Page and On Error. Would I put the code on one of these? Thanks again.

You rock. Thank you. OK, how about one more...can you make text visibility conditional on if a field is null? Example: Have the text "Apt. #" appear befor the Apt# field ONLY if it is not null? :D Thanks!

I need to know if it is possible to make text appear on a report right next to each other. I want it to go like this: LastName, FirstName. I have to make the LastName box big for the big names but don't want the huge space between names on all the others. Can you help? Thanks.

Thank you! That worked. I didn't realize it was that easy. Do you happen to know if it is possible to make the text in a report sizeable? I am trying to put LastName, FirstName, but I have to make the LastName text box big for the big last names and I would like the FirstName to come right after...

I need details on how to create a BROWSE button that will allow a user to choose a file and then it will put the filepath in the field for them. Thanks!

I am trying to make a directory of pictures and names and would like to lay out the report in a grid pattern so there would be 3 records across and 5 down. All reports I have done only allowed 1 record per line. Does anyone have any ideas on this? Thanks for your help.

This was increadibly helpful! Thank you! Others had tried to explain this but their instructions weren't quite as detailed. Now all I need is to make a BROWSE button in the form that will put the filepath in for them. Do you have an explanation for this? Thank you again!

I am trying to create a simple database to serve as a directory for a group of people. Basically, I just want to print the reports and hand them out periodically to each member of this group. I need to have their pictures show up on the report next to their name, but have never known Access to...

I am trying to create a simple database to serve as a directory for a group of people. Basically, I just want to print the reports and hand them out periodically to each member of this group. I need to have their pictures show up on the report next to their name, but have never known Access to...