How would one move selected data from one list box to another via the
onclick method of a button?
Thanks in advance.
Karen

I have the following set up to give me aresponse number R05-001
I would like it to reset to R06-001 at new year
ResponseNo: "R" & Right(Format(Date(),"yyyy"),2) & "-" &
Format([PONum],"000")

Visual Basic Language Reference
Erl Property
Returns an integer indicating the line number of the last executed
statement. Read-only.

I have a library mde that is used with some customer databases and I found
out that another developer discovered it while doing some maintenance work
on an old database for the same customer and has copied it to use with her
databases. Naturally, I was not impressed and that ...

I'm not sure if this is some random bug in the system, but I keep
getting the #Name? error on one of my forms when I try to link one
field to another. For example, I have one field called txtTrialField
which = date(). I then have a second field which =[txtTrialField]. For

I am working on a database that will contain an accounts recevable
section.  I know what I want to do, but just keep drawing a blank when
it comes to doing it.
Here are the Feilds I'm working with

Hello Group:
My first post on the group.Hope I get a response.
I have a modest Fire Insurance ACCES Db.Thanks to this group - for the
code. A "wanna be programmer"... "LEARNS"

E.G. I want to record sales.
Three tables - TblProduct TblCust & TblSales
TblCust fields = custID custName
TblProducts fields =   prodID   prodName

Hi Group.
I would like to add some information to a query.
I tried to create a table with the information from the query but then
if i run the query again the additional data will be lost.

(also posted to microsoft.public.access.odbcclientsvr but no reply so
far:  problem concerns ODBC->MS Access)
I have some ODBC code that I'm testing against various underlying
databases. The code was developed against MySQL but now I'm getting

First of all, great site! It has helped me a lot.
I am trying to make a report based on a crosstab query. I want to use all the
fieldsin the query but when I select the query in the Report Wizard I cannot
select any fields in the Available Fields because I don't see any fields in

   I am making a web application in asp.net.
I want to add a record in ms access using a button event.
How to do it?
ANY IDEAS ???

Year Numbers
A recent post prompts me to point out a capability of JET 4.0, to set the
seed and increment of identity columns. (This is not a solution for that
post.)

I know I have lots of dead code in my Access 2000 app. I wanted to
remove it and I saw this free software on prior posts to remove dead
code.  My problem is that I downloaded the VBA  version and I can't
figure out how to execute it!  The instructions say to use the

When I start a new record, the <autonumbering> ID in the field is not
updated yet, only when I fill in the first field of that record. How to
solver it?
Bart