DebtID = rs4.Fields("PRIMARY_Debtor_ID")
DebtNo = rs4.Fields("Debt_No")
strSQL2 = "SELECT * from DEBT_PMT where [DEBT_ID] = " & DebtID & "" And
[DEBT_NO] = "" & DebtNo & """"

I have settled the option for use the database icon (.ico) as form icon as
well.
It works on my database. The I do the .mde and deploy it via package wizard
with Access runtime.

I have a form working how I want it to at the moment.  There are potentially
20 controls able to be shown on the report but this number can be as low as
1.  The user can press a button and from there a new form opens.  Again this
I can do.

I have Access 2007 and have downloaded the Access 2007 developer extensions.
I ran the .exe and a message stated that it had been installed correctly.
Does anyone know how to get to the open the file from Access?  I can't see
it in the add-ons, menu bar or anywhere else for that ...

Is there a way to disable to code view to end users?
I would prefer that the end users not be able to view/access/edit code that
has been written.  
Can access to the code be disabled?

I have 10 tables in one db in access.They all have the same fields and some
have extra fields that others do not have.  Can you advise how I would merge
all tables into one master table?
Any comments would be greatly appreciated. Thanks.

I'm working on an application where I don't have great control over
what people enter into my database - or whether they must fill in all
fields.  If I were dealing with a form based directly or indirectly on
a "parent-most" table (well, not a child of another table), it would

I have a value in a field that has a data type as "single" number and is
formatted as general number with an input mask of 0.00.  I also have a form
using that field.  The text box (TB1) has the same formatting and the same
input mask  

I am trying to use the following public function I found at
http://www.fabalou.com/VBandVBA/lotusnotesmail.asp
to email a report via lotus notes but am having trouble
calling the report in access...

I am having some issues creating the SQL coding  to create a union query.
I have 10 tables named 1998- 2007. Each table has the same fields(21 fields
to be exact)  but I would like to create a union with all tables into one
master table. Can someone help me with this?

I am having a small issue automatically saving a created
pdf file through VBA. I want to name the pdf file I am
creating based on a varibale from my code(which i do have
working but it only works correctly 50% of the time).

Hi I created Sub Procedure in a module only.  It runs fine.  Does anyone know
how i can run it from the user interface and not the developer vbe?  It does
not show up as a macro?  thanks.

I'm trying to set the printers for my reports which I've done.
My issue is that the printer name changes each time I log into the terminal
server.
If I can look up the Session ID then I can build the printer name.

My app uses access 2003. I have the tables in one database and the app in
another.  I want to streamline upgrades.  Currently, I send the client the
updated frontend database but then I have to make the client email me their
backend database and  I manually add the new fields ...

Hi
I want to use Eval function on bound form to add some figures , but Im
getting  error, Why?
Please help me. My code is like this: