Search results

Cool. Thanks for your help vbaInet :)

Thanks Chris. I *think* I get what you mean. I'll give it a go :)

Hi, I am unsure if this is even possible to do from within an Access SQL Query but here goes... I already have a query which grabs specific records from the main table. Once the query has been performed I have a few VBA modules which export that data to dBase format for use with another piece...

No you didn't read wrong namliam. I managed to get the module to do what I wanted it to by creating a new recordset and querying for records with [PROC Reg/Tag] = registerANA instead of using the FindFirst method. I was just eager to get to the bottom of the FindFirst method not working as I...

registerANA is declared as a string which I am sure is correct. I want to change all of the field names to make them more VBA friendly but unfortunatrly the database has to remain untouched. It is a company standard which is pretty much 'set in stone' :rolleyes:

Yeah. I've checked that a fair few times :) I wonder whether the special characters have anything to do with it? The Field Name has a forward slash in it and the string I am searching for uses a % symbol. Simply creating a new recordset and querying for the records I want has worked...

I get an "Item not found in this collection" error. However, thats a step forward from what I had. It is actually implementing the FindFirst but not finding anything. I had this earlier when usiong my alternate method (new function w/recordset). Tweaking the query fixed it in the end. Thanks...

That could potentially be the issue. I declared mine as DAO, OpenDynaSet. I'll give it a go... :)

OK. Well that explains why that one line doesn't return any results. However, I have checked your earlier example again along with some variations and it unfortunately still won't work. Confusing :confused:

I seem to have had a bit of success. I have gone down a different path and created a seperate function with a new recordset effectively replacing the need to the .findfirst method, finding the records I need via a SQL query string. So far so good, it appears to work. For future reference I'd...

Thank you for your reply namliam. Unfortunately, I still recieve a 3077 Syntax Error. Any other ideas? To be clear on what I want to do; I need to search for a record that has the "PROC Reg/Tag" field equal to the contents of the string variable 'registerANA'. The one line which doesn't get...

Hi, I'm relatively new to writing Access modules so please bear with me :) I'm using Access 2003 and developing a module to pull data from a table, manipulate it, then use it to populate an external config file for some SCADA software. Essentially, everything works fine barring the part that...