I'm using Access 2002.  The following code gives me a type mismatch:
Private Sub Command13_Click()
   Dim Rs As Recordset
   Set Rs = Me.Recordset

   The value I need to return is the total # of credits carried over into
the currently selected Biennium. Each biennium affects the next. I believe
this should be done in a loop starting from the oldest biennium on record for
the selected staff member and cycling though to the ...

Can anyone help with a criteria problem
Using :
Dim curX As Currency
curX = DSum("[BudgetTotal]", "Tblbudgets", "[BudgetId] = " & Me.BudgetFromId)

Trying to create a new table in Access 2000 VBA without having to resort to
the old TABLEDEF method.   Example:  In a few lines of code, how do I make a
table named MYTABLE with TEXT_VAR(50), NUM_VAR(Double), YESNO_VAR(Yes/No) ...
just an empty table structure ... not created ...

Is it possible to use the Date/Time picker control in a subform?  I have a
subform and I'd like to allow my users to use the control to choose the date
in the subform for updating the records relating to the main form.
Thanks in advance,

Is there a way of adding say excel to a form - which would have the same
functions availabilty as the normal excel application.
I wanted to avoid the user changing from one application to another i.e.
access to excel and back to access.

I converted a database in Access 97 to Access 03...when I try to open the
database I get the error..."Your Microsoft Office Access database or project
contains a missing or broken reference to the file 'dao2535.tlb' version 3.5

I have a fuction() that I have been using for two or three years now it is
not working I get a Run-Time error '3270'
The code I been using is
Public Function ImportCFN_PT()

I am relatively new to Access programming so please be patient.  I have a
table (Tbl_Test) with 5 fields.  I want to search for an enter word (inputbox
will do) which could be in any one of the 5 fields.
Can someone please advise how to  produce a msgbox the says the entered word

I have been successfully adding and updating Outlook contacts from Access
using Access2000 and Outlook2000. My code takes the email address from the
contact's details in Access and if the address is not found in Outlook, it
creates a new record; alternatively it updates the ...

First of all - I want to say how much this website has helped me to date.  I
am a beginner to ACCESS and use this site to help me learn.
I believe I have a problem which is not that complicated to the experts and
was hoping to get some help.  Thank you in advance to anyone who ...

I have a form which when opens requires user to enter code at prompt the
form shows code desc supplier and for entering batch number and result. the
form shows history of code but sometimes their is more than one supplier so I
would like a second prompt requesting supplier ...

I've build program that Read Text file and store it on Access table
according to Structure
i read the data using Line Input command
Is there a way to know what is the actual Location on the file i'm right

I have a search button on the form and run the access search form.
I wanted to inform user to add data if the data not found from database.
I found that Access using docmd.domenuitem
"DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70"

Im making a form in which automatically generates a company number once the
user inputs the name of a company.
I tried to use this code to generate a number for the company (code),but it
only runs correctly once.