Search results

I have a question about hyperlinks. Is there a way that I can create one based off the value in a column on a table? So I have a column in my database, that has the file path to different documents on my network (the document path is for different entries on the table). I am creating a form that...

Hey, thank you for your reply I figured it out right after I posted it. Thank you.

So I created the subform based off the query but I can't seem to get the records to pull up from the table. Basically, I created a form called Systems with a combobox called "System Name" which is pulling it's data from the System Name column on the Systems table. I created a button that is to...

Ok, so let's say that I'm working on tracking updates and advisory messages for applications that run on some systems. I got a table for the system name and I have created three tables for the security updates, the advisory messages and the patches themselves for each system. I have created...

How would I go about option three? would you still have that results form? what if I made a Form and had 3 subforms in it to pull up the information I needed. What kind of relationships would I need to establish for this? Thanks for your help.

Good Morning everyone, I had a question about making a project. I want to create a project that allows users to look up information about the systems we own. I created a table for the Systems and a table for advisory messages and security updates. I have created forms to submit the data into the...

So I got it to work finally! Thank you. I got one more question though, I have a few more tables for like security updates and stuff with the same format as the Advisory_Messages. How can I view this information via the system? Would I need to set up a relationship between the systems table and...

I want to thank you for your help by the way, I know I may be a little slow to understand this but I've stepped outside my comfort zone on this to try and make things a little more efficient in the work place.

ha, just saw the last post. Thanks to the refresh. So if there should never be a ! in the control source or row source, what should it look like then?

So I am getting an error while playing around with it, the combo box states that it is bound to [Advisory_Messages]![System_Name]. I thought that was what I wanted though was to query the information from [Systems]![System_Name] and put the control source (what is to be edited) as...

Ok, so if I want the combo box to pull information from the Systems table, I need to set the Record source of the form to the Systems table and make then bind all the other fields to the fields in the Advisory_Messages table? I mean that would be the only spot where I'm pulling data from. Would...

I set the control source to ADVISORY_MESSAGES![SYSTEM_NAME] and I set the Row source to SYSTEMS![SYSTEM_NAME]. The record source of the form is the ADVISORY_MESSAGES table.

So I just want to make sure I understand, the control source is where the query comes from and the record source is the data that it is going to be pointing to in the table?

I should have said that when I select a system from the dropdown of the combox instead of input.

I am aware of this. I know the form can be bound, I know that if you click the arrows at the bottom of the form, it will enter your data. Even before I created the button though, It was doing this which is why I know it's not the button. I have the form record source (which is what it's bound to...

Hello everyone, I'm trying to make a database for equipment and related documents for this I have created a table for the systems and created tables for the technical documents that I will be needing to input. I plan to use a form for the end users to submit the data easily to the related...