User Profile

Collapse

Profile Sidebar

Collapse
mathilin
mathilin
Last Activity: Aug 31 '10, 10:40 AM
Joined: Aug 23 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • mathilin
    replied to Variables as table names
    It seemed as though this worked! Thanks a million you saved me hours of aggravation. Just as a note to anyone else who may be encounting this problem I changed the above suggestion a bit just to work properly in my code. Thanks again!

    Code:
    Dim myCMDStr As String
       myCMDStr = "INSERT INTO [" & userCircuit & "-" & userStart & "," & userEnd & "] ([Cable_Start])VALUES(Cable_Start)"
    ...
    See more | Go to post

    Leave a comment:


  • mathilin
    started a topic Variables as table names

    Variables as table names

    Hello,
    I have a database that asks the user for many inputs and stores them in variables. From these variables a table name is created. Like so:

    Code:
    'Specify table name
        Set tbl = dbs.CreateTableDef(userCircuit & "-" & userStart & "," & userEnd)
    Where userCircuit, userStart, and userEnd are all variables. I am attempting to add information to this table that is created...
    See more | Go to post

  • mathilin
    started a topic Inserting variables into data fields

    Inserting variables into data fields

    Hi, I am writing a program to accept multiple user inputs and put these values into a table. This database will end up having hundreds of tables, each table should have the user inputted data.

    I have created the table and set the fields to their propper values. The problem I encounter is when I try to input the user data (stored in my global variables userStart, userEnd, userCircuit etc etc) into the proper fields. Here is what I have....
    See more | Go to post
No activity results to display
Show More
Working...