Search results for query: *

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

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

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.

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

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

I would like to run code to copy my .mdb backend files when a user closes the database or exits Access. I can't find any way to kick off the code. Can anyone help? Thanks.

Is there any way to print the formatting details for a document so that I have a record of what is being used and how the formats are set up?

I want to copy one paragraph or character format to a different document. I don't want to copy all the formats from one doc to another. How can I do that?

I would like to be able to right-align the numbers in a numbered list so that the right characters of the numbers 1, 10, and 100 line up on the right. Can this be done? How? Thanks.

I have a report that shows the number of products sold by each salesperson. The report is grouped and sorted by salesperson and I want to show how many salespeople are included in the report in the header of the report. If I use count(*), I get the number of all of the records on the report...

Is there a way to assign a shortcut keystroke combination other than Alt plus an alpha character to an Access control? I would like to be able to use some other combination, like Ctrl-Alt plus a character or even Alt plus a non-Alpha character. Thanks.

I am trying to populate a 3 column list box from code. It works fine except when a string contains an ampersand or a comma (and possibly other characters that I haven't tried). When one of those characters is in the text column, that character and everything following it are placed in the first...

I am trying to create a string for a SQL statement in code that gives the same results as the following built in a standard Access query: SELECT tblContributor.ContributorKey, [tblContributor]![LastName] & IIf(IsNull([tblContributor]![Suffix]),"",(", " &...

I want to be able to display the entire contents in a field when the number of characters exceeds the number that fit in the display area. When I try to do this using an On Change event, the field (variable = fieldname) contains only the characters (if any) that were there when the cursor...