lookup syncronization
Fri, 7 Nov 2008 12:51:01 -0800
Newbie User...
I have a form with a lookup to a "Company Name" field which works great.
Then I have another field that I want to do a lookup on a contact person, and
I want the Contact lookup to only display the records that match the "Company
Name" field already entered on the form.
How do I do that? ...
|
Form-Query-Entry Question
Fri, 7 Nov 2008 07:30:18 -0800 (PST)
I have a room reservation app that is shaping up OK but it still has
some things that I would like to improve on. I have created forms for
each of the computer rooms in our organization. The rooms are DLR1,
DLR2, and a few others. The form entitled DLR1 pulls information from
a Query called DLR1. The DLR1 Query ...
|
Using Access DB from a CD
Fri, 7 Nov 2008 06:50:03 -0800
If I have an access database on a CD can I access it, add/change tables and
save back to the CD?
...
|
Multiple Records
Thu, 6 Nov 2008 23:14:00 -0800
I have a corporate database that has multiple directors, officers and
shareholders and would like to list all of the directors in one list box in
the form...so if I pull up ABC Company and click on the director name it
lists all of the directors. 2ndly when I search sometimes that person could
be in all thr ...
|
Re: Autonumbers [WAS: Re: How can we have a field assign a num. automaticly starting with 29]
Thu, 06 Nov 2008 18:08:23 -0700
"Klatuu" <david.hargis@realpage.com> wrote:
>No, I think military action is required :)
>We haven't had a good tussle with you guys since 1812.
>Hey, but don't burn the White House again. That was really inconvenient.
>
>Oh, wait. That was actually the Canadians :)
Glad you figured that one out.
Tony ...
|
Automatic Operation
Thu, 6 Nov 2008 16:48:00 -0800
I have a rather interesting challange, made more difficult because my
company holds very sensitive information of millions of people.
What I want to do is Set Up a Recurring Schedule to automatically Run a
Report in Access 2003, convert it to a PDF and Email it to a defined set of
Users. Security issues will ...
|
Turn on Code and turn off Macros
Thu, 6 Nov 2008 15:18:00 -0800
I recided Access 2007 on my Test laptop. For some reason I can only run
wizard macros and not Code. I tried writing basic code "docmds" and others
and none of the code runs. Even if I conver the macros to code. Code does not
run. Is there a setting for this? ...
|
|
|
Web Toolbar
Thu, 6 Nov 2008 14:20:35 -0700
using VBA how do you close?
Thank you all
Bre-x
...
|
Newbie Refresh question
Thu, 6 Nov 2008 12:37:21 -0800 (PST)
I split a database and set the back end tables up on a shared network
drive. Then I created mde files and distributed to one other person so
we could test. He entered records and I entered records at the same
time. We both did not see each others records until we closed out our
db's then reopened. Then we saw ea ...
|
Nested IF Function Will Not Return Other Values
Thu, 6 Nov 2008 12:10:01 -0800
I have written the following Nested IF function:
=IF(K13="N","NA",IF(K13="1","A",IF(K13="2","B",IF(K13="3","C",IF(K13="4","D")))))
However, once applied, only the 1st value "NA" is returned when the
condition is "TRUE". All other results return a value of "FALSE".
How do I rectify so that the other values a ...
|
