Search results

Arnelgp, I like your function idea so I am trying that. I have substituted to Me!SubfrmIODates.Form.RecordsetClone (the subform control name). I changed .Fields("Air Dates") to the control source, so .Fields("Air_Date"). I am getting a #Size! error in the textbox? Thanks, MIB1019

You were right, pisorsisaac. I changed the Default on both buttons to No and the form stays open. I still think it's odd behavior that the cursor doesn't just move to the next field with the Enter key, which is what I want, to make entry of a list of dates easier (one-handed). Guess I can use...

The main form popup has Cancel and OK buttons, both of which have to be clicked to run the code behind them. There is no button in the subfrmIODates. The subform has a label in the header, a field in the footer that counts the number of records in the current list, and the txtAirDate and the...

Thanks, LTrim works perfectly. Form is almost ready...yay! On entering dates in the subform, I've got keyup and keydown events working properly, to move up and down in the list, but the enter key causes the dialog popup to close entirely. What's up with that? MIB1019

Thanks for that! SQL needed apostrophes in the format function, rather than quotes. On to figuring out how to trim the leading space. y’all are THE BEST! mib1019

Spaces are okay now, but I don't see how to add format to the dates in SQL. I did a query with that SQL statement, brought it to Query design, added a format, which works, but don't see SQL reflecting that format. I also have a leading space on the first date. Thanks! MIB1019

Okay, that works, but with no spaces after the commas and need the format of the dates to be simply 'm/d'. My inexperience is showing :/ Thanks for the advice there! MIB1019

I have a popup form for a user to populate a simple subform with dates. Here is a picture of the subform... My goal is to gather the list of dates into that textbox, called txtDatesSelected, in mm/dd format, comma separated. There could be up to 20 dates in the list. The subform control is...

Correct. Thanks!

I just figured it out. Had to convert the strings back to dates and numbers with CDate and CLng MIB1019

Gasman, I get all the split values correctly on debug.print. And it does fill the values in the various textboxes on the popup form, with a possible exception. In trying to find the error, I open the form without the OnLoad event. I can fill in txtStart, txtStart, txtIODetailProgram with no...

Thanks again, in advance, for your help. I'll have another couple of questions on this after this little issue gets resolved. I have a button on a form that opens a popup form to get a list of dates. There are four values to be passed to the popup. Here is the code for button click event...

The table had a record with no Air_Date in it. When I deleted the line, the formula worked correctly. Thanks for the guidance! MIB1019

I've got a query that contains a field Air_Dates, and a calculated field to find the Week Start Date of the Air_Date (week begins on Monday). The query field/calculation is: Week: DateAdd("d",-Weekday([Air_Date],2)+1,[Air_Date]). The query won't sort on that field, gives a data type mismatch...

Thanks everyone. The problem was not referencing the actual field in the 2nd subform as the Child Link. I appreciate you all pointing me in the right direction. MIB1019

There will likely be more questions as I expand the capabilities of a working database. I have a Main Form called [Insertion Orders]. On it is a subform (control name subfrmIODetails). There is a text field in subfrmIODetails called txtDetailID. As way of explanation, there is currently a...

Thank you for this. I will give it a try today. MIB1019

Yes, I error on the line before End Sub.

Hi all, Probably and easy fix, but I'm not sure what that its. Thanks in advance for advice. I have a TextBox in header of two continuous forms that I use to filter the form as I type. As long as I don't make any mistakes it works just great. But if I add a letter to the name that results in no...