Opening A Form With A New Record

Feb 2, 2006

I have a switchboard form that opens with the database. One of the buttons on it opens up a standard form for entering names and addresses.

I created the button with the button wizard, so the standard code:

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Enter Details"
DoCmd.OpenForm stDocName, , , stLinkCriteria

However, this opens the form with record 1 loaded. There is a danger that someone might accidentally enter data over that, so I would like it to open up to a blank record (at the moment, users have to know to press the ">*" button). How can I do this?

Thanks in advance for any help... and for putting up with me of late! ;)

View Replies

Selecting Record In List Box And Opening That Record In Another Form

Sep 16, 2011

I created a search form that searches for Customer Number, Part Number, and Revision Number. The results are displayed in a List Box.

I want the user to be able to make a selection on the List Box and click an "Open Selected" button that launches that record in another form. How is this possible?

View 9 Replies View Related

Form Opening To A New Record

Oct 28, 2005

Another Simple one From jeff.

Upon opening a form how do you get it to open to a new record rather hen the first record. Thanks All. Jeff

View 4 Replies View Related

Opening A New Form At A New Record

Dec 24, 2005

looking for help again!!

i am trying to switch between 2 forms using a command button..

i have 2 things i am trying to achieve

i want the form to open up at a new record as at the moment it seems to be opening at the last record created.. i have tried to use an open form function for new records but that doesnt seem to work.

secondly i have tried to use the code below to go to the next record then close the form and open a new one...

DoCmd.GoToRecord , , acNewRec
DoCmd.Close
DoCmd.OpenForm ("Welcome Page")

but so far all it does is open the new form it doesnt go on to the new record in the current one!!!

hope it makes sense

cheers

si

View 4 Replies View Related

Opening A New Form At A New Record

Dec 24, 2005

View 4 Replies View Related

OPENING Form And CREATING New Record

May 4, 2007

hello,
I have form "QUOTE" (which has a check box "GenerateOrder") and form "WORK_ORDER". Once I click on "GenerateOrder", I want form "WORK_ORDER" to open, and I want to assign a value from a txtBox in form "QUOTE" to another txtBox in form "WORK_ORDER" creating in this way a new record on form "WORK_ORDER". I want to make clear that as soon as the value is passed or assigned to the txtBox in form "WORK_ORDER", a new record for this form should be created.

I tried this code:

Private Sub GenerateOrder_Click()
If (Me.GenerateOrder.Value = True) Then
DoCmd.OpenForm (WORK_ORDER)
[Forms]![WORK_ORDER]![QID] = [Forms]![QUOTE]![QID] 'assignment
End If
End Sub

but it doesn't work

Thank you very much

View 2 Replies View Related

Opening One Form From Another Using Current Record

Mar 25, 2005

I would like to create the following functionality on a form in my database:

When the form is open, and a record is displayed on the screen, I want to add a button that will open up a second form displaying information related to that record.

To be specific, I have a form called "Contracts". Each contract record contains a customer name in the field "Customers." I want to create a button labeled "Customer Details" that will open a new form, "ViewCustomers" displaying the record associated with the value entered in the "Customers" field for the current (displayed) record only.

I have been trying to use a hyperlink to a macro that uses "OpenForm," form name "ViewCustomers," but I don't know how to filter it down to just the current record.

I hope any of this makes sense. Any insight would be really helpful.

Thanks! -Matt

View 2 Replies View Related

Opening A Form At A Specific Record

Dec 23, 2005

Hi all

Im currently designing one of my first databases!

I've initiated a log on procedure, with a password.

A user enters their ID and password. Once the correct password is entered, the next form is then loaded up, to which they make some choices.

My problem is that I have lots of users, and I would like them to only access the page that is relevant to themse, and NOT be able to see anyone elses.

I gather there is a little bit of tweaking to go on the
docmd.openform...

line, and somehow incorporate the userID, but not entirely too sure what it is.

Apologies if this seems really easy!

All help appreciated - many thanks!

View 2 Replies View Related

Record Count Before Opening Form

Feb 16, 2006

Guys

I've searched the database and found similar problems but don't understand the replies (mainly DCount()).

I have a control form where a user can search the database by entering information. The form asks them to type some text that will appear in a description field, and match any records with the same text.

However, when the user types the text and clicks the button to open the form (which is linked to a query searching the description field), I want a message box to say no records found before opening the form. Mainly because when it doesn't find a matching record, the form opens with a new autonumber.

