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 thought about that but I totally suck at arrays. Can you help with some code perhaps?

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...

Thanks... they want the ad at the bottom of the page. I already have a graphic in the report header that goes at the top.

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.

Good strategy. I just might steal it!

Thanks pbaldy. I say that because a lot of the things I have read about this discourage late binding. But what is one to do when it's the only option :)

No. It's a packaged application. Why do you say that?

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...

Thank you very much!

Thanks... I'm familiar with looping through dao recordsets. I think where I'm stumped is much more simple. How do I identify just the records that the user has selected and create a recordset out of those records? Is there some property or method that identifies selected records on a form?

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...

Oops, I forgot about that. Been a while since I did access vba! Thank you!!!!!

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!!!

That makes total sense and I feel kind of stupid for not considering that, but at the same time it's a bit complex. Then again, I tend to complicate the heck out of things that can be really simple. I'll try your suggestion and see if it works out.

Thanks DJ. I appreciate your feedback. I know access isn't the best place for this, but it's really the only way I can think of without having to change the form design every time we add a new "Info Site". Here's the scoop - we have a field that identifies a contact as a member who pays for us...