Search results

I'd like to create a recordset that is NOT based on a table or query, but rather an array of values. I would love some assistance by way of code because I have always struggled to understand how to use arrays. Here's what I need to do. User inputs a Begin Date and an End Date into a form. I'd...

I need to write a procedure dynamically create a new recordset with one column called "Dates" to use temporarily. I want to fill these values with the dates between two user entered dates. For example, Begin Date=7/1/2011 End Date=7/15/2011 Create new recordset now containing one column...

I searched the forum for an answer, but only found a partial solution. I have a flyer (access report) that I want to print an advertisement ONLY on page 1. But there is another graphic in the page footer that needs to print on ALL pages. I have made the ad image invisible on page footer format...

Does anyone have code that saves an access report to a pdf file using the Office 2007 add-in from this page: http://www.microsoft.com/downloads/en/details.aspx?familyid=f1fc413c-6d89-4f15-991b-63b07ba5f2e5&displaylang=en Any assistance greatly appreciated!

How do you get the Packaging Solution for 2007 to upgrade a database you've deployed without requiring the user to uninstall the old version first? Sorry if this is a repeat question. I did a search and found some comments, but not exactly what I was looking for.

I'm using late binding vba code to send an automated email. The reason is that 2 of us use Access and Outlook 2007 and the other 2 use Access/Outlook 2003. Therefore when the database is opened on a 2003 machine, the reference to Outlook 12.0 Object Library gets broken. We are a non-profit...

I've used the Package Solution Wizard to create a Windows installer package for an Access 2007 database I created. I think I did everything right. But when I run the Set-up icon, I get this message and it just hangs there: I googled it and people are talking about doing a silent install via...

I swear I just posted this but it is not showing up. I'm hoping someone can refresh my memory on how to extract data from records selected on a form. For example, if a user selects 4 records on a form, what is the vba to loop through those records and store data in specific fields in variables...

Below is some code that contains a SQL statement to run on the OnClick event of a button. When copying the SQL statement produced by the "stSQL" variable, and pasting into the SQL view of a new query, I get results just fine. But I keep getting error 2342: "A RunSQL action requires an argument...

Does anyone know how to make columns on a continuous form? Just seeking a simple column break to create two columns instead of one single scroll down continuous form. Thanks!!!

I want to add a text box to a form for each record in a table where [boolean]=true in a particular field in the table. I also want to assign the value in another field in the selected record to display as the label caption. I already have written code to loop through the records in the table...

I'm trying to highlight dupe rows in Excel '03. In column Q I have concatenated all of the cells I want to check. For example, an entry in cell Q1 might look like: John Doe 300 Whit Drive Pittsburgh PA 00001-5235 To highlight dupe rows of data, I am using condition formatting with the the...