Search results for query: *

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

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

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

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

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

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

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

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

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.

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

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

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

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.

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

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

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

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

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

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

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