Search results for query: *

How about when people say, "It's always in the last place I look" when they are looking for something.

Try this ) me.FilterOn = False me.Filter =

Let me know if it works for you.

You may have to change security settings in EXCEl to allow trusted access to visual basic project. Sub AddcodetoExcel() Dim objXl As Excel.Application Dim objWkb As Workbook Dim objSht As Worksheet Set objXl = New Excel.Application objXl.Visible = True Set objWkb = objXl.Workbooks.Add Dim...

I dont see why you will not be able to do this with a continuous form. Afterall you are just dealing with a recordset. From Help File Public Sub BeginTransX() Dim cnn1 As ADODB.Connection Dim rstTitles As ADODB.Recordset Dim strCnn As String Dim strTitle As String Dim...

Use the recordmacro method. Make sure you reference Excel Object Library.

So the ticket #'s start with 200000 all the way to 215000?

Simply add a field to your table say called DateAdded Then modify your query on the website to append the current date/time to this field. Now all you have to do is query the DateAdded field for yesterday's date.

I can't belive I did not notice that. Must becoming blind. Thanks. Santa will be very nice to you this year.

If you have a primary Key, you can query against the last updated record. Private Sub Command11_Click() Dim sNewRec As Integer Dim rs As Recordset Set rs = Me.RecordsetClone With rs .AddNew or .Edit .Fields("Fieldname") = "some Value" .Update .Bookmark = .LastModified sNewRec =...

Here is my code.. Sub TestArray() Dim test(2) test(0) = CDate(#4/2/2004#) test(1) = CDate(#3/3/2005#) test(2) = CDate(#3/5/2002#) MsgBox FindMax(test) End Sub Function FindMax(A() As Variant) As Variant Dim Start As Integer, Finish As Integer, i As Integer Dim max As Variant Start =...

If you are using Access 2000 or higher I suggest start using ADO. Private Sub Command11_Click() Dim sNewRec As String Dim rs As Recordset Set rs = Me.RecordsetClone With rs .AddNew .Fields("Name") = "Paul" .Update .Bookmark = .LastModified sNewRec = .Fields("Name").Value End With End Sub

Anything is possible with programming.. First I need a bit more info. Do you have a way of knowing whether new items were added to the table i.e. maining a log. Also, how is the information being added to the table (via form, imported, copy/paste, etc.) Are you going to store the list of...

Why would you choose C# over Visual C++ ?

Why would C# be your choice?

Upon my request I was issued Visual Studio.Net at work and I wanted your advice to which is the best langauge to use for high end development projects. ie the most powerful language. I know VB, but I rather be using the best language.

You can create a log table ex: Create a table with the following Fields User, FieldChanged, OldValue, NewValue, DateChanged I would initially lock the fields so the user cannot accidently change the values. Then add a command button to unlock the fields. Once this is clicked you can capture...

PHV, Thanks, it seems to be working fine now. I am now that much smarter because of you. I can mail u a nathan hotdog, the best in the world.

Microsoft's Official solution is to use Extended MAPI to avoid this. It won't work with VBA (C++ or Delphi). You can download a third party COM wrapper called Outlook Redemption http://www.dimastr.com/redemption

PHV, What do I change the line For Each xCell In Selection to? It now breaks there once I corrected the ActiveWindow portion of it. This is my first time programming using the excel library.