Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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