Anybody's solution would be appreciated. Pls,
do not pause to write anything for this. I'm not
looking for that kind of a handout. I have an idea
about how to do it, but I wanted to see if anyone

Somehow I want to transfer data from an mysql database on the web to an
local offline access database.  Note: tables and types do not match.
So, I toughed, generating sql commands to insert the data would do the
trick. But, unfortunately it works only properly for 1 record.

My problem:
I have query with value klient and product. On my form Im using
multiselect box as filter of klient value. Now I would like to use
second multiselect  on this form for product value selection but only

I am making a form that will contain address fields for a land owner,
but sometimes the land owner does not live on the same property they own
(for instance, they may be renting it out to a tenant), or in the other
case, they are using a PO Box instead of the physical address. I am

I have a huge list of records and deleted a few. This means that the
ID-nummering contains holes. How to get it renummered? With Compact and
Repair Database no success.

Is there a way of using the calnder in a form as a filter or a search ?

I want to see on my application the forms I have done but without the window
of Access. I don't know if it is posible. I set the start options so the
application only merge my forms but over the Access window.
Thanks .

Private Sub UnhideDBwndowBtn_Click()
       SendKeys "~"
       DoCmd.DoMenuItem A_FORMBAR, 4, 4, 0, A_MENU_VER20
End Sub

On July 5th, Jim Fortune contributed the SQL shown below. Its a neat
solution. Original thread was entitled "sql for an A97 query that'll
return 6 future consecutive dates 20-25 days from now"
I'm trying ot use it with a combo box. The combo box RowSource

hi guys, I want to search query through a webpage. I want to set search
criaria a web text filed same we do for forms
{forms]![frmsearchform]![txtsearch].
is it possible I could use a webpage text field as a search critatia.

Dear reader,
I am an occasional user of MS Access 2000 running on Windows 98. My hobby is
ship model building so I made a database for things that I want to buy.
After two strokes I bin unable to remember or find how to calculate the sum

I had a form (Form12) with a code error in it. I knew it was there. I
even planned on fixing it (someday). I needed a comprehensive test
of all my code so I clicked Debug, Compile All Modules. My standard
modules were all good but the compilation test halted in a Class

I have a table of records, many of which are repeated or differ in 4 of the
6 fields only.  I want to show only those records on a continuous form that
are unique in the first 2 fields.  That is as long as the first 2 fields are
the same, I only want one to display, regardless of ...

I have a VC++ application which uses a MS Access DB. I use DAO classes
to carry out operations on the database. Off-late I have been
experiencing a crash (of the application) after trying to execute a
delete query. This happens only when the size of the DB reaches around

A perplexing one this.
I Am trying to design a query or series of queries which will firstly
identify a condition.
If column A value is  less than  column B value make column C value =1 ,