Search results for query: *

I would like to alter my question. Instead, I now have set up a combo box that reads a query's employee ID field and the name associated with it. After I click the combo box and set up the correct employee ID, only the employee ID shows for the combo box, which is what I want. However, after I...

I have a form in which I created a command button. When I click on this command button, I want it to open a query, which I have done. This query has an employeeID field and a name field. When I select the row in which I want, I would like the EmployeeID information from the query to be sent over...

Bill- Thanks a lot for all of your help! The form is working great and is exactly what I wanted! I really appreciate it! Chad

I don't suppose you could show me how to pass the query info to a listbox or form? Are you saying that there is no way for a query to just list the assigned info (like starting with Sally F., instead of the entire listing starting with Abby B.)? Also, I put the criteria back into the query...

Thanks for the tip on the BeforeUpdate procedure. That is a good point. Below is the code I have wrote for the BeforeUpdate procedure. I have a few bugs in it yet. For example, if there isn't a first name and middle initial, the query still pops up and warns that "This name is already on file"...

Yes, these are all in seperate fields (all different text boxes). Okay, I created a query named qryFirstMiddle and in the criteria for the FirstName, I put Forms!frmEmployee!FirstName and the criteria for the MiddleInitial I put Forms!frmEmployee!MiddleI. From here, what needs to be done so when...

I have an Access form in which you input employee info. I enter a first name (in a text box), last name (in a text box), and a middle initial (in a text box). I want to edit code for the "On Exit" of the middle initial text box to go and compare to a query in which the first name and the middle...

I have gotten a lot farther thanks to the previous posts. Currently, I have the form made and click a button which brings up a calendar and click on a date, and this date goes in a "BeginDate" text box and the calendar disappears. I also have another button which also brings up a calendar and...

I have a form that I would like to use a calendar control for. This form will be used to track surgeries. I would like to set up a button on a form and when you click it, have a calendar pop up. When you click a date, this will be the start date, and then the calendar will disappear and another...

I have a .dwg file that I need to use within Visio. I open up the .dwg file within Visio and then highlight the entire diagram. From here, I right click on the diagram, click CAD Drawing Object, then Convert. From here, I select the layers that I need to convert, then click Next. The next option...

Thanks for your reply. Ok, here is the situation. I put the necessary code in the widgets.htm file however what I need to show up doesn't. All that shows up is a shape name with a gray colored box below it with the label and value fields, but nothing with them. Those aren't my custom properties...

Great, this is really helping. Sorry to be a pain, but I have one more question. Now that we are getting somewhere, the most ideal thing for my visio web pages would be that as soon as I click the link for the visio web page, to just have the custom properties appear with the drawing...

Great, thanks for your help. Now, one more question. Is there a way to change that line of code in the "if" statement to just have the custom properties appear when the mouse is moved over the shape with the custom properties instead of having to click on that shape? Any info would be...

I have purchased Visio Professional 2003. We have a facilities management diagram that is sectioned off and then broken down farther into individual rooms. These rooms and sections are hyperlinked together and are saved as web pages and then posted on our intranet. Each room has several custom...

Hi. I just purchased Visio 2003 and noticed some differences in the save as web page feature. In 2002, when you saved as a web page and included custom properties on your shape, all you had to do was use the mouse and scroll over the shape to have the custom properties appear in the left pane...

We have a facilities management diagram that is sectioned off and then broken down farther into individual rooms. These rooms and sections are hyperlinked together and are saved as web pages and then posted on our intranet. Each room has several custom properties. We can export these custom...

Hi. This is another new question. I export a .vsd to a .html along with custom properties. However, in order for the custom properties to appear, I must move the mouse cursor over the room number and then it stays up. Is there a way to just have the custom properties appear when you click on...

Hi. Here is my problem: In our facility, we have around 500 rooms. I have created 5 custom properties thus far for each room in our facility. In order to view these in Visio, currently I right click on the number, go to shapes, and then go to custom properties. However, I'm interested in...

Hi. I am trying to create an ODBC data source which will be used to link between Access and Visio. However, I can't seem to do it correctly. Could someone please give me step by step instructions in how to do this? Thank you! Chad

Hi. I am calculating the area and perimeter of each room in our facility. Once I have each room's area and perimeter, I would like to immediately transfer that information into Access. Could you please tell me how to send information from Visio into Access! Any information would be helpful...