Search results

  1. T

    Need help with SQL Query for Row Source

    Hi! I have those (simplified) tables that are linked with an n:m relation persons: #ID#FullName# trainings: #ID#startDate# training_members: #ID#trainingID#personID Now I created a form to fill the training_members table with the participants. For the form I'm using a dropdown list...
  2. T

    prevent users from making changes

    well, would be possible but those guys already lost few master dbs so they won't be happy about an mde solution..
  3. T

    Split one table into 2 (relational) ones

    Sorry for the delay - I got ill but will now try your tool asap!
  4. T

    prevent users from making changes

    Hi! I'm working on a Access 2003 mdb file. I want the database to start commonly without any user-login screen. Nevertheless I want to prevent the default logged in user from making any changes to the database structure, using the tables and examing the VBA code. Because of some strange...
  5. T

    Split one table into 2 (relational) ones

    the main problem with that is that the old database is still in use. On a certain date I'll have about 30min to convert the data - so I really need a template. I can't copy all that stuff in that time :(
  6. T

    Split one table into 2 (relational) ones

    I really look forward to try this! The real table (the stuff above was just an example how the table looks like) consists of 168 columns and I definitely will not create hundreds of append queries ;)
  7. T

    Split one table into 2 (relational) ones

    Hi there! I'm currently working on a malformed Access database, not normalized at all. It only consists of one table and is designed like this: (table compartment) #ID#Name#Member1#Member2#Member3#Member4#...#Member20# So all the members are realized by single columns. I created a new...
Top Bottom