Seems more trouble than is worth. Plus it doesnt affect my functionality, was just trying to make it look purdy.
I was using >L<???????????? ??
Edit: Thank you for your time looking up those links.
Rotor
Last Activity: May 31 '07, 05:41 PM
Joined: Nov 14 '06
Location:
-
Input mask upper case first letter of each word in field.
Okay I know how to upper case the first word. However, how do I make it so first letter of each word in the same field is capitalized?
Thxs. -
[QUOTE=Rotor]
Here is the code I placed in the form "FormAcftJobsCo mp":
Okay after troubleshooting , the above code is the problem. If I eliminate the code, the form opens fine. Ofcourse the field data is not copied over. I tried a couple of things. But it seems every time I remove the code...Code:Private intWOorWRI As Integer Private Sub Form_Open() intWOorWRI = Me.OpenArgs End SubLeave a comment:
-
Hello,
Sorry to comeback to this so late, but had a really busy week. Anyways, I tried the Debug code and nothing happens, still same error. Is this code supposed to print to a txt file?
Thxs.Leave a comment:
-
On Monday I'll try going back with the original suggestion (Now that the field name has changed) and see if that helps. Being an Access noob, is very possible I may have borked something in the DB, but dont know what to even look for hehehe.
Also, the calling form is always open, so that wont be a problem if I try the other workaround. The only problem I see, is that with this code will it remember which record the user clicked?...Leave a comment:
-
Thiking outloud here, but while working on parameters queries based on a form, I learned that [Forms]![FormName]![FieldName] instructs access to obtain teh value of the field control in the form from the Forms collection. This becomes the criteria for running the query.
Can this not be done in like the OpenEvent of the form that I going into? LIke on open set focus to WOorWri, and then in the OnFocus event for WOorWRI put in the...Leave a comment:
-
Disregard this statement, I was mistaken....Leave a comment:
-
BTW, one question I did not answer is that WOorWRI field are number fields.Leave a comment:
-
Sorry, no dice NeoPa....the only thing I noticed between your code and the initial iteration I tried is the brackets and quotations around the field name?...Leave a comment:
-
Code:Private Sub WOorWRI_Click() DoCmd.OpenForm "FormAcftJobsComp", acNormal, , , acFormAdd, acWindowNormal, Me.[WOorWRI] End Sub
I am lost. I copy pasted the code you posted, I only changed the field name. The split in my post was just for posting purposes, in the editor the line is one continuous line. As such:
...Code:DoCmd.OpenForm "FormAcftJobsComp", acNormal,
Leave a comment:
-
Okay, I renamed all pertinent fields to "WOorWRI"
Here is the code in the subform to open "FormAcftJobsCo mp":
Here is the code I placed in the form "FormAcftJobsCo mp":Code:Private Sub WOorWRI_Click() DoCmd.OpenForm "FormAcftJobsComp", acNormal, , , acFormAdd, acWindowNormal, Me.[WOorWRI] End Sub
...Code:Private intWOorWRI As Integer
Leave a comment:
-
Okay, I am going to eliminate this variable by changing the field names, then I'll get back to ya with the rest. That way we know for sure that is not the problem....Leave a comment:
-
Okay, parenthesis fixed. Thxs.
Now to deal with that other thread :). I am going to address the field naming issue foist, then get back to you with the rest....Leave a comment:
-
Okay, subform "SubFormAcftWor ked" resides within "FormEntryP age" as a quick preview for my users of hull# and associated WO# recently worked. It displays the last 10 records from its correspoding table.
By clicking field "WO/WRI#'s" form "FormAcftJobsCo mp" is opened where the user can enter a new job done. I would like for the field "WorkOrder/WRI" in form "FormAcftJobsCo mp"...Leave a comment:
-
NeoPa, I appreciate all the help you all have given me for the past few weeks. I in no way expect immediate help, nor for you stay up into the wee hours of the morning on my account. Now, sleep well, and then work the next 48hrs straight until problem is solved ;). Just kidding. Again, thxs for your help....Leave a comment:
-
Good Morning Neopa,
I tried the above and I am getting a syntax error. Here is the SQL:
Hope I layed it out okay for ya, wasnt sure what you meant, so I assumed to mean to break it up in the window....Code:And ((tblAcftJobsComp.[Created Date Local]) >Nz([Enter Date mm/dd/yy], DateAdd("d", -30, Date()));Leave a comment:
-
Thank you. You know the blind squirrel gets a nut once in a while. :)...Leave a comment:
-
Okay, so I tried this:
It opens form, but the wo# is not autofilled, all...Code:Private Sub WO_WRI___s_Click() DoCmd.OpenForm "FormAcftJobsComp", acNormal, , , acFormAdd, acWindowNormal, "<WorkOrder/WRI>" End Sub Private Sub Form_Activate() Me![txtWO/WRI#'s] = Right(Me.OpenArgs, Len(Me.OpenArgs) - InStr(Me.OpenArgs, ",")) End SubLeave a comment:
-
Okay, back to these instructions. I know realize what that I was in the right spot all along, just got confuse by the terminology in VBA editor.
Okay, so I am in
Private Sub WO_WRI__s_Click () where I Put the following:
End SubCode:DoCmd.OpenForm "FormAcftJobsComp", acNormal,,, acFormAdd, acWindowNormal, "<WO/WRI#'s>"
Now does the this code:
...Code:Private Sub Form_Activate()
Leave a comment:
-
Okay, i think I know what I am doing wrong, or not doing for that matter.
How do I get to this spot in the VBA editor?
I figured this one out:Code:DoCmd.OpenForm "FrmJobAccomplished", acNormal, , , acFormEdit, acWindowNormal, "<hull#>,<WO#>"
...Code:Private Sub WO_WRI___s_Click() Me![txthull#] = Left(Me.OpenArgs, InStr(Me.OpenArgs, ",") - 1)
Leave a comment:
No activity results to display
Leave a comment: