A db was deigned on Access2003 and was working fine for a long time. I used
it on Access2007 and converted to new format. Now when I open a specific
form, the whole application terminates without any message. Event viewer
doesn't record anything and if I try to save as 2003 ...

I'm trying to calculate a person's payment balance for a series of
events. I figured that what I could do is sum the prices for all the
events, and the payments made for all the events. Something like this:
sum([Price])-sum([Payments])

I'm using the API call to hide the Access window.  Because of this, all of
the forms in my application have to have their Popup and Modal properties
set to True, but this limits editing capability during design, so I
frequently change these values to False (manually).

I am trying to create a data entry form (see earlier post) containing
multiple tabs.  One tab will write information to one table, whereas the
other tabs will write data to another table.  I thought this would be fairly
straightforward, since you can add fields to forms from ...

I wonder if anyone can help, I am at a loss. I am currently creating a new
database for my company and I have gotten myself stuck.
I have created all the tables and forms and I am having an issue with the
form retreiving information from my tables.

I am working with Access 2003.
I have a main Form with a Three Subforms - Subforms are separated by the Tab
Control with three tabs.
I want to be able to use the "Find Record" Button which currently I have on

Hi,  
Is there a way to run a query from a form, but not actually show the
results?  All I really want is the information that results from the query.

I have a form & subform for data entry. The main form links to a parent table
that contains info about water samples and the subform links to its child
that contains info about many different substances that are analyzed in each
sample.  

I have a very large database to which I need to add new data on a regular
base.  Because of its size, I have split the database into two and linked
them by a primary key.  The primary key in both forms is a route number and
year combination.  I am creating a form for data entry ...

Hi Folks - I am designing a form to enter data with the following
relationships:
The main form is legal case data such as name, address, DOB, etc. For each
case, there can be multiple charges, and for each charge there can be

I have three queries: MonthlyAll, MonthlyShows, and MonthlySpots.  
My main form is built off of MonthlyAll.  It's main purpose is to provide a
list of cities in a single form view, so that I can scroll through the cities
and view the corresponding data.

I have the following code in my VB:
[CODE]DoCmd.GoToRecord , [Response Tasks], acGoTo = [Response_ID], "08"[/CODE]
This is not working however....  The table name is Response Tasks, the Column
name is Response_ID and I am trying to pull the info from the one named "08".

I have a combo control on a form that has when I select a value the form
reverts to the first record it doesn't stay with the current record. I have
a NotinList procedure that opens another form to enable the user to add to
the list of values in the combo control and when I close ...

My Input Mask only works on the 3rd data and on. The first and 2nd
data entered don't follow the mask at all. Can anyone help , please?

I’m relatively new to Access coding and I’m running just beyond the limits of
my knowledge.
I’ve got a shared Access 97 database with a module that returns the wrong
answer and/or locks the field that should not be locked.