Search results for query: *

Ok - I have gotten this code to work properly... found it easier to re-write in ADO ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Sub CreatePlayerStats2(PlayerYear, PlayerMonth, PlayerAlias As String, PlayerWins As Integer, PlayerPoints As Integer, PlayerEmail) strSQL =...

Yes - that looks like a good way. However I am receiving a Compile Error: Argument not optional on the .FindFirst Thanks Robert.

This is where I am at so far. The un-commented part works fine - but I cannot get the recordset filter to work properly... keeps saying "Operation is not supported for this type of object." (It is the second filter that I ultimately need working - but for testing the first one...

I have added a few Programming References, such as Microsoft Scripting Runtimes, to the module I am working on. The Access app I am creating will be used on a completely seperate computer. Will these references be ported with the saved Access file, or will I need to install and reference these...

What is the best way of handling this situation in Access via VBA? Currently I am planning on openning a recordset based on criteria that determines the unique record, check if a record exists, if it does update some data fields of the record (e.g. !field1 = field1 + 1), if it doesn't exist...

Hiya, I'm trying to run a nested query that will extract for each date a count on certain variables. I'm hoping to get something like this: TheYear, TheMonth, TheDay, count(Variable=whatever1), count(Variable=whatever2), etc... Below is a much simplified version of what I'm trying to...