I have a report based on a query that prompt the user for the Relationship
Manager name when opened. When I run the query by itself there is only one
prompt, however when I open the report, the same prompt comes up 3 different
times. I figure that this has something to do with ...

Is it possible to compare a previous record in a query?
I have a query that has 4 columns that give me the date, part, operation and
Opvalue
In a 5th column, I want to compare each line to the previous line, if the

In my table, there may be multiple listings for one company, however,
each company only has one EIN.
How can I get my query to just report 1 record per EIN and show other
fields? I thought this would be easy to figure out, but I can't get

When your in access and you right click on an object, form, query or just
about anything, you can get to a properties option that has all these
settings.
Is there a place where I can easily reference what each of these settings

If you go to compact and repair our Database and someone else is logged into
the database, a pop up indicates who's workstation id is in the database.  Is
there anyway to run a report at any time to see who is in the database.

I currently have a macro that allows me to send emails to user that have
invoices that are not credit released. The problem is that i have to copy and
paste the email address in the to:field when the email pop ups. Is there
anyway that I can put a code in the to: field of the ...

I have a 10 user access backend/front end app which runs sufficiently ok.
Recently I deployed a winform/ado.net app that runs a sequence of queries on
the access backend db using OleDb ExecuteNonQuery method.
Problem is some users have started reporting frozen front end access app. ...

I have been adding code to my database mostly for actions when you press a
button or fill in a form.  This morning I opened my database and the module
cannot be found.  I have an old backup copy that works from two weeks ago so
i'm not sure what the problem is.  I may have left ...

I have a Module named  "NumWeekdays" which take out the weekends between two
dates, works fine. I have an "OriginalDate", "CompleteDate", "CurrentDate"
and "Text77" fields.
On the current record the user will always enter an Original Date. On a

I have a text box tbConsultNumber. My Company recently decided it wanted to
accept authorization numbers in that spot as well. Consult numbers are 7
characters and Authorization numbers are 9 characters with the following
format 0000000-0. What I want to do is check the data in ...

LdbView.exe does the trick for computer names.
But now I've got an app on a Citrix server and everybody's PC name is
the same.
Is there anything out there that will do something like LdbView, but

I have a form that I created that has a box that adds up certain fields.  
Sometimes, we need the ability to overwrite the automatically calculated sum.
Is there a way to do that?
Thank you in advance for any help you can give me.

Is there a way to make Access 2007 showe the object lists in the old 2003
format? When there are a lot of queries for example, it was easier to see
them all in context the old way. Now the scroll list goes on forever. Thanks.

I am using Access 2007, can someone please help me with how to copy data to
another table in the same DB when one table gets updated?
Thanks in advance!

I'm trying to import and append a csv file into a linked tabe using Access
2007. Of course I  am having problems. I get an error message saying "Invalid
Argument" with no explanation. If I put the table in the same mdb it imports.
Is there a known bug now that you can't import ...