Search:

I have a list box on a form that filters records in the form successfully in Access 2003 and 2007. The afterupdate event reads:

Me.RecordSource = "Select * from [tbl_Instructions] WHERE...

I use code in Access to copy query data to an Excel spreadsheet, then update graphs by Select Data, etc. to select all cells including the new data. This worked flawlessly in Excel 2003 but does not...

Thanks, that worked. One more report issue: My data source for report is "SELECT * FROM [tbl_events] WHERE [xdate] between [From] and [To]. The report has a text box where Control Source =...

I have one date field that is set to Now() in order to populate automatically when the user enters a record. The report should display both a short date with yyyy, e.g., "6/20/2012" and a time...

Works like a charm. Thanks!

I would like to format cells in columns A, B and C if the value of cell D is "x" -- I have been unable to find a solution using conditional formatting. Is conditional formatting capable of such...

I checked References, did not see anything MISSING. Could my workstation copy of Access be corrupt? Any other ideas I could pursue?

Reports and subreports that have worked well for years recently began asking for parameters when encountering text boxes that involve either Date() or Right. E.g.,
=IIf([stepdue]<Date() And...

I have an Excel file in which tabs for worksheets disappear when one large worksheet is selected. This problem does not occur if other sheets are selected (using the worksheet listing), and I have...

This discussion is cause for optimism as I am pondering moving from Windows XP > 7 and from Office 2002 > 2010. I assume from comments that it is reasonable to move forward.

I am using Access 2007 to open a 2002 database. My report has a toolbar created from a macro in order to print or email the report. Converting macros to toolbars does not appear possible in Access...

That worked! thanks.

How do I move a single field in an Access 2007 report? When I drag one down or over all fields move.

Instead of surrounding the entire string in quotes, you must place quotes around each value.


Private Sub cmdListBox_Click()
'Dim strSQL As String (this variable is established in a standard...

I am using a multi-select list box and the code below to generate a report with records meeting the selected criteria, i.e., the selections made in the list box. The report opens but includes all...

I used to be able to add pictures to reports in Access 97 or 2000 by:

add field (OLE object type) to table,
insert picture into field using Datasheet view:
Insert Object, Create from file,...

That's the answer. Thanks.

I'm not familiar with variation in quotation marks. How does one find/create either?

1. What is the limit to the number of nested IIf statements in a calculated query? Is there a limit to the number of conditions within an IIf statement?

2. I am getting the following error...

MS site says Access 2007 is a prerequisite. Will this actually work with Access 2003?

I have Access 2003, not the developer edition. Do I have to buy Visual Studio in order to create a database that can be run without MS Access? If so, can you be specific re edition, etc. of Visual...

File attached

I had not. However, I have now shrunk everything in sight in report and subreports. I also changed Group property for Keep Together to With First Detail (had been Whole Group on subreports). ...

I had not changed CanShrink properties, but after doing so for GroupHeader0 and Detail, there is no change--still a lot of white space. One other unexpected result--Goal-related fields and label...

That worked, thanks. Now I want to eliminate as much white space as possible in the Detail (Objectives) and GroupHeader0 (Goals) sections. I tried the following code without success.

Private Sub...