For the Applications I support, I prefer to use DSN-LESS connection strings
rather than DSN.
The DSN-LESS connect string works wonderfully for all my ADO objects.
BUT

Hi Group,
I'm using this code from John Vinson (many thanks for that) and it's working
very well:
DueDate: DateAdd(Switch([Frequency] = "Annual", "yyyy", [Frequency] =

I need to access data from several large tables approx 1 million records each.
There is a table for each month in a separate database over 300mb each. I
need to create a front end by linking to these tables and creating a union
query to allow users to access the data from all ...

I have a seperate query made that calculates a total score.
SELECT MOCA.STUDYID,
[Moca_S1]+[Moca_S2]+[Moca_S3]+[Moca_S4]+[Moca_S5]+[Moca_S6]+[Moca_S7] AS
Score, MOCA.Moca_EDU, IIf([Moca_EDU]=1,[Score]+1,[Score]) AS NewScore,

I have a form with a record source: SELECT Contacts.* FROM Contacts;
Contacts has fields LastName, FirstName and CompanyName.
Not every Contact with a LastName has a CompanyName, and not every
CompanyName has a LastName.

In a query, how do I prompt for Ending Date?  I want to also press Enter to
return all records.
Thanks in advance.

Hi, I want to use a union funtion in a query/stored procedure. Below is the
error message displayed. Please help me to figure out what I am doing so
wrong. Thanks MC
Error: Order by items must appear in the select list if the statement

I have the following for an update query:
UPDATE tNEW RIGHT JOIN t05 ON tNEW.[Cust Material Number] = t05.[Cust
Material Number] SET tNEW.[Vendor Material Number] = t05.[Vendor Material
Number], tNEW.[Part Class] = t05.[Parts Class]

I have converted my Access db to an Access Project. All is well except one
search query. In Access, my criteria is:
Like "*" & [Forms]![frmAllSearch]![txtWhatBook] & "*"
I have the same form in my ADP, but when I copy and paste this into my

I have a frequency field and it is a drop down the choices are any
combination of days for example  Mon, Wed, Fri   or Mon, Tues  or Wed or Wed,
Fri- you get what I mean- ANY combination.  Each cleaning job that needs to
be done the frequency gets selected from the dropdown.  ...

Hi, I am reposting this question, any help would be really appreciated.
I have a form with few combo boxes and a subform (query), i want the query
based on the combo boxes selection.
The issue i am facing is in the following line:

I run ~200 queries which modify the data, create some tables etc,
through a  macro. The macro runs when the user clicks a button on a
form. I would like the queries to be invisible while they are running;
but currently the user sees 50+ query windows open/close which is

i have a field called "heat expense", the contents of which are: under 50,
50-100, and so on. i need to find out how many people pay under 50, how many
people pay 50-100, and so on. i cant calculate the total because it is not a
number or currency but a mix of both. i cannot ...

I have a table that has a date in it and it also has the time.  I need to get
rid of the time and leave the date.  What is the best way to do this?

I have a form with three drop down boxes.  The data source for each is the
same.
Driver1
Driver2