Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cldh00

    Command button on form

    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...
  2. cldh00

    Command button on form

    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...
  3. cldh00

    Comparing form fields to query

    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
  4. cldh00

    Comparing form fields to query

    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...
  5. cldh00

    Comparing form fields to 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"...
  6. cldh00

    Comparing form fields to query

    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...
  7. cldh00

    Comparing form fields to query

    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...
  8. cldh00

    Calendar Control

    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...
  9. cldh00

    Calendar Control

    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...
  10. cldh00

    Converting .dwg to .vsd

    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...
  11. cldh00

    Save as web page

    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...
  12. cldh00

    Save as web page

    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...
  13. cldh00

    Save as web page

    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...
  14. cldh00

    Push data into Visio

    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...
  15. cldh00

    Save as web page

    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...
  16. cldh00

    Push data into Visio

    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...
  17. cldh00

    .vsd to .html

    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...
  18. cldh00

    Custom properties and forms

    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...
  19. cldh00

    Creating an ODBC data source

    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
  20. cldh00

    Linking Access and Visio

    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...

Part and Inventory Search

Back
Top