Search results for query: *

Thanks. That worked. I wish Access wouldn't apply this "layout" to my forms. Is there any way to change the default? I really appreciate your help.

When I create a form in Access 2007, all of the controls for the fields in the table the form is based on appear (in orange) the same size and shape. If I select one control and try to modify its shape or size, all of the controls are modified in the same way. How can I set Access 2007 so that I...

Thanks, MasterRacker. That worked. Sometimes the obvious is missed.

This is the code I tried. Private Sub Composer_AfterUpdate() Me.Composer.Requery End Sub I also tried the RowSource suggestion above with no luck.

The combo box After Update event - so that the code fires once the user finishes entering text in the combo box field.

Thanks. I tried that at your suggestion, but it doesn't work. I still don't see the refreshed list from the query.

I have a user entry form in Access 2007 that is causing me difficulty. I am having a problem refreshing the data in a combo box that is based on a query that lists all of the current items in a field in the table on which the form is based. An example of the query is shown below: SELECT...

Thank you so much. Don't know why I couldn't find it. Just looking in the wrong places.

In earlier versions of Access, I was able to change the default search method for a database in Options. I can't find any way to do this in Access 2007. Is there a way? I want to search on "any field" and "any part of a field" as the default. Thanks.

The settings are found in the Folder Options window available under the Tools menu. Under the General tab in the Navigation pane section, there are 2 options. The first is Show all folders; the second Automatically expand to current folder. When either of these were selected, my Explorer ran...

Thanks for all the suggestions. I found that there were settings in Windows Explorer that were causing it to workthrough all folders in the path before I could proceed. Once I changed the settings everything was fast again. I have no idea how they were reset.

I am running Windows 7 (64 bit). When I bought the PC about 2 months ago, everything ran fast, but now the Windows Explorer seems to have slowed to a crawl. Can anyone tell me why this happened or how to fix? I have a very large disk (600g) with512g free. I have checked to see if it needs...

I downloaded Agent Ransack and tried it. It does exactly what I need and does it fast. Again, thanks a lot. I may never use Windows Search again.

Thanks for your response. I hate Windows search too. The More option only offers other columns, not a way to sort correctly by top level folder.

When I perform a search in Window 7, the folders column is sorted by the lowest level subfolder instead of the highest level as it was in Win XP and earlier. Is there any way to sort those folders by the highest level subfolder? For example, the folder is shown and sorted as: Taxes -...

I want to run an Insert query to insert records from one database into a different database using VBA code in Access 2007. I have set each database using the names WorkingDB as the source database and ActiveDB as the target database. The SQL is something like this: strSQL4 = "INSERT INTO...

I have learned that my host service does not allow remote connections to the database. If I set up my ASP code to run from the server, will I be able to access my local database? How can I specify the connection for an Access db on my local PC? Will any of this be easier if I convert my db to...

I have an MS Access database that I update on my local PC. I would like to use ASP.NET to run queries that will extract data from specific fields in the local database and use that data to update only those fields in a similar database at my website. How can I do that? Do I have to run the ASP...

I am using Framemaker 7 to create a document with hyperlinks to URLs at my website. When I save the book as a PDF and open it in Adobe Reader 8, the hyperlinks show up correctly. However, when I click on one of these hyperlinks, two instances of IE7 open. One instance is blank and the other...

Thanks for the suggestions. I was hoping for a more direct way to do this than to use a hidden form but that will work. ssatech - How can I find the threads you suggested? I tried searching on the number, but nothing was found. Thanks again, all.