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 Replies


ADVERTISEMENT

Forms :: Opening Bound Form Via Macro Or Docmd?

May 26, 2015

I have a bound form that normally is opened via macro. Very straight forward just has the following in the where.

Code:
[userID]=[Forms]![Home]![txtSelectUser]

I'm trying to open the same form via doCmd.

Code:
DoCmd.OpenForm "frmUserInformation", , , "UserID=" & Me.txtProblemID

I've msgbox'd the txtProblemID and the correct ID is being passed. Where I fall into an error is on the frmUserInformation's onLoad event which uses the ID form the frmUserInformation.txtUserID box. The error I get is "Syntax error (missing operator in query expression '[fldUserID]='."

Code:
strEndMonth = DLookup("fldDateExpiration", "qryUserExpirationDate", "[fldUserID]=" & Me.txtUserID)

What I've narrowed it to is the timing between the docmd.openform and the onload of the form. I've tried changing the onload to be on activate - and it just opens empty.

how to get the docmd to open the form correctly before the onload tries to fire?

View 6 Replies View Related

Opening Autoexec Macro Causes Reference To Outdated Login Form

Feb 20, 2014

I changed the name of a form referenced in the Autoexec macro from "frmLogin" to "frmLoginPW". However when I Open Access 2010 instead of Form "frmLoginPw" opening I get a message box saying that the system can't find "frmLogin". If I do a search through all the code in the project there is NO reference to "frmLogin" as I changed any code to refer to "frmLoginPW" and recompiled the project.

I can not get rid of this error and if I press the OK button on this error message ( from MS Access not my error coding) the "frmLoginPw" opens and the code in the form works. (Password authentication etc etc.). I deleted the AutoExec macro and remade the macro and referred it to the new form "frmLoginPW", this did not work. I loaded the Accdb file using the Run command and the /Decompile command line parameter to no effect.

View 3 Replies View Related

Opening A File With A Macro

Sep 8, 2005

Is it possible to open an Excel FILE using a macro, if so could someone shed some light on this? I know how to open Excel itself using RunApp but it doesnt work with files.

Any help would be appreciated
Cheers all

Bikeboardsurf

View 1 Replies View Related

Opening A Report Using A Macro?

Jan 18, 2013

I have a form in Datasheet view and when you click on a record in that form I want it to take you to a report with all the details of that record number. I have the On Click event set to run a Macro. The Macro is as follows:

OpenReport
Report Name Incident Report
View Report
Filter Name Open
Where Condition =[Event ID]=[Reports]!Incident Report]![Event ID]
Window Mode Normal

This Where Condition works for me open another form from the form with the same Event ID. Why does it come to a "new" Incident on the report?

View 1 Replies View Related

Run A Macro On Change Of Record On A Form

Feb 23, 2008

Hi!
Is it possible to run a Macro each time the user changes the Record on the Form? If so how? :confused:

View 2 Replies View Related

Open Form To New Record With Macro

Dec 21, 2006

I really hate being stupid about this, but I'm running around in a circle and it's making me dizzy. All I want is a simple macro that opens a form (with a subform) at a new record from a button. I know I am missing something obvious so I will let others see if they can find out what has gone wrong. The current macro is:

OpenForm(FormName)..View(Form)..DataMode(Add)
GoToRecord .. ObjectType(Form) .. ObjectName(FormName) .. Record(New)

On the property sheet of the form the following are all set to yes:
Allow Filters, Allow Edits, Allow Deletions, Allow Additions, Data Entry (I suspect the problem is here)
Record Locks is set to No Locks.

When I open the form from the button, it looks right, and I can enter the transaction information, but when I try to enter the subform information or save it , I get "The Microsoft Jet database engine cannot find a record in the table 'NewContacts_tbl' with key matching field(s) 'ContactID'". I get the same message with Allow Data Entry set to no.

And yes the key field IS there, in spite of what the Microsoft Jet database says.

I hope everyone gets a chance to enjoy the holidays and thanks to all of you for your past help and my current (relative) sanity.

A2K
:(

View 3 Replies View Related

Stop Macro On Last Record In Form

Dec 4, 2012

I have a macro that opens up a form called SLA Complete Form - The macro then goes and examines two fields on the form to see if they contain data and if they do not then it displays a popup box with a message.

The form that gets opened up can have anywhere from one record to approximately a hundred records.

How can I get the macro to stop running when it hits the last record on the form without displaying an error message. I am currently using the next record feature in the macro.

View 1 Replies View Related

How To Use Macro To Go To Next Record In A Form With One To Many Relationship

Dec 6, 2012

I used the Control Wizard to create a macro on a command button to do record navigation i.e. go to First, Next, Previous and last record. The macro code, in the macro editor, is inserted on a command button on the form, asks whether it is a table, query form etc. I chose form and entered the form name but the error says the form needs to be open before I can run the macro. This happens when I open the form from a Navigation Control and Click the button containing the Macro code on the form.

View 1 Replies View Related

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

Macro Security Warning When Opening Database

May 15, 2006

Hi everyone,

I was wondering if anybody knew a way to disable the security warning in Access that pops up saying "This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?"

If possible, I'd like to disable the message for just my database, but we currently don't use any other database anyway, so I'm not too concerned with turning it off completely if that's all I can do. I'm sure there has to be an option somewhere to not check for macros or something, but I can't find it.

If anyone knows how to do this or if you know that it is not possible, please let me know.

Thanks,
Sean

View 4 Replies View Related

Wrong Record Selected From Macro Of Open Form Button

May 1, 2012

I have a parent form showing some of the contents of a single record in a parent table. This form contains a button that opens a specific subform (using an IF statement based on the contents of another field in the parent table/form. There are actually any of 8 child forms/tables that could be selected and the related record is in only one of them. The relation between the tables is based on the PK of the parent table and the related FK in the child table. and the data is correct in all tables.

My problem is that when I run this button on the parent form/table it returns the appropriate form/table, but displays the first record rather than the related record. In the past (using this same process) I have been successful in getting to the right record by fiddling with the where statement (sometimes putting in a equal sign or taking it out fixes the problem). However, no matter what I do to the Where statement nothing works. I have not yet placed the final else condition for where the form selection field (VMValIdentType] is empty yet as there is no point at this time.

Here are the button macro contents:

If [VMValIdentType] = "Software"
OpenForm
Form Name: tmpVMValSW
View: Form
Filter Name:

[code]...

View 7 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

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 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 7 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

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







Copyrights 2005-15 www.BigResource.com, All rights reserved