I have a view I'm creating that is somewhat of a summary view.  The Bit
field it has no problem displaying as a checkbox, that's the way I have it
defined in the Table.  However, what about displaying Checkboxes for other
fields?  For example, I have a field called LastAction.  ...

I would like to retrieve the current users SQL group membership. What I want
is to be able to write code like:
If USERNAME is member of  POWERUSERS Then
            Do something

Access 2003 .adp application using an SQL Server backend database:
On the Data tab for a form, I have specified the following in the "Order By"
property: tblJusticeClientProgram.StartDate DESC
Problem is, this specification is not honored.  The Record Source is

Digging around I've read that the problem can arise on large recordsets at
server's cursorlocation.
Nevertheless even if treating a client cursor the problem still arised.
So I had to manually code a loop statement until the recordset's clone is

I have an MSAccess form in "continuous forms" mode that is bound to a table.
Records can be added, deleted and modified within the form but there is a
command box that allows the user to CANCEL.
Is there a way to use BeginTrans, ComitTrans and Rollback to accomplish this?

This is my first Access Project to develop, so I'm learning the ropes of
dealing with SQL Server. One thing that cropped up is that the "char" fields
seem to be filled with training blanks. On forms that's only "strange" and
an inconvenience, but on reports it can force extra rows ...

I have set up a table that contains the following fields
1. DateAdded
2. PageName
And I am trying to write a query that will pull back records for me where I

I am using Sql Server 2000 backend with an Access 2002 ADP frontend.  My Sql
Server UDFs appear in the Queries container in Access, but I can't find how
to call them.  I am trying to call a scalar function to which I pass a date.
I want to assign the result to a control on the form.

Good morning,
To get computer name I use HOST_NAME()
Is it possible to get the windows login through a sp or udf?
Thanks

I'm using an access project to view data from a Sql Server database.  Is
there a way to save the changes I make to the datasheet view (like column
width, order, sorting) in the adp file?  It used to ask me if I wanted to
save changes when I closed a table but it doesn't anymore.

I have a report in a 2003 ADP (SQL Server Backend) that I need to
enlarge the font size to 272.  Access limits the font size to 127.
Does anyone have a work around that I could use?
Thanks in Advance

I need to develop an ADP file that can print a few different reports.  The
one that I am having difficulty with now is a contact page that prints a
person's picture and name below it.  I have my pictures on a server and a
link to the location in my SQL Server database.  All of ...

Sofar I have used SQL 2000 developer edition. So I was pretty happy that MS
jumped on the freeware train and gave us SQL 2005 Express Server.
In my opinion it has just just the same key feature as the SQL 2000
developer edition: for developers (simple applications) to use on one ...

I would like to highlight the current record in a continious form in an ADP
database.
I found some solution for *.MDB but they are not working in ADP (recordset
findfirst not supported in ADP).

Using Access 2003 ADP linked to SQL Server 2000.  I have similar comboboxes
in a couple of forms.  The rowsource for each combox is a simple select
statement on a table.  When I open either form not all the values are listed
in the combox.  The tables contain about 15,000 records ...