vba - Loop through Access tables -


I am creating a database in Access that will have multiple tables similar to the same table and all those names will be named sequential Order, such as table_0, table_1 ...

I wanted to know that there is a way to create loops in VBA to make tables first, and to change them, like adding fields easier.

So if I had to create tables, this would be the process, but in VBA 

  while (i = 0, i <20, i ++) {CREATE TABLE Table_I (field_1in primary key, field 2CRAR (255)); }    
 
 
 In VBA, you can find it through your numbered table names like this Are ...  
  String down as a dim string I = 0 to 20 strTable = "table_" for a long time & amp; CSTR (i) debug.print statutable next mother   
 but you want to do something other than the table name other than print it. So say that you have already prepared your  CREATE TABLE  statement, it probably looks like this ...  
  create table table_name (field_1 united primary key, Field 2 text (255));   
 then you can load that DDL statement in the string variable, then every time your  for  loop  table_name  is present value Replace with  strTable , and execute that DDL statement.  
  As long as the string is dim, the dim strSql string as the strSql = "create table" ("& amp; vbCrLf & amp;;" field_1 key primary Key, "& vbCrLf & amp; _" field_2 text (255); "I = 0 to 20 strTable =" table_ "& amp; CStr (i) CurrentProject.Connection.Execute Change (strSql, _" table_name " , StrTable) Next I   
 The  change ()  function becomes available with accessibility. If you are using the old access version, you can change your SQL String A different method will be required to handle.  
 If you want to execute a  ALTER TABLE  statement, you can do this instead.  < P> So I think that whatever you want can be done easily with VBA. Although I have uncertainty that you  should  do so many tables with the same structure generally have a red Error is a design error signal. There is no evidence to draw conclusions That's it's a design error in your case. Otoh, there is no evidence to conclude that  not  is a design error; -)

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more