I want to open a form with DoCMD.  How do I set it to open set to a new
record?
Thanks

I have written the following:
[Form].[frmTranser].[ReceivedDate] = [Form].[frmInventory].[ReceivedDate]
It does not copy the date format (mm/dd/yyyy) with an input value of
00/00/0000;0;"_" properly.

Hi
I've designed  in access , a password form in which a textbox,cancel and Ok
commands are used . In form timer I wrote an   If code  as follows :
<< If text.text="password" then  OKcmd.enabled=True

Please advice,
In order to detect a new record I using On current event:
Set Rs = CurrentDb.OpenRecordset("TBLtemp1", dbOpenDynaset)
If Me.NewRecord Then

I have a project based on the Northwinds Traders sample database. On the
Invoice header (Orders Table) I would like to put  check boxes for selecting
a price field. Price A and Price B.
On my “Orders Details” Subform Items from my “Products” table are entered. I

I am creating a page for users to search customer information.  I have
created an unbound text box for each corresponding field on the customer
form.  The user can then enter customer information on the search page and
be taken directly to that customer's form.

I have a form that is populated by a query against some sql server
tables....when ever the query pulls up only one record im fine..however if it
pulls up more than one record i have to make sure i click in the boxes or hit
the navigation arrows or something active or else I get ...

Perhaps stupidly, when I started writing a database I
broke with tradition and made my own 'hover-buttons'
instead of using command buttons:
Basically, the buttons are text boxes using the following

In Access 2000, I have a form which is set up as a continuous data sheet.
Whenever the user adds a new record by tabbing to the next row and entering
data, I need a foolproof way to enter the data below into the new record.
Right now, I am using the form's AfterUpdata event as ...

I have been working with Duane Hookom's AYS app in Access 2003
standalone and am having some difficulty making its Responses subform
"Rspns" dropdown box have certain custom behaviors depending on which
question is being asked.

MS Access 2K, Windows XP
====================
Hi,
I have a multi-user database application which is a single MDB file on a

I have a tree with many forms behind it.  You can click on a detail button
and then go to the detail to update information, delete, etc.  What is the
best way to refresh the treeview after changes are made?  I need to refresh
the data and also eleminate / add nodes.  Right now I ...

I have figured out how to search multiple fields using the following code:
DoCmd.OpenForm "Form1", acNormal, , "Field1 Like '*" & Me.Text1 & "*' AND
Field2 Like '*" & Me.Text2 & "*' AND Field3 Like '*" & Me.Text3 & "*'"
This code allows that user to search by any of these three ...

I am using the following code to search for records in my database:
DoCmd.OpenForm "Form1", ac Normal, , "[Field1] Like '*" &Me.Text1 & "*"
This works for a single field, is there a way to write the search so that I
can incorporate multiple fields?  Can I use "AND" so that the user ...

When opening a form, my subform isn't visible. This subform contains a
register with two forms (register card mother and register card father). The
user can open a popup and from there the subform is made visible, but only
one register card at once. This is working fine for the ...