I have a text file that I am importing into an Access table that was
generatred from data exported from a Word file. Several (about 20-30)
fields are from check boxes on the Word form. These fields have either
0 (Not checked) or 1 (Checked). Due to requirements from a third party

TesterQA is a Leading Software Testing site
www.testerqa.com is a leading testing information site contains Latest
testing news, articles, tutorials, quiz, jobs, blogs and much more
Designed to make working with TesterQA as easy as possible, there is

Can someone show me an easy code snippet to help update a table based
on DDE data.  Here is the "jist" of what I am trying to do..
1. Get stocks/options symbols from portfolio management systems
(complete)

Anyone know how to calculate the difference between two times
displayed in two textboxes?
I'm starting out with two textboxes: "txtCallTimeBegins" &
"txtCallTimeEnds"

Is it possible to update a spreadsheet from excel to access once it
has already been imported from excel.  I imported the spreadsheet and
then made some changes can I update this in access?

I already tried the outlook newsgroup but no luck. I'm exporting outlook
emails to Access format and import them in Access. It works well, but
Outlook doesn't export the time and date of the messages. Any ideas on how
to accomplish that?

I'm new to relational DBs and I'm trying to learn.  Just curious if
anyone has any suggestions on what I should be reading or taking a
class in first?  Essentially, I'm looking to utilize Access to set up
a work management system.

Good afternoon,
I am having troubles with an insert into statement in Access 2002 that
I am performing through VBA. I am inserting a single record into a
table with one yes/no field. For some reason, I cannot seem to set the

I'm trying to fix a glitch in a complex access database, and have a
fairly complex problem... unless there's some obscure easy fix I don't
know being fairly new with Access.  Basically, the area I'm trying to
fix includes a form which takes entered data, concatenates it into a VB

If someone has created a database for me and transferred it over is
there any way that I can check I have full access to all areas?
I am a beginner with Access and so the development has been done by a
temporary employee who has now handed the database over to me. Not

Morning all,
I've got an Access database running on a network at work. The current file
size with 3 months of data is 251mb. How large should I let the database get
before I start achieving previous months ?

i would like to know what can make the file to be bigger sized,is it
becouse of the queries or becaouse of the tables?

I have created an Excel spreadsheet that has a lot of data.  What I
want to do is import the spreedsheet to Access and create a form so
that I can print each row per page in a proffessional manner.  The
problem is that whenever I import the data to access my dates show up

I am creating a wizard so a user can import data from other type of
databases (DBase IV, Paradox etc...) into an Access mdb.
The first step would require the user to choose the type and path of
database.

I hope this isn't too confusing.
The following query runs pretty fast by itself, but when I want to use it in
a report (pasted below the query), it takes at least fifteen seconds to run!
Then I want to analyze the query in Excel and I have to do some manual