Search results for query: *

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...

I think I might be able to do it if there is a way to create text boxes on a form dynamically using VBA. I have checked all my books, but can't find anything on that. Is there a way to create text boxes using code that anyone has seen? I would basically count the number of questions in the...

I have a form that is a dynamic questionnaire. The number and content of the questions will change on a regular basis, so I am trying to make a form that will allow me to automatically pull the current questions and have the correct number of text boxes to display them on the form, along with...

The database is still a work-in-progress, so it is still in one piece. The forms will change pretty regularly since it is a fairly dynamic group, so I don't think I will split the FE/BE, at least not to the point where each user has their own copy. I see what you're getting at though, since it...

Hi all, I have a database that is used by 20 or so people now, but will soon be used by a hundred or so people (I know, Access is going to freak under the stress....). I need to put in some user level security that prohibits certain fields from being edited based on the login that the user...

I'm not sure if this has already been mentioned, but are you pulling data from more than one table/query for the query that the report uses as a source? You could have an instance where the two tables are creating more than one unique record for each row in your report. Say, for instance, that...