Another example of why this is the best programming forum on the web!!!
It works perfectly, thanks so much for your help.
Regards
Adrian
AdrianJ1980
Last Activity: Mar 31 '08, 09:46 PM
Joined: Dec 17 '07
Location:
-
Open Word Document from Filepath in Table
Hi all,
Apologies if this has been discussed before, but my numerous searches (google and otherwise) have come up with nothing.
What i need to do is open a word document (from Access 2003), from a filepath stored in a table, depending on the values returned in 2 combo boxes on a form. This is what i've got:
...Code:Sub Run_Letters() Dim strPath As String Dim strSQL As String
-
Visual Basic Basics
Hi all,
Can anyone recommend to me a good website as a basic VB resource?
I've always just copy and pasted code, but i really need to learn it better ie what is the Dim for!!
Thanks in advance
AdrianLast edited by Killer42; Dec 19 '07, 12:54 AM. -
It's easy to do in a report through the properties menu as per http://office.microsoft.com/en-us/ac...873881033.aspxLeave a comment:
-
I find Access charts annoying and hard to use. I suggest exporting your data to excel and charting there.Leave a comment:
-
I don't believe the Linked table can be updated ie it can only contain data from what it is linked to.
If you put the linked table data into another table using a make-table query, you can add/update that without affecting the original sourceLeave a comment:
-
Have you configured the ODBC links on you desktop?Leave a comment:
-
Access - Split Memo Field into multiple rows
Hi,
I apologise for not providing a code basis for my question, but i really am stuck.
Does anyone know how i can split a memo field, such as below, into separate records. (The data comes from the body of daily system generated emails that the database is linked to)
Single Field:
AUS 123 $450 $396 -4 N
AUS 456 $2560 $2860 300 N
AUS 789 $987 $2 -985 P... -
Hi,
I've used the attached code in a database i made ages ago - i can't remember where it came from.
...Code:Private Sub RunMergeLetters_Click() Dim strPath As String Dim strDataSource As String Dim conTemplate As String Dim conQuery As String Dim doc As Word.Document Dim wrdApp As Word.Application conTemplate = "Confirmationletter.doc"Leave a comment:
-
Hi Chris,
I can't tell you how to do it exactly, but i've seen threads that relate to sending emails from Access and Timers, for example:
http://www.thescripts.com/forum/thre...ess+email.html
and
http://www.thescripts.com/forum/thre...er+access.html
Sorry i can't be more specific...Leave a comment:
-
Hi,
Not sure about access - server connections, but you might be able to use File/Get External Data/Link tables to find the server data, if that's what you want.
As far as a backup, i only know of two ways.
1. Just take a copy of the database and put it on a flash drive
or
2. Create append queries to copy you data to a different databaseLeave a comment:
-
Hi,
Did you ever figure out how to solve your problem?
I've got the same issue with a table linked to an Outlook email folder. The body of the email is in a single memo field that i'd like to split.
Thanks
AdrianLeave a comment:
No activity results to display
Leave a comment: