Search results

Hi chaps I am a little stumped here. I have created a simple SELECT sql script which works fine if I make the "WHERE" part of the query refer to a specific record, but if I use a wildcard, the process errors saying that no records are found even though I know there are records that meet the...

I was wondering if it is possible to set a variable in one database to be the value shown in a form on another database. If I set the value in a textbox on a form on the backend DB, then I would like set a variable in the frontend code to equal that textbox value. Is that possible? eg...

Hi guys Here's a simple helpful function to create a datestamped batch file with a header, some tab delimited table data and a trailer. I know there is room for improvement but hope it helps someone. ********************************* Function BUILD_AMBER_FILE() Dim filedate As String Dim...

Hi chaps I was wondering if anyone has experienced a similar problem before. I have a script that exports a query to a text file. It is to a fixed length text file. Each time I run the script it fails with: ************* Runtime error '3011' The microsoft Jet database engine could not find...