#Name?
Thu, 18 Dec 2008 20:20:30 -0000
Hello.
I imported tables and forms from another database.
All works ok except for one thing.
There is a date control in a subform whose default value is set to Date()
which should default to 'today', but show's the dreaded #NAME?
I have compared the control on the other original form, and every other
contr ...
|
List Box SOS
Thu, 18 Dec 2008 12:09:01 -0800
I have a list box on an unbound form, I am trying to extract data from a
query based on the selection I make in the list box, however nothing happens.
I put the form name in the query so that the unbound date field will work,
however I can not get the data to come to view. What am I doing wrong. ...
|
Command button errors in forms
Fri, 19 Dec 2008 06:58:15 +1100
Hi Guys and Gals
This is kind of a revisited topic. Please refer to my post on 15/12/2008
entitled Errors loading/opening forms using command buttons.
The problem I am having is similar to the previous issue. Last time I
created forms in 2007 and when I used them in 2003 the error occurred as
described in ...
|
Converting currency value to text value for bank checks.
Thu, 18 Dec 2008 11:31:01 -0800
I fill and print Bank Checks using Access 2003. As you know Checks have two
fields for currency. One for number ($21.00) currency and another for text
currency (Twenty One Dollars). How can I Program the text field to look at
the currency number field and covert its value to text and fill the text
value fiel ...
|
Prompt on Open
Thu, 18 Dec 2008 11:05:01 -0800
hello,
i have a field on my form "Reviewed By," which required two initials
is there code for me to be Prompted to enter the initials when i open the
form, so that the initials i entered when i open the form with auto fill all
the records i create
thanks in advance,
...
|
Command Botton Errors in forms.
Fri, 19 Dec 2008 05:12:33 +1100
Hi Guys and Gals
This is kind of a revisited topic. Please refer to my post on 15/12/2008
entitled Errors loading/opening forms using command buttons.
The problem I am having is similar to the previous issue. Last time I
created forms in 2007 and when I used them in 2003 the error occurred as
described in ...
|
How To sort
Thu, 18 Dec 2008 10:02:00 -0800
How to Sort Names in the reports or forms By there Job Titles :
For example:
If you have some Employees in dept and they Have a Manager and Project
Director and then the Seniors
etc...
So how to Sort the Employees names By there Job Titles in the or report for
each department Not alphabetic like the foll ...
|
|
|
please please I Need A Code For This Question Very Important
Thu, 18 Dec 2008 09:49:03 -0800
I work in company that takes 2 days for weekend it's Friday and Saturday
and all the holidays that may be more than one day such as Eid El Adha
is more than 3 days continuously.
So i made a form for entering the vacation for each employee in the company
like the following :
the main form :
Emp name , Departmen ...
|
Adding 2 controls to get a total
Thu, 18 Dec 2008 09:02:03 -0800
hello,,
I am trying to add 2 controls together to get a total
R1=1
R2=2
Total=3
I am using the following =Nz([R1],0)+Nz([R2],0), but the total control keeps
returning "12"
can anybody help me...i am sure it is something simple...but can't get me
head around it
thanks in advance
Ryan ...
|
I cannot enter any more text in memo field
Thu, 18 Dec 2008 08:23:01 -0800
I have a dB in Acess 2007. We have a "Comments" memo field where we keep
lenghty notes on cases. One of the users cannot enter any more notes in this
field. The memo field is set to plain text. I copied the text into a word
document to double check the size -- and it's barely 100k with 52K +
characters ( ...
|
