This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
Course Of The Month
6 days, 22 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Access - New Record on Subform (Docmd or RunCommand) from that form's Tabbed Form
Posted on 2012-12-20
Hello all!
I have a Main form on that main form I have
1 subform (with it's own subform) AND also
1 Tabbed Form with the tabs of the Tabbed Form having Subform's on them.
I am attempting to transfer info
FROM:
One of the Tabbed Form's Subform
TO
The other Subform of the Main Form
When I click a command button on one of the Tabbed Forms Sub it is transferring the data to the other MainForm's Sub but I can not get it to go to a new record on that form.
When i use Docmd
I get an error
Run-Time error 2498
An Expression you entered is the wrong data type for one of the arguments.
DoCmd.GoToRecord , Forms![frm_Inv]![frm_ctl_M
If I put quotations around the Form name I get the object. xxxxxxxx isn't open.
If I put Open/Close parenthesis around it (no quotations) I get the same "wrong argument" error.
How can I correct it?
I have a Main form on that main form I have
1 subform (with it's own subform) AND also
1 Tabbed Form with the tabs of the Tabbed Form having Subform's on them.
I am attempting to transfer info
FROM:
One of the Tabbed Form's Subform
TO
The other Subform of the Main Form
When I click a command button on one of the Tabbed Forms Sub it is transferring the data to the other MainForm's Sub but I can not get it to go to a new record on that form.
When i use Docmd
I get an error
Run-Time error 2498
An Expression you entered is the wrong data type for one of the arguments.
DoCmd.GoToRecord , Forms![frm_Inv]
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
4
9 Comments
Active 5 days ago
Records should be added to tables, so you can create append query and run it.
Try this syntax if you like follow your idea:
docmd.GoToRecord acDataForm, Forms![frm_Inv]![frm_ctl_M
I hope form [frm_Inv] is opened
Try this syntax if you like follow your idea:
docmd.GoToRecord acDataForm, Forms![frm_Inv]![frm_ctl_M
I hope form [frm_Inv] is opened
Thanks for replying Als315
Made that fix. Still get "Run-Time error 2498
An expression you entered is the wrong data type for one of the arguments."
Just to Reiterate, this Main form has 1 subform Plus 1 Tabbed form with Subforms. I'm trying to get it to move data from the Tabbed Form's Sub to the Main Form's Other Subform.
When the Main form opens, the Subform (not the Tabbed form's sub) opens with "New" in the Record. The command button on the Tabbed Form's Sub does work to transfer the first line of data into the Main Form's Subform but when it hits the dcmd....acnewRec is where it is erroring.
Since that SubForm is on the Main Form and both the Main form, the Tabbed Form and the SubForm are all open, isn't the SubForm therefore open?
Made that fix. Still get "Run-Time error 2498
An expression you entered is the wrong data type for one of the arguments."
Just to Reiterate, this Main form has 1 subform Plus 1 Tabbed form with Subforms. I'm trying to get it to move data from the Tabbed Form's Sub to the Main Form's Other Subform.
When the Main form opens, the Subform (not the Tabbed form's sub) opens with "New" in the Record. The command button on the Tabbed Form's Sub does work to transfer the first line of data into the Main Form's Subform but when it hits the dcmd....acnewRec is where it is erroring.
Since that SubForm is on the Main Form and both the Main form, the Tabbed Form and the SubForm are all open, isn't the SubForm therefore open?
Here you go....
when you open it the form is
frm_EstimWorkup
Click on a Process on the Main form which will eventually make the Tab Form Sub visible (left all visible for now) input whatever numbers in the textbox and click save. Should transfer into over to the Mainform's Sub (the right side of the form with blue heading)
TestForm-MainTabSub-MainFormSub.accdb
when you open it the form is
frm_EstimWorkup
Click on a Process on the Main form which will eventually make the Tab Form Sub visible (left all visible for now) input whatever numbers in the textbox and click save. Should transfer into over to the Mainform's Sub (the right side of the form with blue heading)
TestForm-MainTabSub-MainFormSub.accdb
Active 5 days ago
Try this (without newrecord). Only Process01 (Page2)
TestForm-MainTabSub-MainFormSub.accdb
TestForm-MainTabSub-MainFormSub.accdb
Als315
I get a Run-Time Error '2455'
You entered an expression that has an invalid reference to the property Dirty.
Happens when I input numbers on the Page2 Tabbed form Subform sfrm_WkSh01
Stops on If Me.Dirty Then Me.Dirty=False
Private Sub cmdSave_Click()
Dim i As Integer, J As Integer
Dim rs As DAO.Recordset
J = Me.cboInv.ListCount
Set rs = CurrentDb.OpenRecordset("d
Forms![frm_EstimWorkup]![f
If Me.Dirty Then Me.Dirty = False
For i = 1 To J
rs.AddNew
I get a Run-Time Error '2455'
You entered an expression that has an invalid reference to the property Dirty.
Happens when I input numbers on the Page2 Tabbed form Subform sfrm_WkSh01
Stops on If Me.Dirty Then Me.Dirty=False
Private Sub cmdSave_Click()
Dim i As Integer, J As Integer
Dim rs As DAO.Recordset
J = Me.cboInv.ListCount
Set rs = CurrentDb.OpenRecordset("d
Forms![frm_EstimWorkup]
Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses
Course of the Month6 days, 22 hours left to enroll
726 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.