Search results

Consider me clueless. Pat - Where is the ColumnHeadings property so that I can list my values? This is exactly what I need if I can figure out how to make it work. Thanks!

Nope, still doesn't work. There has to be a way to create a report that looks like this: LasVegas Tradeshow 6 Corporate 3 Conference 5 Houston Tradeshow 9 Corporate 5 Conference 1 Georgia Tradeshow 15 Corporate 7 Conference...

Looks like I had this problem before and never solved it. I need to use Count instead of Sum, but it is the same issue. Group 1 - City Visited Group 2 - Program / Software Type Detail - Client Number I can count the number of clients for each Program/Software type. Now I need to know how...

Ack! I am going to look at it again. I was just upgraded to Office 2000 yesterday, finally!

Here is the database. I pulled out all the queries, reports and junk that are just "extras". Thanks!

I am a little stumped and could use some help. I can find my way around Access 2000 alright, but recently I have been moved to a new department and they have 97. I can not as easily create and debug the things I want in the database. I am hoping that someone can help me see the forest through...

Yipee!!!! Thanks John for your help. That is exactly what I needed!!!

I am having the same problem. I have tried adding "DoCmd.SetWarnings False" in every location I can think of and I still get the Access warning. Has anyone had any success in working around this?

Thoughts? Any idea for me? Please.

More info... There are 9 tables with basically, the same fields. Each table holds checklist questions for a specific application the user will be QAing. I also have an Audit Table that records all the changes made to certain fields in specific forms. I found this information on a thread...

I have been reading threads about archiving and cloning but I am still lost. What I have are multiple tables, each with questions for a specific application. I need to find a way that users can copy a question from one table to another. Previously users would copy and paste directly in the...

I am a novice as well, compared to all the knowledge on this board. My guess would be to use DCount(). I think the code would be: DCount("FieldName", "TableName", "FieldName = 'Criteria' ")

I believe what Rich is saying is to base your report on a query that only pulls the top 10 records. In the design view of the query, you will see a field in the tool bar that says "All", "100", or something of the sort. If you make that field say "10", then only the top 10 records will pull.

Pat, how would I create a filter for DSum()? I have a report that shows the phone statistics for 3 phone rotations. Rotations 1 and 2 are agreements for 2 different companies. Rotation 3 is supplies. My data is grouped by date. I would like to see the sum of calls for all rotations for each...

I have a database that adds the number of hours an employee was logged in the phone system and how long he was on available, etc. What I did was use queries to convert all the times to minutes, add the times I needed and convert back to hr:mm format. It was some what tedious, but it works.

Every morning I back up my databases and compact and repair them. The last few days, my backend has been giving me this error: "Microsoft Access can't delete L:\KEYSupport\Maintenance Agreements\KTBackEnd.mdb after compacting it. The compacted database has been named...

Okay, I have searched Amazon for Access books and found a few. One question that I have is, if you have a multi-user environment, do you have to use SQL Server as the back end? I am using Access as the back end. I have no idea if we have SQL Server, though I am certain that we should, but...

Select the combo box icon in design view. The Wizard will walk you through setting it up. You will want to select "I want the combo box to look up the values in a table or query." Select your table. Then select the field you want to show. The Wizard will give you a "sneak preview" of how your...

I need reference books! I have been crowned the "Access Guru" at my office only because I know more than any of them, which doesn't mean much. We had a fairly simple database that 2 or 3 people were using at the same time. It houses client data regarding their equipment and support status...

Help! I am trying to educate myself as well as my co-workers on how to use this database without corrupting it. What we have is an Access 2000 BackEnd with the data linked to an Access 2000 FrontEnd with all the queries and such. Just now one of my co-workers had the main form opened to a...