Search results

No dice. I get the same error message. The navigation pane opens even without the shift (it's an accdb with nothing hidden).

I am using Access 2007. When I try to open my accdb I get a "The database cannot be opened because the VBA project contained cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You...

I am passing a sql statement for a crosstab query, as such, in VB Code: ___________ strSQL = "TRANSFORM.... "SELECT .... "FROM ..... "WHERE.... "GROUP BY .... "PIVOT myField IN ('Apple', 'Orange', 'Banana') CurrentDb.QueryDefs("myQuery").SQL = strSQL ____________ If I look at the...

Thanks! I got the vb code... Set results = CurrentDb.OpenRecordset(JoinedBothTables) If results.RecordCount <> 0 Then With results .MoveFirst Do While Not .EOF If ![ChangeType] = "ColorChange" Then...

@GalaxiomAtHome - That doesn't help with setting the validation field to "yes", nor does it take into account that the rule only applies if the changetype is "ColorChange".

I'm new to VBA, intermediate SQL. I've been scouring the web for an answer - and can't find anything similar... or perhaps I'm searching for the wrong thing! I'm using Access 2007. I want to compare two columns from two different tables and then update another column. Table A is an audit...