Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. storl2

    Hot to refer to a Subform in a Tab Control from another tab

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

    Hot to refer to a Subform in a Tab Control from another tab

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

    Hot to refer to a Subform in a Tab Control from another tab

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

    Hot to refer to a Subform in a Tab Control from another tab

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

    Hot to refer to a Subform in a Tab Control from another tab

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

    Read only security for certain tables without using workgroups

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

    Read only security for certain tables without using workgroups

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

    Read only security for certain tables without using workgroups

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

    Line Break in code for sending an e-mail

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

    Line Break in code for sending an e-mail

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

    Line Break in code for sending an e-mail

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

    Concatenate an integer to Me.txtBox issues

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

    Concatenate an integer to Me.txtBox issues

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

    Concatenate an integer to Me.txtBox issues

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

    Concatenate an integer to Me.txtBox issues

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

    Automatically put correct number of text boxes on a form

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

    Automatically put correct number of text boxes on a form

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

    Locking individual fields based on user logged in

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

    Locking individual fields based on user logged in

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

    summing fields

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

Part and Inventory Search

Back
Top