Search results for query: *

Thanks for the quick responses! I searched but didn't know the command to search for (I read probably 100 post titles on combo boxes). This forum is invaluable.

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

Nevermind. I got it figured out. Thanks all!

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

That is what I have been trying to no avail! I put it in "got focus" to requery the name of the subform control, but am doing something wrong, apparently. Argh!

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.

Thank you so much. That worked perfectly! I have spent so much time on this problem. You have made me look great in front of my boss. Have a star! Jeff

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 am using Access 2000. That is not the answer I was hoping to hear, but I appreciate it anyway! Thanks for your help. Jeff

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

Didn't take it wrong and wasn't asking someone to do it for me. Also, not in college (10 years ago). I built the data base and my boss wanted it to do something I didn't design it for. I have probably spent 15 or more hours trying to solve this problem and was coming here to see if anyone had...

The form has various fields of info relating to the ad such as cost per inch, date, and whatnot. The subform looks like this after it is filled in: Supersuckers 4 The Cramps 5 Queens Of Age 2 Planet X 3 each line is two fields (columns), one with the show, one with the...

This will sound stupid, but where do I stick that formula? I am self taught and so am probably missing a few bits of info that are common knowledge to everyone else. Thanks for your help, Darrylle.

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.

Oh...It is a combo box, not a list box. Sorry for any confusion.

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