Re: Create Table SQL not working

Gil

Only speaking for myself, I understood quite well what you were asking. I
chose not to offer "how to" suggestions because of the possibility that you
were trying to "drive nails with a chainsaw". Just because it is possible
to do something doesn't necessarily make it a good idea.

I am NOT saying that what you're doing is not a good idea. I AM saying that
I don't understand the underlying rational or data structure well enough to
offer suggestions.

Sorry if you took that to be obstructionist -- I was seeking clarification.

Best of luck on your project

Jeff Boyce
<Access MVP>

"Gil, Not the Fish" <GilNottheFish@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:CB6E9A7A-F936-40B3-8D3F-D7EDBB6A6087@xxxxxxxxxxxxxxxx
> 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 to the end of a constant ... after I made the Number a string I then took the sign away by using ...
    (microsoft.public.access.tablesdbdesign)
  • Re: To quote or unquote strings in an echo?
    ... However, for a double-quoted string with no dollar signs, the running time ... Complexity of both parsers will be Oin this case, ... using commas within echo() is a language construct. ... which leads us to the matter of concatenating stuff. ...
    (comp.lang.php)
  • Trouble accessing db while using ASP.Net
    ... When I try to open the connection ... "Exception Message: ... ASP.LoginPage_aspx.CustomAuthenticate(String username, String ... User name: jeff" ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Make Multiple Tables via Query
    ... Dim strTableName As String ... Dim strExcelFileName As String ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.queries)
  • Re: Advantage of Parameters
    ... the method where you are concatenating the string. ... new Parameter object, and then during the execution of the Command, it has to ...
    (microsoft.public.dotnet.framework.adonet)
Loading