Search results for query: *

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

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...

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...

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 =...

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

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...

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...

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...