Recent content by mister

Hi Pam, I am having a terrible time importing from Excel into Access 2007. I keep getting the same "subscript" error message. What did you mean you "had a field defined as double" and how did you compare the attributes after importing to a new table?

Thanks. And to find the Control Source, do I go to Property Sheet > Data? For some reason I am having a difficult time having that option become available.

I am very often creating new reports from different queries – I need to format the reports the same way each time. Is there a short-cut/efficient way to do this so that I am not constantly formatting reports? Is this where I would change the RecordSource in the Properties/Data? If so, is there a...

Where in the report do you click to get this? When I go to Properties to change the Data Source, I don't see an option for Record Source.

I wanted to save my reports at work in PDF format, so I downloaded the Microsoft Add-in, per the instructions.... Downloaded/installed fine. When I go to my report to "Save As" the PDF option is now available, but when I actually save it, I get a long error message about the format and I need to...

Again: thanks...... A project to play with!

Thank you for your prompt & detailed reply. Sorry to say that I am still "lost.":( I don't use forms to enter my data. I do it either in the Query or the original table. Would that still work? I've not used option groups or codes either. Thanks!

Thank you. I have to confess that I am not entirely sure what you mean (I am quite new to Access 2007). When you say to change the recordsource of your report in the On Open event, do you mean Design View > Property Sheet > Event? I don't see recordsource..... And for the next part (use an...

If I have to create the exact report many times, the only difference being that I use a different query for each one, is it possible, once the first report has been "formatted" how I want it to look, to "save" this format or create a "template" so that each time I create a new report, using a...

Multi-page reports The reports contain a lot of information (between 20-40 fields) so that it must span multiple pages (ideally, it would look like a spreadsheet). When I am in Design or Layout View, once I get to a certain point, I can no longer use the "scroll" bar at the bottom of the...

Thank you!

In creating a report based on a Query that uses about 20 fields, I am not able to fit all the fields in to the Design or Layout Views to work on.... and thus, cannot get a report that is (landscape) more than 2 pages. Ideas?

In my table I had a field with a Field Property as Yes/No (with a Lookup Wizard). Reports generated obviously included the "yes" and "no." Then I changed the field in that table to Yes/No with the Field Property Lookup format as CheckBox. The data in my reports then changed to a 0 and -1 instead...