I either want a matching record to appear, or a dialog box saying no matching records found and the form not opening therefore not creating a number that is not used.

I tried in the command button entering if recordcount>0 then openform but it doesn't like the else statement or doing a if recordcount=0 underneath.

Any ideas?

View 5 Replies View Related

Form Opening And Record Locking

Oct 5, 2006

Hi,

I am opening a form, from another form, that is based on a table of 20000 records.

I am using the WHERE criteria to do this, code is included below. I need to provide database access to several users on a network (and only want to lock the record that the user has searched for), and was wondering if this mode of data access will lload and or lock all 20 000 records on the users sytem, or if it will just load and lock the specific record that has been opened using the WHERE condition to open the form...

Advice appreciated.

Regards

Mack

--------
CODE
--------
stDocName = "frmCONTACT"
stLinkCriteria = "[contactID]=" & Me![ContactID]

DoCmd.OpenForm stDocName, acNormal, , stLinkCriteria

End Sub

View 5 Replies View Related

Blank Record Upon Opening Form

Oct 31, 2006

HELP
When the user double clicks on the icon, the form automatically appears on the screen. That's good. But record number 1 is there. I want a blank record there so they can enter their data. This can't be difficult, but I can't figure it out.

View 2 Replies View Related

Opening A Form To A Specific Record

Dec 10, 2004

I have a Calibration form, with a button on it that links to an Equipment Inventory form. In the Calibration form, you choose
the instrument you want to calibrate from a combo box (which in turn automatically selects the barcode number for the instrument in another combo box), then if you need to edit info on it (ie. serial number), you click the button

Now, I need the Equipment Inventory form to open to the record that matches the bar code in the second combo box

anyone know a simple way of doing this?

View 1 Replies View Related

Opening A Form To A Specified Record Number

May 7, 2005

If I have an unbound text box (Number of Episodes) with a control source =Count[(UR]) how can I make the form open to the highest number. (ie if a person has two episodes how can i get the form to open to the second one?)

View 1 Replies View Related

Forms :: Opening A Form At A Particular Record In Set

Feb 8, 2015

I have a table with a schedule of tasks that are required weekly for the next year. Each record has Monday's date as the Scheduled_Date" for the task. From my main form, I have a command button to open a form linked to the table, so that amendments can be added to the table for each record (i.e. - If a task is complete/incomplete/progressing etc. the user marks it so.

What I would like to do is have the form open at the task scheduled for the current week, based on the "Scheduled_Date" value. Whilst I can do this with a simple filter, I would like the form to open with all records available to the user so that they can go forwards/backwards as they wish, but the first record they see when the form opens is the one specific to this weeks date.

View 4 Replies View Related

Macro Or VBA For Opening A Form In Particular Record

Jan 30, 2013

Self tought in Access07 but I'm trying to do the following:

I've got a form (Clients_F) that has a subform in datasheet view with a list of quote numbers made by each customer, I have managed to make a Macro after a few hours and googling, that opens another form (Quotes_F) so that it can be edited when a quote number is clicked, but I wish to be able to open Quotes_F as a new record when the empty field under the numbers column in the list is clicked.

Also want to know if it's possible to mantain the Customer's details pre-filled?...I am guessing that this is done through the CustomerID(PK & FK)?

View 9 Replies View Related

Default Blank Record When Opening Form

Sep 25, 2006

Hi,

I have a form which is based on a table.

I was wondering if it is possible that when the form is opened a blank record could be displayed rather than the first entry in the table. In other words, it would be like opening a form and clicking the "Add Record" button, a blank record would be displayed and data entry could take place.

Any thoughts/ideas would be much appreciated.

Thanks in advance
Turbojohn

View 5 Replies View Related

Opening A Form Based On Individual Record

Oct 6, 2004

All my records are displayed on a form. Upon clicking on their respective 'View' button, I would like to open that particular record. How can I do that? I have attached a screenshot for better clarity. Thanks in advance for the help!

Regards,
Swee

View 3 Replies View Related

Check Record Count Before Opening Form

Dec 22, 2004

How do I check, before opening the form, whether any records exist in the table bound to the form?

Thanks

View 3 Replies View Related

Opening A Form Relating To A Record In Datasheet

Jul 16, 2006

In Filemaker, when you open a table in datasheet view and then select a record you can then open the form relating to this record. Can you do this in Access - I can't get it to work.

