Microsoft Course
Mon, 3 Nov 2008 16:17:31 +0200
Hi There
Im not sure if it is ok to post this question here, I would like to find out
if anyone has heard
of a course with 'New Horizons".
On their website, it states that they are Microsoft accredited, as well as
ISETA approved?
The course is Microsoft Office Pack - Platinum. Its an online anytime
...
|
Looking Up Records On A Data Entry Form
Mon, 03 Nov 2008 13:54:18 GMT
Hello,
I have created a tabbed form that has four sub forms. The parent child links
are the (PK, AutoNumber) NCMR_Number and PTC_Part_Number. The database is set
up to track non-conforming material. I have separated the tabs out by
departments. The main (Parent) form contains general information about the
dis ...
|
compare data in identical tables
Mon, 3 Nov 2008 05:50:01 -0800 (PST)
Well their structure is identical.
I have 2 tables that have different data.
The tables have 204 columns and 10, 864 rows. Mostly small text
fields, date fields and yes/no fields but there are 10 Memo fields.
I need to show the rows where any table 2 values are different from
the corresponding table 1.
...
|
How to find the time elapsed between 2 events
Sun, 02 Nov 2008 21:19:27 GMT
Maybe someone here can help me. I have a database of customers with
information on their purchases. I need to get the time elapsed between
purchases and then get an average of time (in days) between purchases.
For example I want to sample 10% of my customers with at least X number of
purchases, to find the ave ...
|
Getting subform to open/load with a new record
Sun, 2 Nov 2008 12:55:00 -0800
When I select ClientID in the ParentForm, the subform (singleView) is
automatically loaded with the first relevant record.
I want it to load blank, ready for a new entry. Normally I'd put
DoCmd.GoToRecord , , acNewRec
in the OnOpen event, bur it seems to work only with independent forms, wich
are
loade ...
|
A map activated from a form
Sat, 1 Nov 2008 23:22:02 -0700
I work in a school with a catchment area in Stevenage. Parents of children
applying for entrance for their children to the schoolâ??s extra curricular
activities must live between Farlands and Martins Ways (which basically
circumvents the town center). We have had to set limits as the activities
are very p ...
|
Restrict unbound cboSelector in subForm to the ParentForm ID
Sat, 1 Nov 2008 14:01:01 -0700
I have subForm with records of CRM conversations. It's linked to the
ParentForm by ClientID.
I've also put an unbound cboSelector on the subForm to select needed
ConversationID details and kind of hoped it will restrict itself
automatically to the ClientID value of the ParentForm, provided the
link-conditio ...
|
|
|
Getting data from the form to the tables
Sat, 1 Nov 2008 10:31:03 -0700 (PDT)
I am working on a testing app. It will have five main tables, 1 for
student names, 3 to hold the test questions and 1 to hold the results.
Student Table
ID, autonumber
lname, text
fname, text
testid of test taken, long integer
DateofTest, date
Test Master
TestID, autonumber
testname, text
DateModifie ...
|
Date field + number field = New Date
Fri, 31 Oct 2008 14:58:03 -0700
How do I make this possible?
I want by pressing a button, to add Data + Number fields to Data2.
Thanks.
http://img55.imageshack.us/my.php?image=testqa2.jpg
...
|
Date + 30 on Subform
Fri, 31 Oct 2008 17:03:37 GMT
Hello All,
I have created a tabbed form with four subforms. In the first subform there
is a field named
[Corrective _Action_Req_Date]. I set the default value to =Date() in the data
section of the Property Sheet. I would like the date to automatically be
change to current date + 30 when the form is opened. ...
|
