[Solved] Basic syntax error

Discuss the database features
Post Reply
Jjs2060
Posts: 60
Joined: Sat Nov 08, 2014 2:53 am

[Solved] Basic syntax error

Post by Jjs2060 »

I have been working on a form for data review and input that uses a big macro. Recently, somehow I lost all macros. I went to my backups and found a database with the macros. However the main macro was out of date but I had a text copy of the latest version (attached). I copied the text and pasted it into the Sub. This macro worked before the problem and now gives this exception: Basic syntax error. "Function not allowed within a procedure." I can't get rid of the error. I feel it has something to do with how I pasted the text file. Any suggestions?
Last edited by Jjs2060 on Tue Apr 28, 2015 5:53 pm, edited 1 time in total.
Libre Office 4.2.2.1 on OS X 10.9.3
FJCC
Moderator
Posts: 9271
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Basic syntax error

Post by FJCC »

I'm guessing you have a Sub declaration that is not paired with an End Sub.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Post Reply