hey.. i have a report that is based on a 12 field simple query.  i've been
working on it for a while and had to restart some areas so i know i went over
the 755 control limit but only until i reset the report with the
saveas/rename trick.  however, that's not helping me now.  i only ...

Hi Folk
I looked at the Northwind Sample Database for the first time recently and I
was just wondering why they made it so ugly.  If northwind is supposed to be
inspiring to young and hopeful access programmers then why does it look

I need to have an option button that allows editing to a field only
when it is checked.

Hi,
I have a search form and upon double click on a name in the list box, a
Candidate details form pops up. (no edits etc allowed, only viewing). I
have a second form in dataentry mode which is in the exact format as

I have a routine to copy data to new versions of my app via insert into
sql statements.  Unfortunately, due to evolution of my app, sometimes
the new version has more restrictive editing than an older version that
I am updating.  Thus I get this message.  It tells me only how ...

trying to query records with pattern "fund" in notes field
notes is a memo field
below code is not working
SELECT SecondaryData.name, SecondaryData.notes, SecondaryData.address

Using the wizard to create some A 2003 forms. The long text fields end up
with tiny scoll controls and the enter key doesn't move the cursor to the
next field like it does on shorter fields.
I can turn off the scroll controls but I can't see what to change so that

I'm starting to learn about the tab control.
How would I write an on open event procedure in VBA, that upon opening
of the form, a specific tab opens  (say tab 1)?
Thanks

Hi, I know that there were a lot of common posts but I stel have a
problem.
I'm using this code:
set x = new adobd.connection

A customer has an access database that has a custom Visual Basic
compiled (.exe) front end.
The developer is gone.
They have copied the database and program to new computers.

This is not as simple as I thought.
Using Print # I am outputting content for a text file. I wanted at certain
points to force a page break so I thought a Chr(12) for a form feed may
work.

I created a form named "Purchasing".  I added tabs, the first of which
is named "New Purchase Order (PO)", on which I enter PO information.
On the second tab, named "Print PO"  I want to select one PO number
using a combo box and print only that PO.  What is the best way to do

I got this message running an application on a terminal server, but my
laptop development copy doesn't get this error
So I've been pinpointing the problem,
  formA has command button to open frmB

I was using the following statement
Me.Recordsource = strSQL
in MS Access 97, and it was working fine.
Now, since i converted the mdb file to Access 2003 I started getting

       From a word macro in VBA, I am trying to create a report in
access DB. The report is based on a query with a parameter.  I am using
Set rpt = Application.CreateReport
rpt.RecordSource = <<Query_Name>>