Search results

thanks for the tip on the textbox naming... iw ill follow that from now on. when i click the third record in the continuous form i notice the id in the first record is highlighted. when the next form opens it pulls the record from that id. is there something i could add in my code to activate...

I have a continuous form that wont open another form with the onclick expression when there is criteria. stDocName = "frmITEMSEARCH" stLinkCriteria = "[ID]=" & Me![id] DoCmd.OpenForm stDocName, , , stLinkCriteria is there a setting i am missing?

is it possible to write vba that would only take a part of a text box and copy the value to another text box. if text box 1 displayed "J:\TEMPLATES\Strong Reveal.jpg" text box 2 would display "J:\TEMPLATES"

Me.PHOTO = " & Me.text36 & " & Me.FILENAME & "\" & Me.FILENAME & ".jpg" can someone tell me what I have to change in the " & Me.text36 & " part so that the value displays the value in text 36 and not the words me.text36

I have scratched my head on this for awhile...if the time out is 2:30pm it shows "18" if its 1am it shows "0" however 2am, 3am, 4am are all good... If Me.Time_Out.Value >= ("12:00am") And Me.Time_Out.Value <= ("5:00am") Then Me.appy_hours.Value = DateDiff("h", [Time_in], "12:00AM") + 24 Else...

my query lists duplicate records which I append to a new table. from that table I would like to delete the duplicates but save the first record of each duplicate. example the fields are employee and date worked. I would like to keep joe smith 1/1/14 but delete the other joe smith 1/2/14 and joe...

I would have thought "tag" would help in this instant, but it doesn't. Again what I am trying to do is instead of having a label next to my text box that says "enter date here", I want "enter date here" inside my text box...the message goes away when the user is inside the textbox. the textbox...

i tried what you suggested...since my field is formatted for time it didn't like when I inputted text. any other suggestions

im new...I was wondering if I could display "enter date" in my date text box on my form...when the user selects the text box, "enter date" disappears

im new so ill explain the best I know how. my parent form has two subforms. when the user double clicks a value on one subform it populates the first blank field in the other subform. I created a code for the double click on the subform Forms!frmeventbuild!Form.frmBUILDsub.EMPLOYEE.Value =...

WORKS GREAT!!!! thank you!

I am trying to put a value of a text box in my msgbox...can someone suggest a fix for my vba. MsgBox "SAVED IN DROPBOX. BILLING FOLDER" & Me.EMPLOYEE & ", vbOKOnly"

the subform is a data sheet. the user can jus select a rcord or a feild in record. the source of subfrom 2 is a query whos criteria is based on the date in subform 1. subform one has many dates. when the user selcts a different record with a different date the other subform needs to requery. i...

i have a form with 2 subforms. when the user selects a record in subform one. the date of that record filters subform 2. in the source query of subform 2 i have this under criteria[Forms]![frmeventbuild]![frmBUILD]![EVENT_DATE]. i think reuery would help me but i dont know where to place it...

[Forms]![frmdatesum]![frmHOURSUMnowork].Requery [Forms]![frmdatesum]![frmHOURSUM].Requerythis worked by placeing the vba in the onexit.

i have a main form with three sub forms on it. when i update subform 1 i want subform 2 and 3 to update...can some one help..currently i have an after update event in a combo box subform 1[Forms]![FRMDATESUM]![frmHOURSUMnowork].Requery [Forms]![FRMDATESUM]![frmHOURSUM].Requery when the user...

the source table needs to be formatted as short date...my form is pulling data from a query and I would like to change the row source of my combo box on the form to be formatted in long date. row source is as followed SELECT [qrydateSUM].[day of event] FROM qrydateSUM ORDER BY [day of event]; I...

If Me.Text250 = BETWEEN \ -15 And 15 Then Me.Label253.Visible = False Else Me.Label253.Visible = True End If Even when text250 =8 label253 is visible.

setting the default value of the checkbox or adding a message box still produces the error "you cant assign value to the object" im guessing because by the time the user gets to the question (on the second form) A record has already been created...i guess you cant apply a default value to a...

im new so bare with me. after searching the net, i think my issue is that when the user opens my form a record gets created. Thus default value will not work. what happens is; the user fills out form 1 goes to form 2 and on form 2 i want a check box default value to be true...but its always...