|
How to change the defalt color of lines, arrows ect in "Drawing"?
Hello,
I just started using PowerPoint 2007 and can't seem to figure out how change
the default color for drawing. Every time I draw a line or circle, rectangle
etc. in "Drawing" they always come out in Blue which is annoying because I
have to change each line that I draw to black.
In my old version of powerpoint if you changed the line color to black then
every line etc. that you d...
|
1 |
1/1/2009 10:39:00 AM |
|
|
# Error in Forms
I get a red # Error message that flashes in the upper right hand side of the
form.
the text within it reads:
=IIf(DCount("*","[Contacts Extended]","[ID]<>" & Nz([Clinic ID],0) & " And
[Contact Name] = '" & Replace(Nz([Contact Name]),"'","''") & "'")>0,"Possible
Duplicate","")
It also seems to be making things "unstable" i.e. screen freezes up etc.
Any help is greatly a...
|
2 |
1/1/2009 6:25:00 AM |
|
|
Unbound Refresh Problem
2 Problems.
1. I have a form which displays all the information for each project I
undertake (one project one form). On that form I have a bound combo box
(cboOldJob) which queries all the other projects i have undertaken and
allows me to select a previous project which is linked to the current one.
This works ok.
I have two unbound txt boxes which display the client name and the jo...
|
2 |
1/1/2009 4:57:11 AM |
|
|
Combo box - 1st record selection
I have a combo box to select the records to appear in a Form.
Upon opening the Form, the 1st record is automatically selected - whereas I
want the form to open in blank - and a record to appear only after the user
selects the record in the Combo Box.
Appreciate help.
--
Glynn...
|
2 |
1/1/2009 4:46:09 AM |
|
|
Combo "Not in List Event", MS generic message still appears
Hi,
I'm writing a database to help teachers write Unit Plans, containing several
tabs of hierarchical information, both within the tabs and between the tabs.
I'm trying to use a combo box to display current choices, but allow the user
to start a brand new Unit Plan (a relational table upon which many other
choices and related information and tables will hinge and be added to.
My form fie...
|
4 |
1/1/2009 4:37:59 AM |
|
|
purpose of subform?
working on form to select records from 2 tbls and create a new record based
on selected items in a 3rd tbl.
tblStudents(list of students)
tblEnglish (list of english courses)
tblMath (list of math courses)
....(one table for each course topic)
tblStudentSubjects (list of students w/ selected subject)
main form (tblStudents)
-cbo to display and select a student from tblStudents
subfor...
|
22 |
1/1/2009 2:49:01 AM |
|
|
Runtime Error 3001 Arguments Are Of The Wrong Type, Are Out Of The Acceptable Range, or are in conflict with one another.
Hi,
I'm trying to run the following code whenever a user tries to create a
new record in the database. The purpose of this function is to check
for duplicates in the table. I am getting a runtime error 3001 with
the following description when I try to run the public function. Does
anyone have any idea why? I have done something similar to this in
the past, and didn't get any errors the...
|
5 |
1/1/2009 2:38:22 AM |
|
|
Filter a form by combo box selection
I have a continuous form based on a query which pulls TenderID and
TenderSite from tblTenders and ClientName (linked by ClientID) from
tblClients, so I get...
2134 London Client1
2163 Liverpool Client 2
2222 Cardiff Client 1
2345 Derby Client 3
no problem so far.
I want a txt box in the form header above the Tender ID so I can just type a
t...
|
4 |
1/1/2009 2:09:07 AM |
|
|
A2K Runtime Crashes on DoCmd.Quit
Hi;
Using A2K Runtime on XP Pro PC. Have all of the updates for XP and Access
Runtime including SP-3 for both.
The app opens to frmLogin correctly. On that form there are 2 cmd buttons.
Continue & Exit.
Can log in as USER or sa, (System Administrator) but when clicking either
cmd button get Access Runtime Crash.
"Execution of this application has stopped due to a run-time error....
|
26 |
1/1/2009 1:14:35 AM |
|
|
Filtering by Dates
I have a form which lists all my projects from day dot (all with dates
stores as dd/mm/yyyy). When I open the form I want either cbo boxes or
radio butoons which when used will filter the form by a date range.
e.g. I would like to select the year from the first cbo, then the month from
the second combo then the day from the third cbo and the continuous form
will sort automatically as e...
|
2 |
12/31/2008 10:41:01 PM |
|
|
Why Would A Dlookup Function Work On One Computer But Not On Another Computer?
I have a main form with a dlookup function that looks up an account
number based on another textbox that is looking up the oldest record
in my table. This is all fine and dandy and works wonderfully on most
of my users' computers, but there are a couple people whom my dlookup
function returns a null error. I don't get it, because I know there
are records there. There IS an account number t...
|
11 |
12/31/2008 10:20:33 PM |
|
|
Starting e-mail from within Access
My programs master file has the customers e-mail address, I have set it up so
if the user double clicks the e-mail address it starts outlook and I can send
that user an e-mail. Is there a way to be able to have different e-mails
provider start? Some users use yahoo,gmail or some other provider. The
program I've written has a setup section that I could have the user enter
there e-mail p...
|
1 |
12/31/2008 9:27:01 PM |
|
|
Tree control (MSComctlLib.TreeCtrl.2) support for accent (diacritical) marks
I am using this control in a VFP (visual foxpro) form (don't ask...).
The data I pull from the database to populate this the tree show up
but is missing any letters that may have an accent mark over them. Any
ideas if the tree control supports those characters in the first place?...
|
5 |
12/31/2008 8:32:39 PM |
|
|
error message on open form
Hello, I have a click event that references a function in a module, but
everytime i use it i get the following error
This error occurs when an event has failed to run because Microsoft Office
Access cannot evaluate the location of the logic for the event. For example,
if the OnOpen property of a form is set to =[Field], this error occurs
because Access expects a macro or event name to r...
|
6 |
12/31/2008 6:35:00 PM |
|
|
Access 2007 Form information not appearing in associated Table
Have created various expressions in different fields of a Form. The
expressions function correctly in the Form, outputing the correct
information. This information in the Form fields do NOT appear in the Table
from which the Form was created. If the expressions in the Form fields are
removed and the data inserted manually in these fields, the data then appears
as it should in the Tabl...
|
3 |
12/31/2008 6:29:49 PM |
|
|
Two sets of tab orders??
I have a form that has 2 sections, each of which needs their own exclusive
tab order. When the user tabs at the bottom of either section, the next
record needs to open and the tab needs to go to the top of that particular
section. Can I...
A) put the 2nd section in a subform, but bind it to a different table than
the main form? (NOTE: If I go this route, two separate tables would be ...
|
2 |
12/31/2008 6:25:22 PM |
|
|
Add data button
i created a form which contains many Text boxes. Now i want to put a button
on this form which add automatically the information from the text boxes as a
new line into a table. My question is, is possible to create this button
without write VBA code behind him (only with wizard) ? i didn't now the vba
code very well. i am using access 2007.
sorry for my bed English
thx
Daniel
--
Me...
|
3 |
12/31/2008 6:21:25 PM |
|
|
why does my input form appear blank in input mode
I am developing an input form and a couple of report forms. The reports work
fine, the problem is with the input form. Suddenly as I am writing the code
and go to look at the product for appearance, the form page is blank. When I
right click on the background and select design mode, the design page is
present. Any help would be appreciated....
|
5 |
12/31/2008 5:20:52 PM |
|
|
Run-time error '3197'
For better or worse, my forms are not directly linked to underlying tables.
Instead, I copy the data from the table to the form where it can be modified
by the user. Then I copy the now modified data back to the table using VBA
and .edit and .update.
I am in the process of creating a new table and database. Whenever I try to
save the data back to the table, it works for about 3-4 tim...
|
11 |
12/31/2008 4:46:37 PM |
|
|
calculated field in a form
I am trying to calculate a field in a form. I have a table that has the fields
Product _ID
Product Name
Product Price
I have an unbound combo box which selects a produce name. I am then
creating a calculated field in my form which calculates the area multipiled
by the price of the carpet. My calculation =[Combo22]*[Area of Carpet
required] works but from [combo22] picks up the pr...
|
2 |
12/31/2008 4:00:42 PM |
|
|
how to cycle through form combo boxes
I have a form with combo boxes on it that i need to programatically cycle
through and i need some help.
on the form i have the following combo boxes
cmbo1
cmbo2
cmbo3
each combobox has the source that is a query returning a number value. i
simply return cmbo1.value to the report it works fine. but what i would like
to do is loop through this.
i would like to pull cmbox.value and...
|
2 |
12/31/2008 2:27:48 PM |
|
|
Why do I not see the results of an lIF expression in forms in my T
Wrote an If expression in the form Access 2007. Function works in the form
but the results do not appear in the associated Table from which the form was
generated? The output of the IF is True = 1, and False = 0. These values
work appear correctly in the Form but are absent in the Table. On generating
a Split Form, the values appear both in the Form and Split Table of the Form,
but ag...
|
5 |
12/31/2008 2:23:39 PM |
|
|
Link Child/Master Fields from Three Combo Boxes in Subform
I have a Master form that has three combo boxes. I have an embedded subform
and have added the three fields in the link child fields and the link master
fields of the subform place holder. My problem is that all three combo boxes
must have a value before I get any records to display in the subform. I
would like the users to have the ability to select a value from combo box 1
and leave...
|
3 |
12/31/2008 1:53:01 PM |
|
|
Validation before adding record
I have a form created off a table. I have set validation the validation rule
and text in the table design.
On the form I have created a button to create a new record. When I click
that button and I leave a field blank it gives me a visual basic popup with a
runtime error... and the error message what i indicated in my validation
text. There are buttons for end, debug or help. Is th...
|
8 |
12/31/2008 1:27:01 PM |
|
|
Command button control
Hi i'm wanting to have a command button input data into a field in a table
and also open a popup to for a list which enters data on the same
record(different field).
Then after data entry to the pop up it needs to close, but still alow data
entry to the original form..
I've tried opening another form (through an event procedure), but can't get
the original form to input on the same ...
|
1 |
12/31/2008 11:31:01 AM |