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

    Repeating Changing Navigation Links on Every Page

    Jeff, that's exactly what I was looking for. Now I just need to change the other 19 pages to aspx, remove the bullets, and put them all on one line. I saw some CSS code that would be helpfull to that end. Thanks again Jeff! ...David
  2. Yarcadian

    Repeating Changing Navigation Links on Every Page

    Hello, I have a site that I use to showcase my woodworking hobby at www.yarcadian.com where I have 19 pages of pictures with explanations. I will be adding another 5+ pages to the site and am tired of repeating the code for the links on each page and then re-publishing each page. My Question...
  3. Yarcadian

    Developers Extensions Package Wizard add Registry Key Issue

    Hello, I am using the Developers Extensions Package Wizard to deploy a runtime version and I need to modify the registry to set the Macro Security to Low. The key location is HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Access\Security with a DWORD key called Level and the value set to 1...
  4. Yarcadian

    Delayed event in a Macro?

    Yes, I would put it on the same form where they do the key entry. With the button there, they won't have to open/close another form to run a button. You could also create a second query and tie that in with the current record to only merge that one record. I would point the record number...
  5. Yarcadian

    Report Question: User Chosen Criteria and Sort

    grnzbra: I have not had a great deal of success when working with loops, but I like the idea of generating a query def based on one. I am going to have to try again..Thanks David
  6. Yarcadian

    Report Question: User Chosen Criteria and Sort

    Thanks Bob, this really helps me out. I have been trying to make it too complex and was getting nowhere fast. David
  7. Yarcadian

    Reports won't open

    Are you getting any error messages? Is it every report or shotgunned?
  8. Yarcadian

    Use a Form to Create a Report

    Still, it sounds interesting. I am always looking for new ways to do things. You never know when that new technique will come in handy. :D
  9. Yarcadian

    Delayed event in a Macro?

    Okay, so why not kill the message box all together, add a command button that they can click when they're ready to run the merge? This way you're not waiting for their input and the query would be completed before the merge is started.
  10. Yarcadian

    Report Question: User Chosen Criteria and Sort

    One of my current projects is a compliance db. The user's want the ability to decide which criteria they want to use for any given report and the ability to sort the report by any field. For Example: Say there is a Vendor Compliance Report, the user's want to decide if they want All Vendors, a...
  11. Yarcadian

    Use a Form to Create a Report

    grnzbra, If I understand you correctly, you're saying with your suggestion, you could create a form with a drop list of reports and based on the report chosen, other drop lists or fields will populate the form to enter the desired criteria? If this is the case, I am very interested in seeing...
  12. Yarcadian

    Delayed event in a Macro?

    Have you tried to create the update query and have it run after the code to open word if the user selects yes?
  13. Yarcadian

    Import Specification Trouble

    You should not loose anything by copying the database. Did you include a path in the specification, and if so...is that a valid path for the new location and/or does the new location have permissions if the path is pointing to a network drive/folder? Other than that...I have no suggestions.
  14. Yarcadian

    Use a Form to Create a Report

    [Forms]![Form Name]![Combo Box Name] You can use this with multiple fields. For example: I have a report form where a user first selects a Division, then based on that the next combo box populates with only the Buyers associated with that division, then they can select a specific PO or leave...
  15. Yarcadian

    Use a Form to Create a Report

    And yet another way...... For the Agency criteria in your query, point it to your combo box. Then when you click the button to run the report it will only pull the agency listed in the box. David
  16. Yarcadian

    Updating Fields in Tables

    Use an Update Query, link the two tables together using your index key or primary key and bring down the field from table1 that you want to replace. Under the Update To point it to the table and field where you want to pull data from. You can go a step further and add criteria such as Is Null...
  17. Yarcadian

    Formula in a form

    Try adding this to the ON UPDATE for the check box: if me!check = -1 then [field name]= sum([in]) else: [field name] = 0 end if David
  18. Yarcadian

    change password in workgroup

    This works real well.....with this you can change any of your user's password while logged in as yourself. Create a form with 4 fields and 2 buttons Form Fields 1. cboUsers [Row Source Type] = glrcboUsersFill 2. txtOldPwd [Input Mask] = Password 3. txtNewPwd [Input Mask] = Password 4...
  19. Yarcadian

    Logging Out Users

    Richard, Check out thread181-468123 I used the suggestion of creating a table with a single check box that was placed on a form and with the timer set, if the box was checked, it kicked everyone out. Works Great....David
  20. Yarcadian

    XP and 2K Issue -- Databases Are Crashing

    Hello, Has anyone ran accross an issue where a db will crash when an XP user and a 2k user (Office Versions) log into a db either at the same time or not? Everytime they crash I have to re-compile the code and compress the db. I can move around the db with no problems, but as soon as a 2k...

Part and Inventory Search

Back
Top