Search results for query: *

The first time I tried the report I used the wizard and used the summary options in the wizard. For some reason it came back with a total of 'yes'. I played with some things and I got 'error' in the text box where the total should be. I think I have it figured out now but if you have any more...

[AField] is just what was in the sample code. The field I want to count is counties. I tried to use: =Count([CountyName]) also =Count([CountyCode]) Neither one seemed to work. I am going to try them again just to see if I typed them wrong. I will also try =count(*) to see if I can get...

I have a report that is broken down by state and then by county. I need to get a total number of complaints for each county and then a grand total of complaints at the end of the report. In the query there is a county code and a county name that corresponds to that code. The grouping is...

Thanks for the tip.

I have been working on this for about 2-3 days and am frustrated with this. I have a combo box on my form that I use to search for a particular record using the 'Official Citation'. My problem is that there are several records of the same Official Citation. I have an autonumber setup as the...

I made a database that was working fine. It was only after I had finished the database, and data was being entered, that I was informed that the field I designated as the primary key would not work. Origanally, I used 'OffCit' as the single primary key. Now they tell me that one 'OffCit' can...

I've tried several things from different people and none have worked. I think I have a different version than some people. Or maybe I'm just sutpid. I have Word 2002. If anyone has some other suggestions I would love to hear them. I'm in the process of creating a brand new query for this mail...

We are having problems with several mail merges now. Things are getting real fun. I'll try that later to see if it works. Thanks for the help.

I pasted that line in there but I'm getting compile errors. I type CTRL+g and the bottom window opens. I paste the code in there and hit run. It wants me to save or create a macro. I saved it as test and tried to run but only got errors. I know I've done something wrong but I don't know...

I have a Word document that is supposed to be tied to a query in my database for a mail merge. For some reason it doesn't work. This whole thing was created before I started my job so I'm not sure what query is linked to the Word document. Is there a way to tell which query is linked other...

The report already runs from a query. The query pulls 9 records at the moment. The field I need to display is in a third table. Whenever I try to add the third table to the query it shows no results when it is run. I am really confused as to why this happens. I thought this was going to be...

This is probably a really simple question that I am just overlooking the answer to. However, I can't figure it out. My report is linked to a table (Complaint Register). One of the fields in this table links to another table (Product Line). They are linked by 'Product Code'. My problem is that on...

Thanks for the help. I had a few minor problems come up after I put the code from PHV in. However I think I might can figure them out. If not I may be back on here to look for some help. The other sets of code gave me an error. I have one control on my form that has the focus on the opening...

Yes. That sounds right. I only want the control to appear if there is data to be displayed in the control for that specific record. Any help?

When my form opens only certain combo boxes show. I have set the others to show only after I click on the preceeding box. My problem is when there is data in one of the combo boxes that is hidden, it won't show. I have 4 boxes showing when the form loads. One of the records should show 5 boxes...