Search results for query: *

I have a form to collect info for a mailing list. After the person enters the data and clicks Submit it first appears that nothing has happen. Then the person gets an error message. The error is an error as the data has been successfully sent. Because of this people are clicking on the Submit...

I have a report that has three sub reports based on the same data. I would add that there is no master child links between the data. This is not a one to many representation of the data. The first two sub reports are actually forms consisting of pivot charts. The third is a standard report that...

I have a form where the user makes selections from a group of combo boxes. When finished they click a command button that concatenates these different selections and enters the result in a field on the form. After this result has been entered I want to check to see if it already exists in the...

I have a table that has a field that contains data like 04 or UB or NX. I have a query that the criteria on this field is <> "NX". When I run the query I still see some records with this entry. I have also tried Not "NX". I am using Access 2007. Any insights will be greatly appreciated.

I just upgraded from Access 2003 to 2007. I have one database that when it tries opening the main form says that the owc11.dll is missing. I am also having issues with the application not liking the Date or Format functions. What's up with that. Anyone run into any of this in the upgrade...

I want to add a audio file to a websites home page. It will start when the page loads but I want a button visible to switch the music off and on as the viewer wishes. I've got the <BGSOUND SRC= tag part of it I just can't find anything on adding the button. Thanks

I have finally started to use 07 and have come across what I am sure has a simple solution. What is it with text boxes in this new version. If I size one text box on a form all the text boxes resize together. How do you set sizing individually?

I have a command button on my form that runs a macro. The macro's action is Apply Filter with the Where Condition being [Forms]![myform]![myfield]="mycriteria". This filter returns 0 records. If I right click myfield on the form and enter my criteria in the Filter for: box all works OK. What am...

I have a command button on my form that runs a macro. The macro's action is Apply Filter with the Where Condition being [Forms]![myform]![myfield]="mycriteria". This filter returns 0 records. If I right click myfield on the form and enter my criteria in the Filter for: box all works OK. What am...

I have a form that shows information for the years 2004, 2005 and 2006. The information is how many of a part were replaced on an aircraft in that year. This qty is then divided into the # of flight hours giving the average time installed. I then average this avg. in the form footer. Everything...

I have a Select query that returns 15 records. The three fields are Year, Qty, Amount. When I convert this to a Totals query grouping on Year, Averaging the Amount and Counting the Qty the query comes back with a Count of 16. How is this possible? TIA Kent

I would like to export a single table record out of Access into Excel. I would want to take each field in Access and put the data in a specific cell in Excel. Example: The FirstName field goes into cell F3, LastName goes into G3 etc. I want to export this into an exisiting Excel file that...

This question is for Access 2007. I went to create a TransferSpreadsheet macro and it is not available on the dropdown macro list of choices. Has this been removed from 2007 or do I have a bad install?

I have downloaded the FP Windows Media Player component form the MS website. When I try to insert it on a page I get the properties dialog box and it says "No description is available for this FP component" and "There are no settings for this FP component" I am using FP 2003 on XP sp2. Thanks Kent

In my Word configuration I use the blue background with white text. When using Word as my email editor with Outlook when I reply to emails the text by default goes to blue and as a result you cannot see the text. It is inconvenient to have to switch font color every time I reply to an email. I...

In my Word configuration I use the blue background with white text. When using Word as my email editor and I reply to emails the text by default goes to blue and as a result you cannot see the text. It is inconvenient to have to switch font color every time I reply to an email. I have looked at...

I am sending data from an Access crosstab query to a mail receipient as an Excel spreadsheet. There are 5 columns in the spreadsheet that provide the person fields to enter a price. These cells by default have a format of General which does not work for entering currency values. Is there a way...

I am sending the data from a crosstab query to a mail receipient as an Excel spreadsheet. There are 5 columns in the spreadsheet that provide the person fields to enter a price. These cells by default have a format of General which does not work for entering currency values. Is there a way to...

I just purchased a new notebook with 802.11g wireless capability. I live in an apartment and when I booted up this morning my computer found 2 networks and connected to one of them with a very weak signal. I am awaiting a Linksys wireless router and I understand about how to secure my network...

I have researched all the Access sites that I know of and cannot find a solution to my problem. I want to have a form that has two combo boxes. One for specifing Buyers and one for Suppliers. I want to be able to filter records in a table using a parameter query. I also want to be able to have...