Error message appears when multiple people Access Database

[Juggler]

I have a report that through query counts the number of records in a table for display. My problem is that if there are no records I am getting "#error". How can I display a "0", if there are no records?
In the text box this what I have, =[table].[count]
Any suggestions

[carleigh1221]

I have a report being displayed. I want to know if there is a way to click in one of the fields and bring a form to make corrections and/or display more information regarding the item clicked. (This display is a calendaring events and we would like to display other information that is unique regarding this particular event eg. phone numbers,etc.). Any help is appreciated. Thanks in advance.

[TonyES]

Try =IIf(HasData,Count(*),0)

[TonyES]

Create a tool bar or menu bar that is diaplayed when the report is open. Add a command button to the bar in question that opens the form.

[soniqantranig]

I am trying to run a query where I can pull entries that have a certain field. For instance my database tracks companies that are inspected and who conducted the inspection. I want to be able to go in and pull the list of inspections conducted an individual.

Company Inspected By
X Co. Jamie
Y Co. James
Z Co Ricky
U Co Matt / Ricky
How would I set it up to pull all inspections conducted by Ricky?

[marblearchibald]

I am performing some updates on a program I wrote - and need to send 6 new queries. The problem is when my user gets them, all of the relationships (joins) no longer exist. I assume this is because there are no tables in the little db I'm sending - but how do I prevent this from happening?

[carleigh1221]

I'm working with some data from an excel spreadsheet, and I need to put it into a form on Access, but I can't figure out how to get the info from the excel sheet to Access. I tried copying it but it just puts that info into the one field, and doesnt create multiple fields for it. If anyone can tell me how to get data from Excel and put it into a Form on Access, it would be greatly appreciated. Thanks in advance.

[fordbeatrice]

I have created a custom tool bar that is displayed when a specific report is open. The Print option does not display the Print Dialog, but instead immediately prints the report. How do I display the dialog? Any suggestions!

[TonyES]

Try the SQL code some thing like the one shown below:
SELECT * FROM yourTable WHERE [Inspected By] Like '*Ricky*'

[TonyES]

Try to add the shells of the tables to your little db, same fields, etc., but with no data in them. I hope that will preserve your queries like you want.