How to link fields in MS word document to Access database
Anyone have experience in linking fields in an MS Word document to an
What I am considering doing is taking an existing fill-in-the fields
word document, for which I cannot now save the data, and allow it to be
opened with no data, have the fields filled in and then save the data in
an Access database. I also want to later select the document (from a
file in the database), open the word document and populate the fields
from the database. Of course if there are then any updates I want to
put them back into the database.
Anyone with sample code?
On Jun 10, 6:21=A0pm, Bob Alston <bobalst...@yahoo.com> wrote:
> Anyone have experience in linking fields in an MS Word document to an
> access database?
Instead of Word documents I use RTF-documents. RTF-documents act just
like Word documents in Word. The difference is that RFT-documents are
plain text-files, and can easily be processed in Access to find - with
the appropriate placeholders - the filled in information.
> What I am considering doing is taking an existing fill-in-the fields
> word document, for which I cannot now save the data, and allow it to be
> opened with no data, have the fields filled in and then save the data in
> an Access database. =A0I also want to later select the document (from a
> file in the database), open the word document and populate the fields
> from the database. =A0Of course if there are then ...Forcing a New Line in a Text Field in MS Access using VB
I feel I'm beating an old horse to death with this question but I
can't get around the problem.
I want to update a text field on a form with a string from a VB
module. I need enter/linefeeds in the string.
Chr(10) & Chr(13)
Chr(13) & Chr(10
none of which seem to work.
I've set the properties for the text box to [Enter Key Behavior] =
'New Line In Field' and [Can Grow] = 'yes'.
At the moment, my code looks like this:
celsql = celsql _
& "Program: " & encname _
& vbCrLf _
& vbCrLf _
& "Start Time: " & sttim _
& vbCrLf _
& "Participants: " & numpart _
& vbCrLf _
& "Confirmed by Curator: " & cbc _
& vbCrLf _
& "Client: " & clntnm _
& vbCrLf _
& "Contact: " & cntct _
& vbCrLf _
Forms(frm)(bts) = celsql
If I toss this string into a [MsgBox], it comes out fine. It's just
something about the text field...
I'm working in MSAccess 2007, but need it backwards compatible to
I'd really appreciate any advice.
I've seen this type of problem before, but I typically just use a
separate text box for each data field. Is there a par...Create MS/ACCESS database app for non-ms/access users
Is it possible to create an MS/ACCESS database application and package
it for users who do not have MS/ACCESS loaded in their PCs?
I was told that this is possible, but I don't know what software is
needed. Do you know? If so, please answer this post. Thanks.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Per Sue Bricker:
>Is it possible to create an MS/ACCESS database application and package
>it for users who do not have MS/ACCESS loaded in their PCs?
>I was told that this is possible, but...HELP! Retriving field names and properties from MS Access database using ASP
I have a really frustrating error and need help.
I’m trying to do a function that gets the properties and names
of the fields in a MS Access database using ASP. I haven’t
programmed in a while so I’m quite lost.
Once I have the my database structure I will insert the corresponding
fields from a web form but the database is huge and I want to be able
to change the database and form without changing the ASP code all the
This is my function that is not working yet. I cant seem to connect
properly to the database...
...Create date field from substring of text field
I am trying to populate a field in a SQL table based on the values
returned from using substring on a text field.
Field Name = RecNum
Field Value = 024071023
The 7th and 8th character of this number is the year. I am able to
get those digits by saying substring(recnum,7,2) and I get '02'. Now
what I need to do is determine if this is >= 50 then concatenate a
'19' to the front of it or if it is less that '50' concatenate a '20'.
This particular example should return '2002'. Then I want to take the
result of this and populate a field called TaxYear.
Any help would be greatly apprecaietd.
Assuming both RecNum and TaxYear fields are in the same table, you can use
this script to populate TaxYear:
set TaxYear = case
when SubString(RecNum,7,2) >= '50' then '19' +
else '20' + SubString(RecNum,7,2)
"Mark" <markcash@Hotmail.com> wrote in message
> I am trying to populate a field in a SQL table based on the values
> returned from using substring on a text field.
> Field Name = RecNum
> Field Value = 024071023
> The 7th and 8th character of this number is the year. I am able to
> get those digits by saying substring(recnum,7,2) and I get '02'. Now
> what...Converting a text field to a date field
I need to convert a Text field containing both auto and manually entered
dates over to a Date field. The records that were autoentered move over
without a problem. But those that were edited or entered manually using a
two digit year do not. For example: 1/25/02 converts to 1/25/1902. Is
there any workaround to solve this problem short of manually correcting the
date(month(DateField), day(DateField), year(DateField)+100),
This will obviously take any year before 1920 and add a century to it.
If you might legitimately...MS Access Memo Fields
I am a novice at Access (2002) and I need some help. I want to use a
query to interrogate a memo field which contains the body of an email
but despite help with the syntax etc. I can not get it to return any
Can anyone tell me if there are limitations using queries on Memo
fields? For example, do they just look at the first 255 characters,
all the field contents or just not work at all
The query I am running is:
WHERE ucase(Emails.MessageTxt) Like '%BUY%' Or
ucase(Emails.MessageTxt) Like '%SELL%'
ORDER BY Emails.[Message#];
I was also unsure whether the Like function is case sensitive
<firstname.lastname@example.org> wrote in message
> I am a novice at Access (2002) and I need some help. I want to use a
> query to interrogate a memo field which contains the body of an email
> but despite help with the syntax etc. I can not get it to return any
> Can anyone tell me if there are limitations using queries on Memo
> fields? For example, do they just look at the first 255 characters,
> all the field contents or just not work at all
> The query I am running is:
> SELECT Emails.*
> FROM Emails
> WHERE ucase(Emails.MessageTxt) Like '%BUY%' Or
> ucase(Emails.MessageTxt) Like '%SELL%'
> ORDER BY Emails.[Message#];
> I was also unsure whether the Lik...Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
Would it be possible to migrate the MS Access 2000 to MS SQL Server
My application is using MS Access 2000 as database and as user
interface such as forms. Now, I want to migrate the backend database
from MS Access 2000 to MS SQL Server 2000. However, I want to keep the
MS Access 2000 interface. Would it be possible?
If I migrate the MS Access to SQL Server, would the queries, back-end
VBA, macro, tables and forms be affected? Do I need to change the MS
Access data type to SQL server supported data type?
Which tool I can use to do the migration? Upsizing wizard or exporting...Accessing text form fields name=field[label]
and changing those examples to suit my needs. That said ....
..... I have some select fields in a form I created for a database search
that I am unable to figure out how to access. (The search is
implemented in Php/MySQL.)
The user enters search values for: name, address1, city, .... etc.,
..... and for each of these they also select whether the search should
look for the field to be equal to, not equal to, Like, or Not Like the
value in the database.
So in the form I have:
<input type=text name=city>
in combination with
<option value='!='NOT LIKE>NOT LIKE</option>
For an example, this search could be to find an entry "WHERE city
$func[city]] $city. (Php - e.g., WHERE city = 'Denver'). This works
fine - in Php. I use similar combinations for name, address, etc., ...
selected indexes for the "func" fields (func[name], func[city],
func[state], ...) using a loop that goes through the associative array,
"func." I cannot find the right syntax to address them as an array and
I am beg...Change table date/time field to text field in code
How can I programatically, take some Date/Time fields present in a table in
the current database and change their type to text?
You can alter the column type by executing a DDL query.
Dim strSql As String
strSql = "ALTER TABLE MyTable ALTER COLUMN MyField TEXT(20);"
DBEngine(0)(0).Execute strSql, dbFailOnError
I'm having difficulty imagining a scenario where it would be a good idea to
use a Text type field to hold date/time data though. The approach would
unleash a plethoria of issues, with criteria, sorting, date math, invalid
entries, inter...MS Access Memo field question?
Hi I was wondering is it possible to read write to a memo field in ms
access, the same way you would read write to a text field? I have my
database set up and reading writeing to the databse ok using text field
but I have to now store strings which will contain 316 characters e.g
I need to do it beacuse Im encrypting ever thing in the database,
Thank if you can help
...Reading in a binary field from MS Access
I am using ActiveX controls to query a MS access database and read
the results into a Matlab cell array. When I try to read in a binary
field (i.e. a field that has been set to 'Ole Object') Matlab
automatically assumes it is uint8, and makes the conversion. How can
I tell Matlab to treat the incoming binary data as uint32, which is
the original format?
...SQL Server View integer field shows as text field in Access
I have an SQL Server View where my field in the view is an integer
field and works well. When I link to it from Access, the field is
defined as a text field in Access.
Does anyone have any idea why this is happening or how to fix it?
Thanks in advance!
On Sun, 3 Aug 2008 20:31:43 -0700 (PDT), kevinfbutt
That's quite unusual. Can you post the SQL for that field in that
What version of Access and SQL Server? Fully patched?
Can you replicate the problem with a view in one of the SQL Server
Microsoft Access MVP
>I have an SQL Server View where my field in the view is an integer
>field and works well. When I link to it from Access, the field is
>defined as a text field in Access.
>Does anyone have any idea why this is happening or how to fix it?
>Thanks in advance!
Is the column in the view the result of a calculation? If so, try applying
the CAST or CONVERT function to coerce the result back into an integer.
"kevinfbutt" <email@example.com> wrote in message
> Hi All!
> I have an SQL Server View where my field in the view is an integer
> field and works well. When I link to it from Access, the field is
> defined as a text field in Access.
> Does anyone have any idea why this is happening or how to fix it?
>...MS Access Primary Field on form lookup
I am creating one of my first databases and definetly my first in
Access 2007. This might not be possible but here it goes. I have
several maintenace forms I need to create. Each of these forms has a
related table with a primary key. One of these tables is a "Customer"
table with the primary key being the "CustomerCode"
On the form for data entry I would like to have the "CustomerCode" do
1) Have a lookup so I can easily go to what ever customer I choose
2) If the user enters a Customer Code that is not in the system then
the form automatically
knows this is a new record, clears the old data from the form and
allows the user to enter
the new record.
3) User enters a Customer Code that does exist then the record is
retrieved for viewing and
Am I asking to much from the system and is this even possible. Any
The Combo Box Wizard gives you options that do what I think you are asking
for. In the Controls toolbar be sure you have the "magic wand" icon
selected, then click on the Combo Box icon, move your cursor to
approximately where you want it on the Form, and click, then follow the
instructions in the dialog.
Microsoft Office Access MVP
"eighthman11" <firstname.lastname@example.org> wrote in message
>I am creating one of my first databases and defin...Autopopulating fields in a form, MS Access 2000
I have a table of about 6000 clients which have unique client numbers.
I am creating a data entry form to log contacts with the clients. I
want the client information (Name, Sales Rep, phone number, etc) to
autopopulate fields on the form when the client number is entered. I
have seen this done on another database I have access to, but have
been unseccessfull in recreating it. Can anyone point me in the right
you want to use Dlookup in an event procedure that runs after you update the
"lvroye" <email@example.com> wrote in message
>I have a table of about 6000 clients which have unique client numbers.
> I am creating a data entry form to log contacts with the clients. I
> want the client information (Name, Sales Rep, phone number, etc) to
> autopopulate fields on the form when the client number is entered. I
> have seen this done on another database I have access to, but have
> been unseccessfull in recreating it. Can anyone point me in the right
I would not be keen to do a dlookup after the even. For a start, you
only get 1 value back at a time, which may make for slow processing
when you have to get a lot of data back.
Try something like this
Client Number <after update>
dim db as dao.database
set db = currentdb()
dim rst as dao.recordset
set rst = db.openrecordset("select * from tblClientInfo wher...Inserting Date/Time into MS Access Database
I'm trying to insert a timestamp into an MS Access Database using the
Labview database connectivity toolset. However, I keep getting an
error saying that the parameter is in the incorrect format. I'm
using the "DB Tools Format DateTime String.vi", and it doesn't seem to
I don't have the answer to your question, but....
How did you get information to be written into MS Access from labview.
If you are using this function to create the date but using SQL to put the date into the DB, this is probably the cause of your problem, because the VI adds a header to your string which is removed later by the parser. If you want to use this date in an SQL command, you should build it yourself or remove the header.
As for roboticstudent, just look at the examples in the example finder to see how to interact with databases.
I tried it both ways. I tried using the format date/time into
string where it would return "11/7/05 8:22:34 PM", which I then tried
to insert in to the DB, but to no avail. I even tried various
formats, changing the order of the numbers, etc., but it doesn't seem
It would be easiest if you post your code, or at least an image of it.
Also, which error exactly are you getting? Is it possible you're trying to enter a string into a numeric field (for example)? If I define a date\time field in Access and then use Insert Data (with the LV format...what is equivalent of format(date) function of MS Access in MS Sql Server 2000
I am facing a problem with a sql what i used in MS Access but its not
returning the same result in MS Sql Server 2000. Here i am giving the
SELECT TOP 3 format( MY_DATE, "dddd mm, yyyy" ) FROM MY_TAB WHERE
The above sql in ACCESS return me the date in below format in one
Friday 09, 2003
But in Sql server 2000 i am not getting the same format eventhough i
am using convert function, date part function etc.
Please if you find the solution would be helpful for me..
If you field is a datetime, you can use the CONVERT function to conver...multiple conditions in a join, access doesn't like on (table1.field=table2.field and table1.field=table3.field)
Hi I have written the following query and am having problems with the
last outer join in ms access... it doesn't like the multiple
conditions that I have in there, if I have just one or the other its
OK but not both... and I have tried putting the second condition in a
where clause but then i don't get an outer join
i'm pulling my hair out on this one... i would be extremely greatful
for some ideas...
SELECT ro.thickness,ro.width,ro.grade,sum(ro.pcs) as pieces,
FROM(((NewOrders as RO
LEFT OUTER JOIN Grades as GR on GR.gradename=ro.grade)
LEFT OUTER JOIN thicknesses as t on t.imperialdecimal=ro.thickness)
LEFT OUTER JOIN GradeThicknessGroups as GT on
LEFT OUTER JOIN GradeThicknessGroupDetail as GTD on
GROUP BY ro.thickness,ro.width,ro.grade,
Order By ro.thickness,ro.width
my tables looks like this
ThicknessID (FK: [Thickness])
GradeID (FK: [Grade])
oops i left the where statement in.. r...text fields to memo field
Is there a way to combine text fields into one memo field?
This is an existing database. Some people in the database may have several
"contact" entries where they have a "note" in a text field. I would like to
figure a way to combine all the "note" fields for each person into one memo
"RR" <firstname.lastname@example.org> wrote in message news:<S6HRb.email@example.com>...
> Is there a way to combine text fields into one memo field?
> This is an existing database. Some people in the database may have seve...Inserting Date/Time into MS Access Database #2
I am using Labview 8.0. I am able to write the Date in MS Access but i am not able to read it through Labview. In my case i have to read the data where Start Date=02/10/2007 and End Date= 23/10/2007. I am using this command -
SELECT*From Table_Name Where Date between '02/10/2007' AND '23/10/2007'
but i am getting error -
Error -2147217887 occurred at Conn Execute.vi->Untitled 2.vi
Possible reason(s):Exception occured in Microsoft OLE DB Provider for ODBC Drivers: ODBC driver does not support the requested properties. in Conn Execute.vi->Untitled 2.vi
Please give suggestion to read the data.
...MS Access Query with Distinct Column field Selection
1. MS ACCESS COMBO LIST = JAN;FEB;MAR;APR;MAY;
2. DATA TABLE:
N1 | N2 | N3 | JAN | FEB | MAR | APR | MAY |
a1 | a2 | a3 | 1 | 2 | 3 | 4 | 5 |
b1 | b2 | b3 | 10 | 20 | 30 | 40 | 50 |
c1 | c2 | c3 | 11 | 22 | 33 | 44 | 55 |
3. COMBO LIST SELECTION = FEB (Parameter may vary could be any column
fields from JAN to DEC)
4. RESULTS TABLE:
N1 | N2 | N3 | FEB |
a1 | a2 | a3 | 2 |
b1 | b2 | b3 | 20 |
c1 | c2 | c3 | 22 |
5 Is this RESULTS table possible in MS Access along with the combo
> 1. MS ACCESS COMBO LIST = JAN;FEB;MAR;APR;MAY;
> 2. DATA TABLE:
> N1 | N2 | N3 | JAN | FEB | MAR | APR | MAY |
> a1 | a2 | a3 | 1 | 2 | 3 | 4 | 5 |
> b1 | b2 | b3 | 10 | 20 | 30 | 40 | 50 |
> c1 | c2 | c3 | 11 | 22 | 33 | 44 | 55 |
> 3. COMBO LIST SELECTION = FEB (Parameter may vary could be any column
> fields from JAN to DEC)
> 4. RESULTS TABLE:
> N1 | N2 | N3 | FEB |
> a1 | a2 | a3 | 2 |
> b1 | b2 | b3 | 20 |
> c1 | c2 | c3 | 22 |
> 5 Is this RESULTS table possible in MS Access along with the combo
You didn't specify how you wanted to play/display the data.
Dim s as string
...How to read MS Access Database Table Created Date
Hi, may need some help here. I am using Borland Delphi Dev 2006. I am
able to read the list of tables names in MS Access 2003 database using
ADOConnection1.GetTableNames, but I am trying to read the list of
tables with their created/modified dates, appreciate some help here
...Reading 1 Full Record All Fields From MS Access
Hi All - We bought the DB connectivity toolset awhile back, and I've pretty well gotten the Write functions down. I'm working on an application now that has to read 1 full record - and send 1 cluster of all those fields values back into my main VI.Looking at the examples in the manual they show how to load ALL the data from an entire database into a 2D array into your application, and specific data (1 record, 1 field) output. The first condition isn't viable, the DB is too big. And the second is a problem because there are a LOT of fields. I'd say about 80 fields defining upper and lower limits. This is probably bad db design, but thats out of my hands.I could use that second example, and just use a For loop incrementing the field to collect it all but that seems a bit too much. Has anyone had luck with a simple subvi where you submit a string - it searches 1 column, finds the string, then returns all of the field values?
I am not sure if this will be helpful, but let me show you what I am doing whenever using the access database.
I am using the tools from <a href="http://jeffreytravis.com/lost/" target="_blank">http://jeffreytravis.com/lost/</a>
With this you can use the sql query such as:
select * from <table name> where <field name> = '<value>';
It will return all the fields of the records wh...Need help locking fields. MS Access 2000
I am using MS Access 2000. I have a database that I use to keep weekly
attendance records. In my table, each record consists of the fields:
name, week 1, week 2, week 3, ect...(each week I add a new week field).
I use a yes/no button to place a checkmark under each week to indicate
whether a person was present (checked), or absent (no check). Here's my
question: Can I lock the previous weekly fields to prevent
accidentally checking or unchecking the box? For example can I lock
weeks 1&2, but leave week 3 unlocked for editing?
> I am using MS Ac...