I am trying to refer in code to the RecordsetClone of a subform datasheet
but I'm getting syntax errors.
This is what I am writing:
Set MyDB = DBEngine.Workspaces(0).Databases(0)

(Access 97 and 2003)
Hi,
Here's a smippit of code that works correctly about 95% of the time.
This part of the algorithm...

I have a project going on to store data for inventory information. Creating
a database with access makes me realise all things like the data tables and
user interface(forms) and queries are all incorporated to one file. I wish
to split the user interface from the database table ...

Given a selected date, how do I find the date of the Sunday and Saturday of
the week that that date is in?
Thanks!
Jerry

I have a table with two fields, 'StartDate' and 'EndDate'.  How do I
get the query to select a record that matches a given date that is
between the two dates?

If you have a Header or Footer on a report, can you hide that section if
its Null or Zero?  If so, does anyone know how?
Thanks
DS

Thank you in advance for any and all assistance. I'm trying to create a report
that will work similar to the label wizard in Access. I have a premade form I'm
attempting to fill with data from the db. I can manually make the information
fit, by making the report the full 8.5" x 11", ...

I have a form which contains a number of subforms in different pages of a
tab control.  In the detail section of each subform, I list records related
to the main form record, but from different tables.  In the footer section
of the subform I have a Notes text box and three ...

I have the following headpuzzle:
   On a form (frmAgenda) I have a calendar control and a listbox.
   When user clicks date in calendar, the listbox will show some
   information that will be displayed in several rows.

I have a routine that uses VBA to open a hidden occurence of Excel,
and do background computations.
However, in the event that the routine terminates abnormally, I have
not been able to find a way of closing this Hidden occurrence.  I can

Spent hours till I pinned down that on an XP machine the OpenDatabase
method causes MDE creation to fail while a compile produces no error.
A reference in a Google reference pointed me to replacing reference to
MS DAO 3.51 to 3.6 and this seems to solve the problem.

At some long ago time Steve Jorgensen answered thus:
Subject: Re: How can I round a time?
Newsgroups: comp.databases.ms-access
Date: 1998/12/11

Following some help from www.aspfaq.com, I have used this sql command
to find the constraint name of my foreign key:
SELECT
FK_Table  = szReferencedObject,

What would be the input mask for a name field where first letter is caps and
the rest lower? Its ideal if the mask can handle multiple names separated by
a space but if not a single word will do.
Thanks

I am stuck in the following problem:
. I have an A4 paper size in landscape mode to print 2 invoices, one
on the left middle and next on the right middle.
. Designing the report with 2 columns I can print that with no