Recent content by cliffhanger9

Hi all I am doing a mail merge and have a tab delimited text file with 10 fields as the data source. I only need the data from two of them - the product number and price. There are a lot of duplicate records that I would like to not merge into the mail merge template. I cannot alter the data...

onpnt - you certainly can add an order by clause to the stored procedure. However the convenience of having SQL stored in a reusable procedure is that you can call it from many different places - code reuse. So since this is the only instance that I want to have the data sorted this way - I'd...

BINGO - I was just suggested the same thing in the MSDN Newsgroup for ADO i ll try giving it a column name alias

Not to come across as a jackass here but... do you guys read my post at all? I know about the sort property - infact the example on that link of yours is the same one i used in the first paragraph of my initial post. That sort property as far as I can tell requires a field name. there is not...

thanks for the response - i was more interested in an ADO solution if possible as the database function is called by alot of different places - thats the beauty of these things - most of which are not sorted the way this particular instance needs to be so I was looking for a way to merely sort...

Hi all, I have an ADO recordset that is populated from a stored procedure that uses several functions to concatenate one of the fields of the recordset so as such there is not a direct field name to reference in the sort (i.e. <% rs.Sort="CompanyName,ContactName" %> ) I know that there is no...

rudo - as you say it is possible. I dont know how to do it in access VBA but I think what everyone here is suggesting is that you consider redesigning your database. Do a serch for database normalization to learn more. Basically from what you have described it sounds like a poor database...

To run from a form button... Private Sub cmdUpdate_click() Dim strSQL As String strSQL = "UPDATE CUST SET CUST.TEXT_FIELD = Right([TEXT_FIELD],Len([TEXT_FIELD])-100)""" & _ "WHERE (((CUST.TEXT_FIELD) Is Not Null));" DoCmd.RunSQL strSQL End Sub

I currently have a module that has global variables set at the top. I would like to however store these values in a table so that I can build a form for someone who does not know VB and they can go to the form and change the settings, or values of the global variables. I would like to set the...

Why can we not edit posts here???!?!?! thats rediculous. Anyway...you also may want to "normalize" your database structure to eliminate the redundancies you have displayed above.

The import file does not

Do you not have a primary key?

I am trying to automate an import process and was wondering if anyone has had any luck building an import specification on the fly from VBA. I guess it would have to consider the list of fields and the delimiters etc.. If anyone has, or has any suggestions on how to accomplish this (if even...

Thanks PHV I dont understand how it works though... That looks like you are putting the primary key value in already. That is the bit that i dont know...I am looking to inject a function with the name of a table. The function will return the name of the primary key for that table. You might...

Hi all - I m sure this is easy I have just never done it programmatically though... Is there a simple little VBA script that will stuff the fieldname that is the primary key of a passed in table into a variable? Thanks in advance!!!!!!!!!