What is the best way to display a EUC-encoded field with Access 2007?
Or, failing that, how do you display a Unicode field as the character
instead of the number?  Do I need to use a browser control? I have
created a local web page which successfully displays a Unicode

Novice Access developer
Access 2007
I have an Order Detail Form and created a combo box which lists the
item description.  However, I need it to submit the ID.  I get an

I have a database with several reports.  I use it daily, it is on a
network drive.  None of the reports will open - not even in design
view.  I have done a detect and reapair, compact, created a new
database and imported all the tables, queries, reports, and macros on

I am working on a form now that has two things in it: a text box and a
subform. The subform is from a query. The text box is just a normal
text box. However, I would like to link the text box to the subform in
a manner that would allow the material entered in the text box to act

I am having trouble with very sluggish response times for users
connecting over a WAN. Local users using my database are able to run
the most common queries in 2-8 seconds (maybe up to 30 seconds during
peek usage.). Users in upstate Minnesota here can easily take 20-60

I am a programmer for a living, but this problem has my whole team stumped.
I have a subform based on a query.  I'm not using the
"LinkMaster/ChildFields" properties ( I have my reasons ).  The ssbform's
query has a criteria for forms!masterform!Keyfield.  This works fine on

Am using Stephen Lebans ConvertReportToPDF 'Version:   7.51. It's
stated Purpose:  Export report to Snapshot and then to PDF. Output
exact duplicate of a Report to PDF. I'm just as thrilled using it as I
was after first implementing it well over a year ago.

I have an application bills a customer $30 monthly.  This charge is
assesed on the same day of the month as the customer signed up for
service.  For example, if a customer signs up on Jan 20th, then they
get billed again on Feb 20th.  If they sign up on Jan 31, then they

There has been a lot of mention about a limit of 2048 as the number of
table ids that can be maintained by Access.  How is this value
obtained?  Any help is appreciated.  Thanks.
Vincent

Whenever I've created junction tables in the past, I always made the PK of
the junction table the combined pks from the two other tables. Ex: Table1
PK=A; Table2 PK=B; Junction table consists of two fields, A and B, which
together comprise the PK for the junction table.

I use this code from http://support.microsoft.com/kb/210047 to stop more
than 50 characters being input into a textbox.
****code start****
Sub LimitFieldSize (KeyAscii, MAXLENGTH)

I tried to install Access Runtime 2007 on 2 machines having Word,
Excel, Power Point 2007 but unfortunately it did not succeed. I got
the message "Installation failed" which was not helpful at all! No
reason given.

I have Access 2003 and 2007 installed on my Vista machine.  When I use
Tony Toews' excellent Auto FE Updater utility it always starts A2007
irrespective of if it is the "current" version i.e. the last version
that was run.

**********
Situation
**********
I have a table which contains two text fields which represents the first

I need help.
There is little company with intranet network.
The problem is that: it is impossible to open any mdb file, witch is placed
on other computer in network.