Recent content by Mel_P

  1. M

    Create a table of 1 column for integers 1 to 2000

    Thanks - a bit more complex! Excel was easier !!!!:D
  2. M

    Create a table of 1 column for integers 1 to 2000

    Thanks - I understand this process, Mel
  3. M

    Create a table of 1 column for integers 1 to 2000

    This should be simple but brain dead! In the end I used Excel and typed 1, 2, 3, 4 etc and stretched it to 2000 rows and pasted it into Acess. What is the SQL in Access to create a single column table of integers please? INSERT INTO..... ??? Thanks, Mel :confused:
  4. M

    Startup Module for Public Function/

    Thanks Bit like VB6 - should have remembered. Nothing in Access "Help". Mel
  5. M

    Startup Module for Public Function/

    Basically I want somewhere to declare a public variable and a public function? Another thread suggested this as a means of using this varaible in several places. http://www.access-programmers.co.uk/forums/showthread.php?t=144805 Mel
  6. M

    Startup Module for Public Function/

    I can't seem to find or create a startup module. how do I create this please?
  7. M

    Pass variable in Query Criteria

    I can't seem to find or create a startup module. how do I create this please? Thanks
  8. M

    Change a field in a query with User Input?

    I know that using parameters I can input a particular value of a field but is it possible to modify the field itself in a query using a variable or VBA say using a text box value? I have a table with several fields each containing many rows: sales.AI sales.CG sales.HF etc. (18 similar...
  9. M

    Using Append Query in a loop to create 6 records in one go.

    I have a table of 75000 records in sets of 15 and I have to add 4 records for each set to make these sets of 18, i.e. 80,000 records!
  10. M

    Using Append Query in a loop to create 6 records in one go.

    Do you mean another "look up table"? Mel
  11. M

    Using Append Query in a loop to create 6 records in one go.

    :confused: Hello - I want to create a set of 6 records in an Access 2003(2000) database. I can create a record thus (SQL from append query): INSERT INTO tblTest ( AssessmentID, AssessmentNumber, Hazard, [q(y/n)], [c(y/n)], info, moreinfo ) SELECT [Input AssNo] & [Input Hazard] AS AssID, [Input...
See more
Back
Top Bottom