Search results for query: *

I have a pretty extensive contacts list with custom fields and lots of filled-in and edited data. I have several hundred contacts. We are trying to send more encrypted email and now I want to update as many contacts as I can with their certificate. I cannot figure an easy way to do this...

Unable To Select (Highlight) Selection In Word I have a few procedures where I am trying to select a range. For some reason i get a valid selection object, but the selection does not "select". I get no highlighting of the selection. Example Private foundRange Public Sub...

I am using the Access Northwind database to teach myself ADO.net and building a VB database. I am using strong typed dataset. I have an orders tableadapter and the wizard generates the following updated command text. UPDATE Orders SET [Employee ID] = ?, [Customer ID] = ...

I am new to working with ADO.net - I am using an Access database to hold my data - At run time I create a dataset and can populate my data - One of the datatables in the dataset is named "tblEmployeeHours" - I have a dataadapter called "daEmployeeHours" that is used to fill the datatable - I...

I have checked past threads on this, and googled it but could not find an answer. I thought I remember seeing a post with a solution. I am Looking for a way to open some external databases and bypass the startup form or autoexec. Most of my dbs open with a dialog startup form. I found this...

I am automating Word from access and then run a procedure in the word template I would like to do different things if the template is opened manually or automated from Access. The code works but not both ways. What I would like to do is if the user manually opens the template it will run the...

Amatts, I can not post to the original thread. I get a cold fusion error. So here is the answer to the Thread "Input To Seed a Random Picker" I am a little confused on the thread because I wrote the original code cited. The whole purpose of the code was to avoid getting the same random...

How do you add a multi line text into a Word table cell? I am doing something like ... .Cells(1).Range.Text = "Some text" & vbcrlf & "some other text" ... Instead of vbcrlf I tried Chr(10) & chr(13). In both cases the text is written but no multi line. Thanks.

Here is my code for establishing an ADODB connection from a word document Public connMain As ADODB.Connection Public Function EstablishConnection(strDBName As String) '***************************************************** ' Purpose: Open ADO Connection ' ' Assumptions: Called from Sub Main '...

Hello everyone, I am a hobbyist, and have been developing Access applications for years. Relation db theory and design and development is not a problem. However, I have never worked with SQL server and want to teach myself. I have downloaded SQl Server Express 2008R2. I think I have...

Saw a post asking how to send Access attachments as attachments in an email. I did not know much about attachment datatypes so I read up on this to come up with a solution. I did not think this was a commonly known solution so I am posting here. If there is a cleaner way please reply...

I have an multi user access database that uses linked lists to sharepoint. Been using it for almost a year with no problem. Actually works better than I thought it would. Today one of the linked lists/tables returns the error message: "The Microsoft Office Access Database engine cannot find...

This keeps on being asked on this site, and many people (including myself) appear to not be aware of this new capability in 2007/2010. Access 2007 introduced the ability to render in a continous form images stored in external folders. The image control now has a control source field, which...

I am trying to read through a Word document and create a user defined collection of the sentences that have revisions. Public Function getChangedSentences(theDoc As Document) As Collection Dim snt As Range Dim colTemp As New Collection For Each snt In theDoc.Sentences If...

I am running an A2007 database. The backend data are Sharepoint lists. Is there a way programatically determine if working online or offline? I have provided features to allow the user to shift between modes, but would like to prompt them when offline if they want to synchronize or go online...

A user posted this thread702-1588743, which lead to a discussion on dynamically creating pop up menu bars to use as a data controls. I have never seen this asked, or discussed, but it works so well I was wondering if anyone does this regularly and if there are any drawbacks? You can do some...

I have a replicated database where the primary key is an autonumber and random. I have limited access to the backend structure (i.e. adding fields). So is there a way to determine the last record inserted into a table without an increasing autonumber or date time stamp? Thanks. Thanks in...

I am helping someone in thread705-1575770 They have a bunch of concrete columns, in groups and placed in sequential rows. Then they want to do some interpolation. I can do this in code, but I was thinking a sql solution would be more reliable. I am not very good in my SQL. Lets call the...

Mitch, I have created a new thread from your thread702-1516577. Your thread is now really a table design question/s. More importantly for some reason that post does not show up in my "My Replies", and it was getting painfully long. -----------------------------------------------------------...

I built a DB in 2007 and have some 2003 users. One of the user's had the code fail on a vb function (i.e "left"). That tells me that the reference to vba is bad. I know the normal fix is to uncheck the reference and then reselect the reference. The problem is it will not let me uncheck the...