Recent content by maincomputer

I'm on Windows XP, Office 2003. Not sure which SQL Server version we're connecting to, sorry. It's housed in a different location to my workplace, and the DBAs are "very busy" and not very responsive to emails (they won't even accept phone calls!).

Thanks for coming back to this. Yes, I've tried using all those methods. Querying normally works fine, but if I try to use user input methods, either in the query [], or by using a form, I still get the ODBC error. The SQL warehouse stores the dates as HUGEDATE format. I guess that is the...

Hi I have a table of results I need to query. It is badly designed. It holds test results for individuals, where there can be a variable permutation of results. Like this: Person - Result Person 1 - Positive Person 1 - Resistant Person 1 - Type A Person 2 - Slight Positive Person 2 -...

Hi, I've managed to find the following code to change a field's data type. it isn't running, though. I get a Run-time error for the line "fld.Type = 8". Any help would be gratefully received! Function ChangeFieldDataType() Dim db As DAO.Database, tdf As DAO.TableDef, fld As...

I'll try this on Monday. Sounds like it will work. Many thanks.

A regular select query on a linked table.

Hi Complete n00b here so please be gentle. I run a query to an SQL Server across our network from Access. My query has date criteria: between #date# and #date#. I use this every day so wanted to get a user-input date with: between [start date] and [end date]. This causes an ODBC connection...

Thanks for the help, but still not working. -I tried the criteria: between [start date] and [end date] -Then entered in format mm/dd/yyyy when prompted, but still got "ODBC--call failed" message -If I replace the criteria with: between #05/01/2012# and #05/03/2012#, the query works again...

Hi Complete n00b here so please be gentle. I run a query to an SQL Server across our network from Access. My query has date criteria: between #date# and #date#. I use this every day so wanted to get a user-input date with: between [start date] and [end date]. This causes an ODBC connection...