Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. carefully

    International Dates - I'm missing something

    Actually DatabaseGuy, although the Format suggestion looked strange in VB it appeared to work in actuality. I guess the SQL sorted it out Anyway thanks
  2. carefully

    International Dates - I'm missing something

    Yes. Including the line datJoined = Format(datJoined, "MM/DD/YYYY") This works where there is a US equivalent e.g 10th June 2001 changes from 10/06/2001 to 06/10/2001 However, where no US date exists when the DD and MM are reversed e.g 14th June 2001 14/06/2001 remains as 14/06/2001...
  3. carefully

    International Dates - I'm missing something

    I recently lost my Windows system files and am having problems re-creating the settings I had on Access 2000 to get round the Visual Basic limitation of dates having to be in US rather than international dates. The tables I use including tblPlayerClub (below) are in international dates The...
  4. carefully

    Paramater Query in VBA

    Using a VBA module I am getting a runtime error "3061 Too few parameters expected 1" when the last line of code below is executed The critical elements are Dim rst1 as DAO.recordset Dim rst2 as DAO.recordset Dim strSQL as String Dim numID as Long Set dbs = CurrentDb Set rst1 =...
  5. carefully

    Make Table - Relationship Problem

    Thanks for the suggestion but that does not seem to be the problem. Of course it is early here :) I seem to have got round it by having the query make a differently-named table which I then rename to the original after the query has run. Looks OK but there might be some consequences I suppose
  6. carefully

    Make Table - Relationship Problem

    I am trying to run a make table query based on a combination of other queries. It replaces an existing table tblA When I attempt to run it I get the message 'You cannot delete the table tblA; it is participating in one or more relationships' However, tblA does not show up on the relationship...
  7. carefully

    Undefined Function in expression

    I have an Access query, qryA, which produces an output which includes a column 'season' e.g 1993/4 based on a function 'FX_Season' which does a date comparison. Everything works fine in Access but when I attempt to set up a CFQUERY utilizing qryA I get the error "Undefined function...
  8. carefully

    Importing Tables and Queries

    I have a database1 with tables tblA, tblB, tblC etc a subset of which, database2, with tblA, tblC (same data)etc I wish to maintain to upload to the internet. I want to automate a procedure so that I can import tblA and tblC from database1 when required, overwriting the existing tables in...

Part and Inventory Search

Back
Top