Re: Create Table SQL not working

I figured out the solution to my problem and I thought I would post it in
case anybody else has the same problem. Tim & Jeff seemed to be so
interested in my application ( which was running perfectly ) that they
couldn't listen to the problem I was having. The problem I had
concatenating the Number (converted to a string) to the end of a constant
strFileName was that the function Str() adds a space for the sign of the
number which when concatenated to the constant and included in the 'Create
Table' SQL statement must have put a character that the strSQL couldn't
accept so I would get a syntax error although everything seemed correct. .
So, after I made the Number a string I then took the sign away by using
Mid(Str(Number),2) and it returned ONLY the number part so I could create the
tables called Quilt1, Quilt2, Quilt3, etc. In order for this to make sense I
think you would have to go back and read the rest of the threads. I hope
this helps someone.
Thanx


"Tim Ferguson" wrote:

> "=?Utf-8?B?R2lsLCBOb3QgdGhlIEZpc2g=?="
> <GilNottheFish@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> news:BEE9DEAA-7E4A-4AAC-8E50-1C8047D43B75@xxxxxxxxxxxxx:
>
> > Namely, how to concatenate the number to the
> > 'MeaningfulName' part of the filename so that the 'Create Table' SQL
> > string accepts it.
>
> I am with Jeff on this: it sounds less and less like a project with which
> Access's strengths would be helpful (i.e. security, mapping of complex
> data, rapid and easy forms design).
>
> In general, it's a big red warning for putting data into a table name. The
> meaningful name should be a field on the OneBigTable...
>
> All the best
>
>
> Tim F
>
>
.

Relevant Pages

  • Re: Create Table SQL not working
    ... Tim & Jeff seemed to be so ... > concatenating the Number (converted to a string) to the end of a constant ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Is Crazy 8s a thing of the past?
    ... Gans-Smith, Marv Getty, Jeff Hahs, David Hayes, Joel Keys, William ... Stephenson, Richard Stern, Peter Strauss, Kenny Stultz, Frank Till, ... Tim Fleming ...
    (rec.sport.golf)
  • Re: Data from web site
    ... Thanks Tim, don't think I need to try that now:) ... >> I'm not clued up on HTML, but hopefully that is the name of the frame I ... >>> You can then parse out the info from the returned string. ... >>> Dim objShell As Object, objShellWindows As Object, o As Object ...
    (microsoft.public.excel.programming)
  • Re: Catch-A-Call
    ... aka Kuay Tim ... Any higher value extends the time the modem waits ... > This string has two AT commands. ... In the Extra Settings box, ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: replacing text in textfile
    ... Thank you again Tim for they reply. ... >> Public Function ReplaceText(CleanThis As String, ... >> 'This adds a space before and after NewText ... > This is pretty wanton inserting and removing white space, ...
    (microsoft.public.access.modulesdaovba)