Search results

Thanks!!

just delete the "Email:" part

Is there a way to write an update query that strips the phrase "Email: " from a field whose value actually begins with "Email: " and leave alone those that are normal like "angusreide@hotmail.com"?

Like putting count() at the beginning of the query and GROUP BY (State) at the end?

I need to modify the following query to count the number of people in each State in the US, any clues?: SELECT dbo_certs.peopleId, dbo_People.FirstName AS [First], dbo_People.LastName AS [Last], dbo_Status.StatusName AS Status, dbo_PeopleContactInfo.stateAbbrev AS State FROM...

Thanks in advance for any clues on making this query work. I am trying to count the number of applicants in each of 3 categories for a date range so that my datasheet view looks something like this: Applications Education _________ _______ 27 Phd 134 Masters...

This brings up the nagging window to enter a DSN name

I get a debug on this line: If .Connect <> "" Then "Object no longer set"

How do I make this code below actually run... and do I put my table's name in place of "TableName"? Option Compare Database Public Const CONN_STRING As String = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=GCDF_DB;Data Source=BADLANDS" Public Sub...

I'm confused about how to use the code "If not, try using code to change the connection string in the linked table"

Only when using code for a Sub like below: Dim con As ADODB.Connection Dim cmd As ADODB.Command Dim rs As ADODB.Recordset Set con = New ADODB.Connection Set cmd = New ADODB.Command con.ConnectionString = CONN_STRING...

I have with a module this connection string already: Option Compare Database Public Const CONN_STRING As String = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=GCDF_DB;Data Source=BADLANDS"

Unless I'm missing something... Wow... I have 8 Access databases each with 20+ ODBC connected tables

You mean having each of the dozens of adds, updates, deletes, etc. have code to open and close the database like one would use in a .net application?

My usually expected DSNs are missing, I can create one but it fails like above.

"ODBC--connection to 'BCC_DB' failed"

I just got a new PC at the office and my old ODBC connections to SQL Server are failing. I tried loading the registry files but no luck... any ideas?

then it in debug highlights the next line in yellow: Set rs = frm.Recordset

Same error

Changed to but same message: Set frm = Forms!frmSwitchboard!dbo_MHF_Standard_subform