I have a main form A and a subform B. I would like to place a lookup
field on the main form that calls all the records in subform B that is
related to main form A. How can this be done if possible and I would
like to be able to advance/go to the next record/s that related to the

Please help. I have two tables - the fields are detailed below. I am trying
to create an oustanding balance (ie Net Application Amount - Internal Credit
Note - Amount Paid) which I can do BUT I want to age the outstanding balance
so that when I input a receipt it takes it off the ...

I am trying to make some last adjustments, for convenience and security,
before deploying a secured FE-BE DB on a network. One of the things I would
like to do is disabling the design view option in the right click on a form.
What I would also like to do is to ask Access to show ...

I get an error message stating "ObjectID" in not an index in this table. Is
there a way to repair or overcome this so can access my data?

Anybody have much experience with digitally signing their Access mdb files?
When I go into the VBA Editor and select the Digital Signature, I get a
dialog that says:
The VBA project is currently signed as

Is there a way to block that query information/warning box that pops up
telling you that ... you are about to delete x rows in table?
I'm running the query within Code via docmd.openquery statement.
Thanks,

I hope this is an easy one and somebody can help me.  I have a small
knowledge of Access and am trying to set up a database for a cancer charity
(a day care hospice).  All I'm trying to do is create an Attendance Record.  
As patients have one set day a week for attending, I will ...

I am using Autonumber with the Increment format for my IDs on a table. I use
a form to enter data into this table. When I go to the next blank form and
begin typing, but then delete the information and close the form, there is
not a record saved in the table but the ID number ...

I am writing a batch job (the old way with DOS) to open 6 different
Access databases and run a macro in each one. In the bat file, I used the
command line documented in the Access 2002 Help.....
"C:\Program Files\Microsoft Office\Office10\msaccess.exe"

On Mar 23, 8:32 am, Destin Richter
<DestinRich...@discussions.microsoft.com> wrote:

...a popular topic, I know.  I failed to find past postings that deal
with what I would like to do.
First, a question:  Should I use Excel to clean-up data (eliminate
duplicates, etc.) or import into temp tables in Access and do it

I give up on this one, can anyone help?
DCount("*", "tbl_MAIN", Format("[SaveDate]", "yyyymm") = Format(Date,
"yyyymm"))
I'm trying to count all records in tbl_Main that have a SaveDate in this

Everything was going along great this AM.  Had to go to a meeting, so I
closed the application I was working on and went to the meeting.  When I
returned, I got this "Project Locked" message when I tried to go into the VBA
editor.

Hi,
Can i link two text boxes on separate forms??
eg, if i have two forms open, and i input data into a text box on 'form1'
can i get this to automatically input into a text box on 'form 2'?

I have a huge database with the sales of different product lines and regions
and I need to extract the key lines by region for the corresponding period.
vLookup is just bringing the first "world" in the database so if I want to
have the value for world for "cosmetics" as well as ...