Search results

how would you take a form created in access 2007 and email it to someone using Outlook 2010 so that the person receiving the form can fill it out and send it back and then have the data imported into a table in access 2007? Thanks.

I think I found the answer here: http://www.fmsinc.com/MicrosoftAccess/Controls/mscomctl/ We are going to make the changes and test. Don't go away because I don't know if this will work yet. LOL

Maybe, but the other code works. It is just the Treeview1_NodeClick event that does not work. Where do I set the trusted location at?

I have a treeview that when I click on one of the nodes the event is not firing. Actually, nothing happens. I don't have a clue as to where to start. I am using Access 2010. Last time I worked with it everything worked fine. Now it has been released to the public and now I have the problem...

I have an Access 2010 database that uses a login form that has a button that direct the user to another form. When I click on the button code is executed and I get the error "The OpenForm action was conceled." I followed the execution to a utility that is called during the opening of the...

When I try to view it in design mode the only choices are for pivot tables. I don't know if that helps.

I get the same error. Thanks.

Here is my query: SELECT tblPl_Employment.EmployerName, tblPl_Employment.Union, tblPl_Employment.Local, tblPl_Employment.LocalCity, tblPl_Employment.YearFrom, tblPl_Employment.YearTo, tblPl_Employment.JobTitle, tblPl_Employment.JobDuties, tblPl_Employment.BechtelSite...

I know that this should be very elementary but I can't get it. I need to combine two fields, first name and last name, into one field. How do I do this? I have tried fname + " " + lname and fname & " " & lname. Neither one works. Thanks.

WOW!! Thanks! You were right, the error went away.

Thanks for the tips. I will put them to use. I did not create nor did I convert this database but I am tasked with making the changes. Here are the declarations for the global variables in question: Global g_db As Database Global g_rs As Recordset

Here is what is happening: We are moving to Windows 7 as a company so the database had to be converted from Access 2003 to Access 2010. Public Sub PlaintiffSummaryToWord() Dim conAdo As New ADODB.Connection Dim rsADO As New ADODB.Recordset Dim objWord As Object Dim blnDoTableHeaders As...

I am not an Access programmer but I have been asked to make some changes to an Access DB. I need to open a Word template and populate some bookmarks on the template. I have found code to open the template but I can't get it to open. I get the error: "Type mismatch". Here is the code...

Ok, I did a little test where I recreated the sub and just added a few lines and then ran it. I kept doing this until the error message popped up. It turns out that the problem was an array and not the sub itself. Thanks for your help and sorry for the inconvenience.

Call to the sub (this code resides in the form): PlaintiffSummaryToWord Sub (this resides in a module): Public Sub PlaintiffSummaryToWord()

I have already done that but thanks.

I'm sorry but I forgot to mention that it is in a module.

I have been given the task of reinstating a subroutine that had been removed in the past. The actual subroutine was deleted but the call to the subroutine was commented out. Now, I have rewritten the subroutine but can't get it to run because when the process gets to the subroutine it throws...

Sam, Thanks for your response. I tried it but unfortunately it didn't work. Do you have anyother suggestions?

I have an old access 2003 db (windows XP) that I am converting to access 2010 (windows 7). In the frontend I have a connection to an old SQL Server 2000 database. I need to recreate the connection from the access 2010 to the SQL 2000 server. Here is my connection string...