I am not sure if this is the correct forum for this question, however, at
least there seems to be some traffic here!
I have a boss that wants me to develop a database that can be put on an
internal web.  Is this possible?  Actually, he wants me to take quite a few

I know this is off topic but can someone point me to the correct place?
What is the equivalent to "RecordsetClone.RecordCount" For forms?
If Me.RecordsetClone.RecordCount = 0 Then

How do i refer to a field control within a sub form of a form on  a page of a
tab control?
tried a few ways e.g
[Forms]![Main tab]![Batches].[Form]![Batch Number]

I am new to access so I will like some assistance with code to perform a task.
I have created a form called Trade Interface, this form has fields of
Symbol, Description etc.  The trade interface form is tied to the trade data
table, however the fields mentioned above are tied to ...

I need to make sure that a field in the subform will not be left empty.
Also I need the field to get the focus.
How can I?
Thnx

Is there a way that I can instantiate a Collection that is not a member
of any form, but is accessible to all my forms?
Thanks.
- Paul

I would like automate some records in a table.
I have a form with a tabcontrol. There are 4 tabs and each one has a
subform control.
Tab 1 for input of student info

I really need to output a report to office document image writer and I
need to do so with code. Can someone post an example of how to do this?
Please, please, please!
-thanks

I have a continuous form for the user to review and delete records;
ultimately all the records will be deleted. Then I want to close the form.  I
use HasData and get an error  "you entered an expression that has no value."  
Well, all the records are gone, but how do I get around ...

I am running Access 2K on a W2K machine.
I want to test a form to see if it has any records and if not close the
form.
Code that works:

Why use something like Me!field rather than me.field within code for a form???
or vica versa for that matter

How can i make a table hidden thru code?
Thank you for your help.

Hello,
On 8/4/05 I submitted a question on combo boxes which David Cleave answered
(and really helped me out : ) )
I have a follow up now, when I added the VBA code to the "afterupdate" for

I have a customer database and a payments database. I want to open a form and
create a new record in payments and have data from customers for a specified
customer number available. How can I do this?

I have a combo box with the following as its row source:
SELECT -1 as AddNewChoice, "<add new client>" as Bogus FROM
[tblClients] UNION SELECT [tblClients].[intClientID],
[tblClients].[strName] FROM [tblClients] ORDER BY [strName];