Search results

Are you using the Wizard to Import? Have you tried looking at a MACRO to do the import? If you struggle perhaps zip an extract of the spreadsheet and Database so we can take a look at it for you and advice further.

How have you tested it? Suggestion. Create a Blank Report and then add the Message Box and test it when you look to Open it perhaps to Print Preview.

When you =Count(0) it counts against all records from the record source. If you want to be more specific you can specify the Field Name. If more criteria is needed you will have to tell us what that is and against which Fields and Tables etc.

Open the report in design view and the report properties, then under the Event Tab you have a property On No Data which you can place a message box and use a Cancel event.

You more than likely will need some VBA. Has the database currently got any security levels in place as 2010 no longer uses the Security Wizard for groups and permissions.

Add an extra textbox on your form and in the control source you can use the Count Function which will give a total.

Have a look at using a Cross Tab query or even a Pivot Table within Access.

Welcome to the Forum, Read this article form Microsoft to see if it helps. http://support.microsoft.com/en-gb/kb/931407

Happy to help and thank you for letting me know you have a working solution.

Can you upload an extract of the database with the form and then someone will take a look for you.

Try compacting the database and then zip it up to upload if the size exceeds 2MG it wont be allowed. If that is the case then place a link to your thread to the database where every you upload it to, such as DropBox.

Lisa your file cannot be downloaded. Try this. When you start a Report use the Wizard then as you select your Table/Query then Next stage should ask you to Group and you select your Vendor Field then simply complete the rest of your report and it should Group for you. If this fails uploaded a...

Ok here what to do. Open your form in design view. From the toolblx click the Check Box tool and then open the properties for the checkbox. In the properties name the checkbox chkYes and change the Visible to False do the same with the Label. Then select your Combox and in the properties select...

Can you attach an extract of your database to find out why the query isn't providing the correct answer. As the SQL is correct.

Do you mean it shows a Check Box on the form?

This would provide a solution for you http://support.microsoft.com/en-us/kb/160502

Taking into account that you have stated it will be contained in the workbook there shouldn't be a concern as the code will work from within the workbook you distribute. Check out the following link http://www.cpearson.com/excel/vbe.aspx Chip Pearson will explain and there are some options...

I would consider using some vba to send to Excel and do the calculation there then import the results in the background, access doesn't like looking at one row compared to another when checking for results and criteria. Like an IF statement if the record below states this then do this if the...

Sorry no one seems to have given you a solution but have you found a solution? If not you can do something like this: Sub CopyAndSave() 'Change the sheet name Sheets("Play").Copy 'Save the workbook ActiveWorkbook.Save 'What do you need to do next End Sub

There are several options, but take a look at this option about creating an Add In. http://www.fontstuff.com/vba/vbatut08.htm