So I have a web database in Access 2010, Sharepoint 2010, as an accdb file.
I have a backup of the database, but the backup doesn't have the data in the tables.
For some unknown reason, the database was corrupted. I tried "Compact & Repair DB" which made the situation 10x worse.
Now the MsysAO table is missing over 100 rows. Before, the rows were there but full of non-typical random ASCII...
ConfusedVBA
Last Activity: Feb 9 '16, 01:20 AM
Joined: Jan 23 '16
Location:
-
Corrupt Access 2010 Web Database
-
Great Advice.
The issue I found using your method is that cdbl() and cint() are setting the field name to Null, which results in a "Invalid use of Null" error. I removed the functions from the string entirely, and it found the record. Oddly, using a single criteria, these functions work just fine and dont give an error, which makes me think it might be syntax related, but thats not something I'm concerned about now.
... -
I added some additional code. The rest of the code works, which is why I left it out. And .findfirst works with one criteria, but as soon as I add the second criteria it stops working entirely. No errors thrown though.
I did a debug.print on the criteria instead of setting it to a string, and it looks fine to me as well, and the variables are set.
Access 2010/Sharepoint 2010.Leave a comment:
-
Recordset.FindFirst Multiple Criteria Not working
Having trouble with FindFirst method with AND operator.
...Code:Dim dblADID as Double dim intSID as Integer dim db as Database dim rstE as Recordset set rstE = db.openrecordset("UAInfo", dbOpenTable) dblADID = 123 intSID = 324 With rstE .FindFirst "(cdbl([ADID]) = " & cdbl(dblADID) & ") AND (cint([SID]) = " & cint(intSID) & ")"
No activity results to display
Leave a comment: