Recent content by storl2

Wow, duh! Thanks, Remou, that worked perfectly. I have always used unbound controls in my forms to avoid data issues, so I didn't even think of something like that. Maybe one day I will just make them a new database with naming conventions and all that fun stuff... Thanks for the help.

Ah, I see what you mean. OK, I was wrong in trying to use the filter. A simple filter will not work. The search creates a dynamic query based on which controls are filled in in the search tab, so the criteria can be different every time, so there can be between 1 and 30 criteria. I need to...

But how do I apply the filter to the subform? Like I said, it works when I make it its own form, but when referring to it as a subform, I can't get the syntax right with docmd.openform or applyfilter.

Whoops, change the "hot" to "how" in the title.

I am not used to using bound controls, but I am helping another group add search to their database, so I am not sure what to do with this. I have a database with a tab control in the main form, and two of the tabs are "search" and "edit project." I have a bunch of unbound controls in the...

StarPassing: I am not sure I understand what they are doing in that OpenDatabase example. Once you open the database and link the tables, do those links stay there, or does it relink each time they open the querying database? I can't seem to wrap my head around the "workspace" concept they...

It's not that I don't want them to be able to edit the design, it's that I don't want them to be able to edit anything, including the data in the tables. I want them to just be able to query off of it.

I searched around, but did not see a thread or FAQ on this. I have a database where the front end and back end are separated. The front end is about as secure as it can be, and I want to keep it that way. I need to have a few select people be able to create ad hoc queries off of the backend...

Perfect, that will do exactly what I need. Thanks!

Oh yeah, one more thing is that the format is txt, since this will often be going to Blackberries, and they don't get along with html.

This is probably something simple, but I can't find the answer in help or the forums. I am trying to automate an e-mail that is sent when a project is updated. I want to include the fields that are updated, with line breaks in-between each field so it does not look messy in the e-mail. Is...

RoyVidar, that's great! Putting the movenext before the do loop was my next step, and you confirmed the idea. It was bombing at the line: Me("txtQuestionID" & int1).Value = rst1![fldQuestionID] I put a movenext before the do loop, and another at the end of the loop, and now the sub works...

RoyVidar, It looks like it is actually filling in the boxes, until it gets past the last record. It is at that point that it gives the error. I have 30 questions right now, and after it does the 30th box, int1 becomes 31, and the error pops up. Shouldn't teh "Do Until rst1.EOF" stop that or...

Gives error 2113: The value you entered isn't valid for this field. Here is the code for the whole sub: Private Sub Form_Load() Dim rst1 As New ADODB.Recordset Dim sql1 As String Dim int1 As Integer 'Open the recordset, sorted by Question type and then number, so all types are grouped...

I am trying to concatenate a integer that increases by one each time a loop runs to the end of two Me.txtBox's. I am not sure of the syntax to do this, and I couldn't find anything in help, any of the books I have, or any of these forums. I know this is wrong, but here is what I have: Do...