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

    "." vs "!" in forms, subforms, controls, etc

    Yes and no, the objects that you are creating are being added to a collection... whether it is a form that is going into the Forms collections or a text box that is going into a form's controls collection. It's still a collection of objects. Robert...
  2. SoloDroid

    "." vs "!" in forms, subforms, controls, etc

    Hello all, There seems to be a lot of misunderstanding as to the use of the bang (!) operator :-(. Please look at the following: http://www.cuyamaca.net/john.gerstenberg/CIS280/CIS280Handouts.asp Or to be exact: http://www.cuyamaca.net/john.gerstenberg/CIS280/Handouts/BangOperator.doc This...
  3. SoloDroid

    "." vs "!"

    Hello all, There seems to be a lot of misunderstanding as to the use of the bang (!) operator :-(. As I stated in the crosspost of this thread thread705-488511, the ! operator is used to access items in a collection. Please look at the following...
  4. SoloDroid

    formating text in email generated from access

    Hello hwkranger, I don't know what method you are using to send e-mail. So I will take a guess. If you are using DoCmd.SendObject, you need to specify acFormatHTML as the SendFormat. You must also encode your body text with HTML tags, such as <b>Bold</b>. Here are some other ways to send...
  5. SoloDroid

    &quot;.&quot; vs &quot;!&quot; in forms, subforms, controls, etc

    Hello Tj, The &quot;.&quot; operator is used when you are accessing a property, or method of an object. The &quot;!&quot; is used to access objects in a collection i.e. the Forms, Tables, QueryDefs, or even a Recordset's fields collection. You will find that Access will often be forgiving in...
  6. SoloDroid

    Max number of users Access can handle

    Very interesting. I guess I underestimated the abilities of Access in this area. Every thread that I have ever read gave figures similar to what I posted above. I never found that info in Microsoft's knowledgebase... though I never really looked for it. Thank you, Robert...
  7. SoloDroid

    duplicate problems

    [blush] Robert •°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°• Professional, affordable, Access database solutions and assistance http://www.SoloDroid.com °•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°
  8. SoloDroid

    Currency Field

    Hello Ian, This sounds like you have the text box field properties set to &quot;General Number&quot; with &quot;0&quot; decimal places. You should select &quot;Currency&quot; with &quot;2&quot; decimal places. Good Luck, Robert...
  9. SoloDroid

    Max number of users Access can handle

    Hello Liz, There is a mixed-bag answer. I believe that Microsoft says 5-10 should be ok. There's a point at which they don't guarentee it -- 8+ I think. The maximum is supposed to be 25. Of course this is also system-dependant. Basically Access is a lousy multi-user database. I personally...
  10. SoloDroid

    Hi all, I am trying to get a Yes

    Hello Neoduder,  Here are the problems with the above scenario: 1) If the date never changes, then there is no reason to store the Y/N value because this would essential be a &quot;calculated value&quot;, which could be determined on the fly at any time -- hence I is redundant. 2) If the date...
  11. SoloDroid

    duplicate problems

    Hello again, I just realized that there is a flaw in the above code. Instead of opening the table with .Open &quot;Dups1&quot; ... you must open the query .Open &quot;SELECT MyField FROM Dups1 ORDER BY MyField ASC&quot; ... The key part is the &quot;[code]ORDER BY MyField ASC&quot;. As you...
  12. SoloDroid

    MS Access Update Query Question

    Hello KC007, Try this: UPDATE KCtemp SET BAN = LEFT(BAN, 4) & &quot;555&quot; & RIGHT(BAN, 8); Good Luck, Robert •°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°• Professional, affordable, Access database solutions and assistance http://www.SoloDroid.com...
  13. SoloDroid

    Sending Outlook Email

    Hello romh, Absolutely! Check out this thread: thread705-475296. None of the methods that I posted required Outlook to be open. Though I think that your problem is probably a flag or an option that has not been set properly either in Outlook, or in the code. Good Luck, Robert...
  14. SoloDroid

    Append Query Using textbox's text?

    Hello Adam, Here is some [untested] code that should do the trick: Private Sub Update_Click() CurrentProject.Connection.Execute &quot;INSERT INTO MyTable (MyField) VALUES ('&quot; & MyTextbox & &quot;')&quot; End Sub Just substitute the appropriate values. One thing to note is: if your text...
  15. SoloDroid

    Changing background for selected record

    Oh, the only exception is that you want to select the color in the paint dumper icon, not the &quot;A&quot; text icon. Robert •°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°• Professional, affordable, Access database solutions and assistance http://www.SoloDroid.com...
  16. SoloDroid

    Changing background for selected record

    Hello frantik, Please see my posts in thread702-475361 and thread703-477277. Good Luck, Robert •°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°• Professional, affordable, Access database solutions and assistance http://www.SoloDroid.com...
  17. SoloDroid

    duplicate problems

    Oh yah, just replace Dups1 with the name of the table. Robert •°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°• Professional, affordable, Access database solutions and assistance http://www.SoloDroid.com °•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°•°
  18. SoloDroid

    duplicate problems

    Hello again, This code should do the trick: Sub Main() Dim strLast As String, objRSet As New ADODB.Recordset strLast = vbNullString With objRSet .Open &quot;Dups1&quot;, CurrentProject.Connection, adOpenKeyset, adLockOptimistic While Not .EOF If...
  19. SoloDroid

    duplicate problems

    Hello Faxof, You are correct, the code will not work if you do not have a primary key named &quot;MyID&quot;. Without a primary key or some unique column in the table, it is rather difficult to remove duplicates with a query alone. As I suggested above, the easiest solution would be to add a...
  20. SoloDroid

    removing duplicates issues

    I wrote that in Access 2002. The code could be placed in a button's On Click event. The above was simply placed in a standard VBA module's Main() sub procedure. If you have an older version of Access, say 97, the code won't run without modifications. Access 97 doesn't support subqueries -- as...

Part and Inventory Search

Back
Top