I'm trying to find the solutions9.mdb sample database
referenced in KB 248674. I've been through MSDN library but
can't find it. Anyone have a current link to it?
Thanks,

I'm trying to extract numbers from a string stored in an Acces table field.
What is the best method to do this or the correct function to use?
Thanks.

Is it possible to have an update query run at a set time or interval? or to
have it run when ever the database is shut down?

Here's some information on what I'm trying to do.  I own a greenhouse and I
want to keep data on inventory, costs and sales.  Be able to keep databases
on the cost of supplies and be able to pull them together to determine the
costs of pots, flats, and baskets.  I have set up 4 ...

When I was using Access 2003 I was able to enter info. into a field and when
I went to the next filed it would increment the numbers by whatever was
entered.  For example, If I entered 1,2 3, it would continue with 4, 5 6.  If
I eneterd 2,4 6, it would continue to increment by ...

I have the basic details of our invoices (which are reports) displayed on a
continuous form i.e. date, number, customer, amount. At the end of each row I
have a button so that we can open the form on which the invoice was created,
to modify it. That works fine, it opens the ...

i built a find record control button so a user can type in the form number
and go there but it only searches the field that the cursor is in and the
form # is not on the tab order(purposely). How can i specify where the find
record function searches? thanks

I built a database with a form. im not sure what happened but now i cant see
and navigate to previous forms that were filled out. the navigation bar says
"calculating" and then nothing happens. it used to navigate but now it wont.
I've tried opening to new record, previous, first ...

Almost everytime I compact my MDB, which is usually somewhere around
5mb, it creates a db#.mdb, which is around 980kb. After decompiling
then recompiling, it ends up about 1mb.
It seems to be the same file, and all, but why does it create a

Is there a way to get the column name in access while using vba? For example
I have a recordset that uses the valus reset1(1), etc. Can I figure out the
name of the column it selected?

Hi
I have changed the number of decimal places to 2 in the database and in on
the form and the decimal places still does not show.  I tried to enter
numbers with decimals directly in the database and on the form and the result

Access 2000 Sp3/Win XP Sp2/MDAC 2.8 SP1/SQL Server 2000 BE/FE is on a network
share.
This problem is repeatedable only on one workstation.
If I open the FE normally performace is sluggish, delays when clicking

I keep getting the following error message in a query that previously worked
for 2 years.
Function isn't available in expressions in query expression'Format([Billed
Month]),"mmm")

I've read with interest all the posts on creating DSN-less connections.  I
like the idea, and converted my Access db using a DSN-less connection to
retrieve data from an Oracle 9i database.  The Access db file is located on
the network.  When I run the pass-through query from my ...

I'm working in Access 97 and am mostly a novice.
I have a form linked to a table called "Participants".
One of the fields is [Company]. I've got a control for it called
[Companytxt].