I need to bring two tables from a Main Frame computer into my computer
that are linked with key fields that distinguish between upper and
lower cases.
For example, the Code field (Key field) in one table contains:

haha I found this a major drama but found the problem maybe someone
could tell me the reasoning behind the fault
   Set db = CurrentDb()
   Dim rs1 As dao.Recordset

In more than one database, a graph on a form displays completely blank after
some design change elsewhere. On double clicking the graph, the table of data
is found to be correct, and yet the graph does not show anything. The best
way of getting it going again is to change the ...

Why does this happen:
x="HI"
y="Hi"
if x<>y then

I have several option groups set up on a multi-tab form.  For some reason
(can you tell me?) some of the option groups won't let me click on any of
the radio buttons.  I click, but it doesn't get "filled-in" with anything.
The underlying fields are all numeric, byte, default value ...

Does anybody know how to get the Display Name of Windows? I've tried the one
posted by Chris, but to no avail. I keep getting an error message.
Also, I've gotten the windows username, but not the Display name.
CN='display name'

i could use a little help with a function i'm trying to create for a textbox
on a report.  the textbox is in the detail section of this report and the
field that it's tied to lists a variety of 3-character codes that i want to
translate into english.  the codes are listed in a ...

I have code set up that I have found in these newsgroups and modified to
compact/backup a backend.  The code opens a dialog box for the user to select
the backend to compact/backup.  Since there is only one backend, what I would
like to do is have the code programmatically select ...

Hello I am new to the module side of access and need some help:
I have three series of eight random numbers that the user will be able to
check which set they want and I need to know two things:
  1) how do a properly construct a on click event

I have this expression in a query: [CleanOrdersWithin]/([TotalShippedOrders]-
[OrdersReqIntervention])
If CleanOrders Within and Total Shipped Orders both = 0, how do I get the
expression to not error?

Having a problem with getting the format correct in a Word document when
pulling the info from Access..... This is the common "Merge to Word" code.....
One of my fields in Access is currency. In Access I have it set to "currency"
decimal at 2.. BUT..... with this code.......

I have a table that contain period begin date and period enddate as follows:
1106   11/01/ 2006     11/30/2006
1206   12/01/2006      12/31/2006
0107   01/01/2007      01/31/2007 etc

IF TblAgentNames.SecurityLvl > 1
WHERE TblAgentNames.WindowsSignOn = FctWindowsName  
THEN do something
FctWindowsName returns the windows log on name. I want to compare the

I have a text file called c:\textfile.txt and an Access database with a table
called Accounts.  In the Accounts table there are two fields, Old and New.
There are about 200 records in this table.  Is there a way for Access to
interact with this text file?  I would like to search the ...

I am trying to incorporate some code to compact/backup my backend, but since
my backend resides on a server and the front end is on my local machine, it
doesn't work.  What I would like to do is utilize the GetOpenFileName dialog
to browse to the backend.  Here's the code that I ...