Search results for query: *

I have a combo box that is populated from from a table called tblCustomers. I would like for it to work like this: The user starts typing and the combo automatically goes to the customer as the name is typed in. Easy enough. However, if the customer is not in the list and the user enters it in...

I have a report with 2 subreports. If there are no records in one of these subreports, nothing shows up but it still inserts a blank page in the report where the subreport should be. I have no page breaks that i know about. I would really like it to not do this, as i will eventually have 6 or 7...

I have a form (Main) with a subform (Orders) showing orders in datasheet view. There are several buttons on the main form that pull up different order entry forms which input the data into the table that the subform draws from. Unfortunately, once you close the entry forms and get back to the...

I am searching for a program or technique for fixing Outlook .pst data files that have the error (cyclical redundancy check). I need to extract emails from an archive that has this problem. If anyone knows of any such program and they could please let me know that would be greatly appreciated.

I am trying to join two tables into a third table to create every possible combination of the two and am not sure how to do this. Here is a simplified version of what I need to do. Take a table whose only data is three first names and join it with a table whose only data is three last names to...

I have a subform that allows you to make selections from a combo box. The combo box, in turn, is drawn from a query that is filtered by date for upcoming events (ie. nothing previous to the current date is in the combo box). When you select an event, it only shows the second column (the name of...

I have a report that I export to excel and email out several times a week. I have a calculated total at the bottom of the report that sums the one set of fields. When I export to excel (or whatever), all the fields are there, but the calculated total at the bottom does not show up. Any ideas...

I have a database that tracks advertising for concerts by the ad. For instance, one newspaper ad will have several concerts in it. I have a form that has the ad and a subform that lets you pick the concert and the percentage of the ad. I have a combo box listing upcoming concerts that is drawn...

I have an ad tracking database tracking how much of each ad placed was for which product. The products change every week and we run a new ad every week. The ads are entered on a form. This form has a continuos subform with 2 fields. One to enter the product and one to enter the percentage of the...

Is there any way to alter the data in a crosstab query? Ineed to display the data in an array by date and then create new records based on this display. My boss is breathing down my neck on this one, so any help is appreciated.

I work for a concert promoter and have built a database to track our advertising expenditures by newspaper and show. We do several shows a week and run ads in several papers. I currently have a form for a paper open up. It has a place to enter the date the ad runs and cost of the ad, along with...

Is it possible to change data from a Pivot Table view? I am self taught, so might be approaching my problem from a skewed design. Any help is much appreciated.