Recent content by PeasNCarrots

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?