I updated the code to the following:
Code:
If Me.subfrmLotInfo.Form.Controls("LotNo") Is Null Then
I verified on the subform there is a text box with the name of "LotNo"
DJRhino1175
Last Activity: Sep 11 '23, 05:12 PM
Joined: Aug 18 '17
Location: USA
-
NeoPa,
I updated the code to the following:
It compiles just fine, but when I run it I still get the same "Runtime Error of 424: Object Required". I go to debug and it highlights the line of code above.
I verified on the subform there is a text box with the name of "LotNo" -
NeoPa,
When I go into design mode and look at the "Name" of the control[sub form] it says "subfrmloti nfo"
I did read the article link you gave and based on my under standing I did the following:
It compiles just...Code:If me.subfrmLotInfo![SectionID] Is Null Then MsgBox "You are required to enter your Material Lot Info", vbCritical, "No Material Lot Info"Leave a comment:
-
This is intentional, the form is bound.
No this is the name of the subform...Contr ols are "Section", "Material" and "LotNo" - I'm guessing this is where I went wrong. I need to add a control to the code, like "subformlotinfo .section"....
OK
Most likely because of no control in the code...
I just need to check if there is data in the subform linked...Last edited by NeoPa; Sep 7 '23, 10:04 PM.Leave a comment:
-
Cancel Print Action if Sub form has No Records
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this -
Here is the code as a whole...Code:If subfrmLotInfo Is Null Then MsgBox "You are required to enter your Material Lot Info", vbCritical, "No Material Lot Info"
...Code:Private Sub CMBPrint_Click()
-
Isla,
Thanks for the assist. I will give it a shot. It worked like a charm.
ThanksLeave a comment:
-
Isla,
No I have not been able to fix this issue as of yet. I still need help.Leave a comment:
-
MSGBox win conditional Formatting is True
I have conditional formatting in a textbox based on a value of another textbox.
When this code is true in turns the font Bold and Red of the txt box [Actual]Code:[Actual]>[Est Target]
What I need help with is how do I trigger a msgbox based of this conditional formatting? Or would it be better to do an after update code that does the conditional formatting and trigger the msgbox? -
Thanks Neo, I forgot all about the hide form feature.Leave a comment:
-
I did get this to work. I need the code to be on the form that is open all of the time and not my start up form.
Thanks for the attempt to help.Leave a comment:
-
Ok, I tried the stripped down database with the one table and the code above and 2 forms. One is the pop up box that says closing in 10 secs. The other form is just a dummy form with buttons on it that do nothing. In the first try it worked on my PC and 1 of the production line pc's...The timer is set for 20000 milliseconds on this test database.
We only have a reginal IT guy who is here 2 days a week. I rarely have access to him....Leave a comment:
-
Neo,
I'll try what you asking. with a blank Database with the codes you listed.
AV software is, to me at lest, looks like they are just running windows security.
Due to a cost cut, they uninstalled 365 from most of the accounts and installed free versions of Word and excel. I had them install Access Runtime as only developers needed the full version to create databases.
The database were...Leave a comment:
-
I have a timer event on the form that is 120,000 milliseconds. The code above checks in a table whether "systemUp" yes/no Box is checked or not. If its checked the system is up and running(Not in maintenance mode). If the box is unchecked then it triggers the above code. This code then triggers a pop up form that has a 10 second timer on it which then quits access. So what I have done to test this is uncheck the box in the table while my...Leave a comment:
-
This works on all Office 365 Access installs except for the runtime . All front ends are in the same location weather they are runtime or not. All other codes I have work just fine. Its only this timer event that doesn't work with runtime. Not sure about security settings for runtime as there isn't a ribbon or anyway for me to go into security settings, at least that I know of.Leave a comment:
-
Microsoft Access Run-time Timer Event No Firing
I'm running the following code in the timer event section when my database opens. It works on the my Office 365 version, but doesn't seem to fire on the run-time version of access. My database is on a network in a FE/BE setup. There is a yes/No box in my table called "ztblSystemStat us". When I uncheck this box and close out the timer should run out and this code should run and close out the front end's that I have out on the manufacturing... -
That would be my guess. I just kept tinkering till it just decided to work. I believe it was in my filter somewhere.Leave a comment:
-
I ended up figuring it out...ThanksLeave a comment:
-
Runtime Error 2487
I'm getting runtime Error 2487: The object Type argument for the action or method is blank or invalid
It triggers at line 36
I have been using this code for awhile, but all of a sudden it stopped working. Can anyone see something I have wrong?
...Code:Private Sub btnAuditEmail_Click() On Error GoTo Error Dim strEMail As String Dim strSubject As String -
I did build a database based on what's in the code above and had to add a reference to Microsoft outlook. Once I did that everything compiled. So I tried running the code using a Click a button, but nothing seemed to happen. When I opened outlook no new appointment was made. I hope this helps with getting this figured out for the one asking the question.Leave a comment:
-
I do something similar, but not with dates. Here is the code I use and should get you what you want.
Code:[Field]=[Forms]![Form Name]![Field]
Leave a comment:
-
Neopa,
I was able to get it. I had "frmSelRTNo " set up incorrectly and didn't have [Select] set up right in the query for the close form. Tried it 3 or 4 times and it worked every time. Worked like a charm. Thanks for your assistance.Leave a comment:
No activity results to display
Leave a comment: