Search results

  1. A

    Can SQL server call predefined vb functions?

    OK. Thanks ... I was sort of resigned to other methods ... which I have now found :)
  2. A

    Can SQL server call predefined vb functions?

    I need to convert an Access database to an SQL server database some time soon. However the Access db contains some queries that call vba functions. Does anyone know whether this will cause problems? I know that SQL server can call so-called UDFs (User Defined Functions) but can it handled...
  3. A

    Access xp pivot table problem

    I have been using access 2000 pivot tables to retrieve relatively straightforward m by n tables with a count in the body. These are simple to define (drag row and/or column variable and various relevant filters appropriately and then drag the data field, which automatically chooses sum or...
  4. A

    Access xp pivot tables problem

    I have been using access 2000 pivot tables to retrieve relatively straightforward m by n tables with a count in the body. These are simple to define (drag row and/or column variable and various relevant filters appropriately and then drag the data field, which automatically chooses sum or...
  5. A

    Sequentially numbering the records in a query

    Thanks Meltdown ... I had seen this one, but I was hoping for something slightly simpler. I also found this one ... which IS slightly simpler: http://support.microsoft.com/?kbid=208946
  6. A

    Sequentially numbering the records in a query

    I need to add a column to a sorted query which effectively numbers from 1 to N. It is intended as a ranking field for later statistical analysis. I can do this manually by saving the query as a table, then introducing a new autonumber field. However, I need to do this automatically, as this is...
  7. A

    Creating a primary key field with autonumber

    Hi ..... I am creating a simple two field table from another table via the following code: SELECT LU_CESNdx_ICD10.CES_Index AS cesdi, LU_CESNdx_ICD10.[ICD10 Code] AS icd10 FROM LU_CESNdx_ICD10; However, I need to add an initial new primary key field called ID that is autonumbered. Can anyone...
  8. A

    Copy table structure only

    Can anyone help with the following ... which generates a syntax error when run in VBA: Private Sub CopyTableStructure_Click() Dim MSS0 As String 'set up MySQLString to create new tables with structure ONLY MSS0 = "CREATE TABLE LU_WMCHDL_Inf_v2 AS SELECT * FROM" MSS0...
  9. A

    Copy table structure only in maco

    Deleting duplicates pj ..... did you sort this out in the end? I have had this problem in different ways at different times and solved it using a variety of methods (all manual!). I now need a method that is totally automatic ... but precisely the equivalent of what you have detailed above ...
  10. A

    Update query not updating

    I have already done this ... returned 3 matching (from the 3 transaction records).
  11. A

    Update query not updating

    I have an update query (see attached jpg), but it is not updating. I am running Office 2000 on Windows XP. Any ideas on where the error is?
  12. A

    Updating Access table from transaction records

    Perhaps it is not clear from my post, that I require some code for the update - I have no idea where to start!
  13. A

    Updating Access table from transaction records

    I have an Access table (tblSessions) which needs to be updated from a set of transaction records (retrieved from an Excel doc). tblSessions has fields: SessionRef (AutoNumber, Key), JobRef (Number), SessDate (Date/Time), SessionText (Text), SessionLink (Text, but also unique), Issue (Yes/No)...
  14. A

    need dlookup equivalent of vlookup

    I have solved this particular problem in another way. Using a query, I 'joined' the lookup table to my main table, used join option 2 and simply selected field 'number' from the lookup. Easy as pie. However, I would still like to use dlookup to effect the same thing!
  15. A

    need dlookup equivalent of vlookup

    I need to use dlookup in a query to populate a new field "number" with values obtained using a current field "letter". I have a (lookup) table as follows: Col1 = A, B, C, D and Col2 = 1, 2, 3, 4 which of course gives the number code corresponding to each letter. In Excel, I simply use the...
  16. A

    Linking to a query?

    Thanks KenHigg and FoFa. Yes ... I understand about the 'running' database ... I will need to link the underlying tables, copy the query and ... work from there.
  17. A

    Linking to a query?

    Can I use a query in Database A as a look-up table in Database B. When I try File / Get External Data / Link Tables (in Database B), it only gives me a choice of Tables from Database A. Do I need to generate beforehand a physical Table using a MakeTable Query? Any help or advice would be...
  18. A

    Where to put code for whole project?

    Worked like a dream ... thank you! :)
  19. A

    Where to put code for whole project?

    I have now set up a module with a procedure as follows: Sub pathset() public mainpathstring as String mainpathstring = "C:\ ....... etc" End Sub Do I need to run this on opening my project? ... and if so, how do I do that?
  20. A

    Where to put code for whole project?

    Thanks for replying so swiftly. I will try setting my string constant as you suggest.
Back
Top Bottom