Recent content by AnotherWayne

Cosmos, I see where you are headed with this, but I would vote for the simplistic approach. I would generate the whole password then use a DLookUp to see if it is in use. If it is, just generate a new one. Even a 4 character alphanumeric password has over a million combinations, so you are...

You can attach a sample DB when you reply by looking for the attach file (browse for your file). You should compact/repair and then zip your db so that it will conform to the size rules. Wayne

Tom, You need to add InventorySub in: "FROM Inventory, InventorySub " & _ Another Wayne

wizcow, Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim stsql As String stsql = "SELECT TOP 1 Inventory.StockTakeDate" & _ "FROM Inventory " & _ "INNER JOIN InventorySub ON Inventory.InventoryID = InventorySub.InventoryID " & _ "WHERE (InventorySub.ItemNo) = " &...

Cassandra, There is something "wrong" within your database. When Access does a Compact/Repair it opens a new database (db1.mdb) and one-by-one it copies the items in your database to the new one. When it finishes, it deletes your current database and renames the db1.mdb to your database name...

Cassandra, No, don't delete it! If you do a repair/compact, and it fails, this is most likely your "best" copy of the database. There is something in your database that does not let the compact/repair run to its completion. That should be fixed, before you can truly compact/repair. In the...

Jerry, You can select any number or kind of constants: Union Select 'Garbage', '', 0, 'N/A' From YourTable Wayne

Jerry, Make your queries union queries and retrieve a row of constants, or nulls from the second query. AnotherWayne

Hi All, I'm posting this here, because not everyone frequents the WaterCooler (though even Pat posted there). I have emailed and PM'd Jon, but no response. About a week ago, someone posted that they could not get a couple of combo boxes working. They wrote back about an hour later that all...