Hi,I have a year that runs from 1st august to 31st july.  I have a field
which contains a value to date.  Can someone tell me the best way to
calculate a staright line value forecast for the whole year, based on todays
date?

I am new to access application. I hope i can explain this clearly. I have a
main form and a subform which has the linked field strCauseNo. On the main
form, i have a textbox txtCauseNo which has the datasource strCauseNo. On
the subform i have a textbox which also has the datasource ...

that's about it... I want to create a query on the fly, e.g.
 sqlStr = "select first,last,other,whatever from myTable"
then do a
Set qdf = db.CreateQueryDef("ShowTheData", sqlStr )

My PartsForm has an unbound control TotSold as follows:
=nz([QtySold1])+nz([QtySold2])+nz([QtySold3])+nz([QtySold4])+nz([QtySold5])+nz([QtySold6])
I would like to show the SUM of all of the TotSold values on the form in
another unbound control GrandTotSold.

I have a form that has a drop down box Part_Type and there are 2 selections
inside: Raw Material and Purchased Component - for this field I have the
following code:
Private Sub Part_Type_AfterUpdate()

A form of mine is in continious forms, and what I am wanting to do is if
after a combobox update, if the comboboxes value = "yes", then grab the last
records value in [desc] on the same form.
There will always be a previous record prior to the one be entered in [desc]

I’ve written a function which has Date arguments. The function is not
working as it should. My best guess here is that this is because the function
is fed its arguments from unbound text boxes. I assume that VB is not
interpreting the text boxes as Dates, even though they are ...

I do not wish to purchase another licence for my laptop. I already have
Office Pro 2002 which was on my Desktop until I upgraded to Office 2003.  Is
office 2002 conversant with 2003? If so, can I use the spare licence on the
laptop?

I have an unbound subform will not allow me apply a filter based on
information that the user has already entered.  I get an error message that
states "You canceled the previous operation."
I am trying to filter based on the Primary Key (an id number).  However if I

In Access 2000, I have an instance of a form set up like this:
    set bb = New Form_frmBook
I would like to be able to reference variables declared within the form
module, programatically, from other modules.

i am producing a survey with 40 combo boxes for multiple choice answers, all
combo boxes must be populated.  At the end of the survey i have a button to
check that all questions have been answered, if there is a null i want to set
focus and display a message, the user then ...

Morning
I have a textbox that displays a user entered date. When this date is
entered I want another text box to display the week number for that date.
However, this needs to be based on the fiscal year with the year starting on

i've put the brackets around the form name and am still getting the same
error, could it be the spaces in the formula...

I was wandering if we could read the Norton virus definitions date.
Thanks,
Ladi

i am trying to do a dlookup in Access 2002 but keep getting the
operand/operator error, this is my formula can anyone pls help....
=Dlookup ("[Support Area]","[ Lima Caller Mapping Tables]","[System ID]="
&Forms!Form B_W Master Data!MachineID)