Recent content by ktariske

Ok, quick and to the point. I have one table. It has 3 fields. It has: employee name, visitor name, and date. All i want is to run a report with a list of employee names, sorted by the highest number of visitors down to lowest, with employee name. I can add the sum in the report footer for...

Ok lets start over. I have a Query pulling records from a VISIT table. It comes back with: Visitor Name Date Employee Name Greg Johnson 4/20/2008 Greg Meeting Ann Test 11/20/2008 Jim Test Brian Timor 04/12/2008 Ellen Same Joe Shmow...

Thanks for the reply. I love this forum. I have a query that gives me a nice 7000 record return with the info I need. I created the report, but alas it's 500 pages. It contains 4 fields, Employee name, visitor name, date, location. The report, being 400 pages was a bit much. So i removed the...

I bet this has been asked before, can't find anything with search. Can you sort the count function in a footer? I have added the count function and get the correct total for my report. In this case employee, total number of visitors on campus. Now I want to sort the report by number of total...

That's what I would have done. Turns out the database was an import, that's why it didn't have any formatting. I was able to get the information I needed out of it, so I'm done with this. I would never have created a tbl like that. Thanks so much for the follow up. Kriss Tariske Redlands, Ca

I have a database with 1 table. It has as fields: Check#, PAYEE, City of Payee, and amount. I did not create this database, so I would never have had the payee in the same table. Anyway, now somebody wants a report or qry based on 1) Number of checks written to say payee X. Now for the tricky...

I have a text box on a report. It is toward the right side of the report. I need it to stay where it is. But sometimes the amount of text is longer, and it just drops off the page. Is there anyway to have it continue directly underneath the line above it? So it continues?? Example Now: THIS...

I thought this was a hidden system file? Under options in Acces there is an option of hide/display system tables, ojects. ????? I thought.

Returning different value to table from form. Returning different value to table from form. By using the following code, we can get the code changed by watching the code monitor, but then we can't pass the value to the approperate table. Private Sub Form_Error(DataErr As Integer, Response As...

Emergency... we have a form that we use to enter in a 4 digit number from a barcode scanner. The bar codes on our inventory is returning a capital O instead of the number zero. Is there any way to intercept the carrage return and check for a capital O and insert a number 0 in it's place...

Hi, I run a query, and I only want to return the first record, not the entire record set to a report. Can I somehow limit it to just the first record?

Hi everybody, I use an output macro in a query to create a text file of remaining inventory while scanning. I have a small thermal printer that prints a text file, but the problem is, if I only need 5 lines, it starts wasting alot of paper. Is there anyway to append to this text file, and just...

Thanks. It still prompts me for the over-right file, but then I read the help, and that's the expected outcome,. I just thought I could avoid that with some VB code, but I guess that will just have to do. Thanks for your help.

Printing, Many people in my department use my access front end to print box labels and shipping lables, using 2 different printers. Many people are having problems with the print dialog boxes and in most cases, can't set the properties correctly, wasting time, paper, and my time. So I was...

Anyway.. To specify a network printer as default for everyone???