Search results

Hey All I have a form that allows you to search for records and displays all the information for that project, typical stuff. On this form is a subform with the followings Fields: Inpection Requested, Inspection Due, Inspection Done, Overdue When you update inspection requested the inspection...

I didn't even think of using a report, yikes. Thanks for the reminder on that one, if I get stuck I'll be back

hey guys, I have a searchable form that display information on agreements other companies have with us. If a company requests an inspection we have 30 days to go out and complete it. I am trying to create a message box that will display all inspections that are due within 5 days when the form...

Thank you for clarifying just how little I know about access, very helpful and motivating.

Well the hyperlink paths are very long and bothersome to look at, the display texts I wish to have are agreement numbers for construction. It is more efficient for our inspectors to see the agreement number in the table straight up rather than looking to the end of the path to see which...

Sorry I feel bothersome but every hyperlink has a different PathString. I don't know what to type for each record to retain its respective path.

I dont know how I would set that up in the "Update to" section :S

Hey all, So I have a table with 2 fields. The first field has the addresses to multiple hyperlink paths to folders on my computer. In this field the display text matches the hyperlink paths. In the second field I have the desired display text for field 1. I have tried using an update query to...

I tried an update query and I set Field1 to be updated to Field2 and when I do that it changes the name like I desire but then it also removes the address path and leaves me with a blue underlined name with no path. Any help??

I'm pretty new to access, I didn't know that existed. I'll give that a Googlin', thanks.

Hello everyone, I have a table with 2 fields. One field is hundreds of hyperlink paths to folders on my computer. These hyperlinks all have their "Texts to Display:" the same as the path to the folder. In my second field I have the desired "Texts to Display:" for Field 1. As far as I know you...

Okay so I have this code below and it opens up to the location of all the E12.## agreements. I also have a table in my database with a list of all these agreement numbers. I am unsure of how to make the code link with the table in the database and pair up the E12.## agreements with the table...

VBA is very foreign to me and I've spent the last little bit reading up on FSO but it's all pretty confusing to me. Is there any insight you can provide? Thanks

Hello all I am using Access 2010 and I am fairly new to it (started using it for work). I have a table with a bunch of a agreement numbers (134) and I need to link each one to its folder on our company's shared G drive. The agreement numbers all follow the format A12.## (Where ## is the number...