Sorry for the rather elementary question but I desperately need to
insert a variable into a SQL Select query that I am executing in some
VBA code for an access DB.
The query is this:

Is it possible to use two tables for one subform? And if so, how do you do
that? If not, how would I go about filling a subform with data from two
different tables?

I designing a form the feilds are bound. the form will be used by other
workers i want the form to update records using a update button but if the
user enters data and then decides that they don't want to update the
information. hqw can i prevent the update of the information ...

I have an Access report which I wish to e-mail. The instructions say to  
create a .snp file and e-mail it. That I can do and have done. I am  looking  
for a way to password protect that file.
I have not been able to find a way to do it. In Office Word documents I can

I am trying to Convert an ACCESS Data base from Access 2 to Access 2000
It was written in 1994.  I did not write it Iam trying to update it.
It uses the following DLL's and is Run by MSARN200.EXE
DAO2016.DLL,MSABC200.DLL,MSAFIN.DLL,MSAIN200.DLL,MSAJT200.DLL,

I need sorten amount of space for my college and business in access how do
work this in Office Proffesional 2007?
Douglas

Can someone help me figure out why one of the records in a table in my Access
2003 Database application displays the record in Japanese characters?  The db
table gets populated by end users entering data in form fields and values are
written directly to database table.  For some ...

I have a assigned a password format to a field in a table I've created.  How
can I make this field case sensitive?
Thanks.

I'm attempting to disable a txtbox after it's been updated with old
data, so that it can't be accidently changed. I tried
me.ChickenR.locked and me.ChickenR.disablewhen but both are giving
invalid use erros. Any suggestions?

I've procrastinated long enough; I'm starting to learn Access now.  I know a
little actually, but not much.  Anyway, I'm practicing with the NWind DB.  I
exported each table to an Excel sheet and then tried to import each Excel
sheet to a new DB that I just created.  A bit silly, ...

I work at a company that analyzes healthcare records.  Most of what
goes on here is beyond my control - why they don't use SQL Server for
everything etc...  Here's the situation:
- the company stores "Patient", "Protocol" and "Protocol Roster"

  I hide database window window in the start up of the application,in
Office 2003 i use the below code to unhide it:
DoCmd.RunCommand acCmdWindowUnhide
I try to use the same code with Office 2007 but it does not work,can anybody

I have a form that I use to enter data into a table. I put a button at the
bottom of the form that I can use if I decide to cancel and exit the form if
I change my mind. However, when I use the Cancel button it closes the form
but also puts the data into a new record in the ...

I want to calculate the difference between two date fields and display as
total days:hours:minutes.  Is this possible?  I've used
DateDiff('n',[StartDate],[EndDate]) to calculate the difference as minutes,
but don't know how to format the result as days:hours:minutes.  (The ":"

I have a database that contains information on a certain number of
individuals during different session. Table 1 'tbl_Tracking_Form1' has
information on sessions 2,4 and 6. Table 2 'tbl_Tracking_Form2' has
information on sessions 1,3 and 5. Table 3 'tbl_General_Info' has ...