Does anyone know what might cause intermittent data retrieval problems on a
Microsoft Terminal Services system?  The Access 2003 runtime is installed
and the app is an MDE.  We are using a UserDSN ODBC connection to a SQL DB.
Sometimes all of the data will populate the screen, ...

I have a validation rule that says 0=No, 1=Yes. On the form, I made it into a
checkbox. Everything seems fine except that it when I do a query or when I
actually look at the table, 1 (for yes) shows up as -1. What am I doing
wrong? I can't have a negative value to do analysis.

Does anybody know how to set up windows mail in vista?
Thanks,
Bryan

I know you can get the Access developer extentions with Visual Studio
2005.  I have a couple questions:
What do I have to get to have all the tools needed to package and
distribute an Access 2003 solution?

I made a crosstab query that calculates the days of the week that our
students are on campus, and the activities they complete. Now I need to
average the activity for each weekday.  Any Advice?

I am migrating the data and queries from an Access 2000 database over
to SQL Server, and am trying to save time by not rebuilding all of the
business logic that has been built into Macros, Forms, and Reports.
While executing one of the scripts it comes back with the following

I have two fields; one for [Date] the other for [Time]. Unfortantly the
fields were imported as "TEXT" since there were all formsts of entries made
(i.e. &PM could be any of the following: 700, 7:00; 19:00, 7PM, etc...). We
now need to do some calculations of these two fields. I ...

I have a form that comes from a query listing all finance contracts a client
has. These are displayed in datasheet view. All the contracts have a unique
reference number displayed in the datasheet. I want users to be able to click
on this reference number and it to open up the ...

I have an adp front end (Access 2002) connected to SQL Server (2000). I am
creating various views and SP’s in SQL Server. One manner of authentication
to SQL Server is through my windows logon. The other is with SQL Server
itself. My question is, are there any advantages to ...

Have been asked to make some minor mods to A2000 on Win98...and it is not
possible to do so on the machine itself due to location/security/etc...
I have A97 on Win98  and also A02 on XP.... (and 03 and 07 but presume they
are not revelevant)...naturally the one thing I don't have ...

I have an Access 2000 DB that many users are logged onto and they dont
log off when they go home. This means I cannot make changes to the DB.
I have seen ways of adding code etc to kick people out but I cannot do
this obviously. How can I kill the DB and kick out all the users. Can

I have seem one other post that suggest Access code for removing the Outlook
waring message when the Send Object Macro is used. I want to use Task
Schedular to send my reports using the macro at 6pm nightly. Since this will
be automated, i need to get around the Outlook warning ...

Has anybody use Microsoft Access as a Business Intelligence solution?  We
have an ERP system that we use but there is no BI solution for it.  I would
like access to be our database query, analyze and reporting tool.
I've never done this so I wanted to see anybody has any tips on ...

william le santo
35 kennedy close, po7 5ny
011939435900
22/4/08

I have a report listing body measurements by date. So i would like to
compare, for example, Body Weight from the most current measurment with Body
Weight from the last measurement and compute the difference then display that
on my report (or use the latest Weight value and ...