View 2 Replies View Related

Forms :: Opening Form To A Specific Record

May 8, 2015

I've done this dozen's of time - but it doesn't seem to be working now. I have a continuous form (frmHome) where i want a user to be able to click on a record, and be able to open up that specific record in "frmCustomer". The key field here is pkCustomerID (i have it in the query).

frmHome is run off a query ("qryCustomer").

frmCustomer has "tblCustomer" as the source.

The code i've used on a button on "frmHome" is:

DoCmd.OpenForm "frmCustomer", , , "[pkCustomerID]=" & Me!pkCustomerID

It always only open Record #1.

View 7 Replies View Related

Modules & VBA :: Opening A Form To A Specific Record

Nov 21, 2013

I have a table that has two forms linked to it - one is the Main Form which is used to input the data for the bulk of entries, however on some entries there will be some additional data required which the other form (lets call it Time Form) takes care of.

What I would like to do is have a button on the Main Form that opens the Time Form, and then go to the specific record that is open on the Main Form;I have an ID field (Autonumber + Primary Key) which displays in a text box on the main form, and it would provide the number of the record for the second form to open.

View 7 Replies View Related

Forms :: Opening Form To New Record In Subform

May 20, 2013

I have a form with a subform. Every time I open the form I want it to open to a new record in the subform (but not necessarily a new record in the main form; that will depend on some other stuff that I've already taken care of).I found a way to do that using the following VBA in the main form:

Private Sub Form_Current()
Me.EventSubform.SetFocus
DoCmd.GoToRecord , , acNewRec
End Sub

It works great, but it causes Access to automatically scroll down to the start of the subform, blocking the view of information in the main form that the user needs to see. I've tried adding a line to Form_Current() to reset the focus to the main form but it doesn't seem to work.

View 5 Replies View Related

Create A New Record, Opening A Form Based On The Key Field

Jan 28, 2005

I seem to need some help!
I have a table with customer information in it ie: name, vehicle, (Key=Id number)...
it is the master link to the repair table ie: mileage, (Key=ROnumber), and repair data..
these two work together beautifull
now I need to add another table, a check sheet for checking over a vehicle.
I create the table and the form however I cannot open a new form with the ROnumber from the second already open form into the newly open form.
(the second form is based on a Query, and I have tried changing it to a SQL statement both with no luck)
is there an example of what I need to be doing to link the ROnumber to the ROnumber in the new form, or create the ROnumber so it will add the data in the linked table?
I need this to open using a button on the open repair form
David

View 1 Replies View Related

Opening Popup Form With Current Subform Record

Sep 7, 2005

Hello,

I am trying to run a macro on doubleclick in a subform (dataview) that will open the same record in a popup form (tabular).

I've enter in the macro Where Condition the following statement to only show the record I doubleclicked on in the popup. The only problem is it's asking me for a parameter value for the LogID. Its apparently not picking up the LogID I doubleclicked on. Is there any way I can fine-tune this WHere statement so that it knows the record LogID I clicked on. (The pop up form should show only the same record).

[LogID]=[Forms]![CommunicationLog Subform]![LogID]

View 1 Replies View Related

Modules & VBA :: Module Opening Form With Blank Record?

Sep 10, 2014

I have the following module in my database to allow for multiple alarms.

It all works great, except before showing the actual alarm record called, the form first pops up showing the first record in its record source.

I.e. it flashes up showing the first record in the table, then changes to the 'correct' record.

I would just like to change it so it either doesn't show until the record is loaded, or it shows blank to begin with.

Here's the module...

Code:
Option Compare Database
Option Explicit
Public clnPopUpAlarm As New Collection 'Instances of frmPopUpAlarm

[Code].....

View 2 Replies View Related

Forms :: Opening Form To A Specific Record From Subform

Jan 28, 2014

I have a form that displays details for a specific asset and a continuous subform that lists all the purchases for that asset. I have the following code in the On Click event for one of the fields in the subform:

Dim myOrder As Integer
myOrder = Me.txtOrder
DoCmd.OpenForm "frmOrders", acNormal, , "OrderID=" & Order, acFormEdit, , "Edit"

The problem is, when I click on any item in the subform, the code returns the value of the first item in the form rather than the one clicked on. If I open the subform on its own (outside the main form) then the code works fine. I can't figure out why it won't work in a subform.

View 6 Replies View Related