Search results for query: *

PVS Thanks for your help. It works fine now that I added the reference.

I do not know a lot about VBA coding. but here is my problem: I have had an Access 2003 DB and am using it to send emails to clients using fields from the form with code adapted from a tutorial found on this site. I am trying to upgrade to Access 2007. If I use Access to open my old database in...

Thank you Remou. It worked perfectly

Using the code in the FAQ section I have successfully created a button which sends an email with attachment. I also want to change the properties of the outgoing email to have it automatically request a read receipt. I have searched this forum and others and have been unable to find code...

That's where i have the difficulty. I don't know the code to call the subroutine. I can write the combo box so that it stores the name of the procedure in a field, but I don't know where to go from there. Any suggestions on the code? I am not a programmer so I am easily confused.

I am using my database to open Word files from a template and fill in the various Word fields. For each word file I have a command button to call the procedure for that file. As my list of Word documents grows, I am accumulating many buttons on my form. I would like to create a drop down list...

I am using active x calendar control to update a date field. I have the field formated as a long date - so the information on the form appears as Wednesday, May 11, 2005. I am sending the field to a word document created by a template. However, the date in the word document appears as 5/11/05...

I am very new to this, so any help you can give will be appreciated. I am trying to display info page by page where the records selected are greater than a user inputted value: I have tried to adapt a code snippet I found but can't get it to work properly. The first instance displays properly...

I have created a table in my website database named Events. I made a date field named End_date to indicated the last date I want the row associated with that date to display on my page. My code to perform a select of all table rows (listed below works fine. However, I have tried many ways to...

Thanks, it was the permissions,which were reset. I fixed the problem by deleting the database from my XP computer. I copied a backup of the database to a Win 98 computer, compacted it and then copied that database to the XP computer. Probably not the best way to resolve the issue, but it worked/

I have a database one computer running WindowsXP. Two other computers were accessing this database without problem. I compacted the database and now the other two computers are unable to access the database. What did I do wrong and how do I fix it? Any help will be appreciated.

Using a lot of help from others, I developed my own database which when I click a button opens a Word file from a template. Access then sends field values from a form to the newly created word document using custom field variables in Word. This worked fine for several years under Windows 98. I...

I did this by inserting a text box in the header and then placing the clipart in the text box.

Try this: Click view header / footer put your cursor in the header and click insert text box put your cursor in the text box and click insert picture place yoour clipart in the text box and it should work

This site: http://www.helenfeddema.com/ Has code samples to accomplish this. Also includes instructions and a sample db. I used the code to open word from a template and populate the fiels from the active form in access.

That did the trick. Thank you for your help.

I am teying to test to see if a directory and sub directory exists on my C drive and if it does not then create the directory using the variable Me.FileNo as the name. The Mkdir function works and the directory is created as expected when I run the the procedure the first time. The problem is...

This site: http://www.helenfeddema.com/CodeSamples.htm Has an example of how to import a word table into an access database. I don't know if it will help but take a look.

I have very limited knowledge of vba. I amtrying to check and see if a sub-folder exists on my c drive and if it does not then create one using the variable name FileNo. The first time I run the procedure it creates the file as it should. However, if I click the button again I get this error...

Try This site: http://www.helenfeddema.com/ It provides code samples and sample database for accomplishing opening up word from a Template and inserting the fields from an access form into the word document.