Recent content by GlenS

I spent a couple of hours loading and unloading all the objects to various new databases; decompile and recompiled, deleted and importing various components. What I believe the error was related to was a query that extracted a photo field. When I removed this field from the query the...

More bizarre is that when I created a fresh database with tables loaded from the original and then loaded the objects from text, I got another hidden copy of my main query. Execution of the search in the new database with loaded text objects still results in the RTE 3000. Glen. :banghead:

Interesting update...I'm just began saving the objects as text and noticed the these two previously unknown objects in the list. I initially included them in the extract; however, an error was produced, so I excluded them. Glen.

Update...just in case it could be a corrupt db, I created a new db, but with the same result. There seems to be very little written on the internet about this error.

That's what has me baffled Paul. I'm hoping a second set of eyes could see something I haven't been able to. Here's the error text that I receive I have attached the database. Cheers, Glen

Here's the code. I've stripped out most of the search fields to target just the one until I can get it working, then I'll add the others back in. The debug.print shows ([p_last_nam] LIKE 'Shevel*') OR ([s_last_nam] LIKE 'Shevel*') Private Sub cmdSearch_Click() Dim varWhere As Variant '...

Thanks Paul but because I've posted less than ten times it won't let me post the link. The subject line of my OP in the Forms forum is "Creating a search to populate a subset of records"

This sounds similar to my problem that I posted about last night. Creating a search to populate a subset of records - unfortunately, I can't post links yet. When I include anything in the Where parameter of the OpenForm command, I receive a RTE 3000. I have yet to find anything that could be...

Any help on this is greatly appreciated....Anyone???

Thanks jdraw. Sorry I wasn't clearer in the OP. Based on your link, I redefined varWhere as a string and change the command as follows, but still get the runtime 3000 error on the docmd line. DoCmd.OpenForm "frmClients", acNormal, , varWhere

The IsNothing is a custom program that accounts for a number of different entries that a user can make that would be invalid for the field. The issue is in the docmd. DoCmd.OpenForm "frmClients", acNormal, , WhereCondition:=varWhere , acFormPropertySettings, acWindowNormal When I include the...

So here's the deal. I've been racking my brain for two days and haven't figured out the issue, so I'm hoping that the collective brain on this forum can come up with a solution. I have a form that when initially displayed shows all client records in my database with the ability to add new ones...

Hello everyone, I've been a lurker for a while using this site as a good troubleshooting resource. I was originally a developer (early 90's) in C, but have spent a good chunk of time since then in various levels of IT audit management. I'm now doing an about face in my career and leaving the...