Search results for query: *

Here try this... Private Sub cmdSearch_Click() Me.comboBox1.RowSource = "SELECT Name, Address, Zipcode, Telefon, Email, Notes FROM Customer WHERE Name = '" & Me.txtName & "'" Me.comboBox1.requery if Me.comboBox1.ListCount =0 then ' ... let the user know, ...

Use DoCmd.SendObject SendObject ObjectType , ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile

I'm afraid its not right if you are being forced to do a compact/repair. JerryKlmns is talking about preventive maintenance, not bug fixing. Splitting the database FE/BE will greatly reduce the load on the file on the server. It means there will be less chance of contention and clashes that...

To replace single quotes in ms-access: UPDATE tblEmails SET strEmail = Replace(strEmail, "'", "") To replace double quotes in ms-access: UPDATE tblEmails SET strEmail = Replace(strEmail, """", "") To replace single quotes in SQL-Server: UPDATE tblEmails SET strEmail = Replace(strEmail, ''''...

The Resume statement should clear it, i.e. Resume Next, However it sounds like you need to change your debugging practices to look at count first, or perhaps just looking at err.description instead?

Is the database split into the interface and data using linked tables or are all the users opening the same database with both the data and apps in on a shared drive? If it's the latter then splitting the files would help. It could also be an ingrained problem that the repair is unable to fix...

No, it's built in, you can just use it.

Brilliant, thanks, all the answers I wanted and more.

I learnt long ago that I should use a dot for Methods and Properties (Me.Close or rst.RecordCount); and an exclamation mark for items in a collection (Me!cboCountiesList or rst!strForename) But I've seen a lot of code where I work that only uses the dot. When I asked about this I was told that...

Hey OhioSteve, you don't say what's in this select statement of yours. Does it have any parameters? Is it being run against an SQL server? It could be as simple as: Dim rst As New ADODB.Recordset Dim strSQL As String strSQL = "SELECT strForename FROM tblPerson;" rst.Open strSQL...

Jerry's suggestion should work. What is happening is CreateObject("access.application") opens a new automation instance of MSAccess.exe rather than a connection to a database. Access doesn't normally clear .ldb files till it quits so doing dbase2.Quit should delete the file. But... Using...

Of course in SQL 2005 it's much easier SELECT number AS ASCII, char(number) AS Character INTO tblASCII FROM master..spt_values WHERE (type = 'P') AND (number <= 255) ;-)

To answer my own question, the files were being opened by the "Visual Sourcesafe LAN Service". I don't think it gave much of a speed improvement so I've disables it.

VSS isn't the best product in the world, but its the only source code control system I know that is integrated with MS-Access... I've been thinking how hard would it be to get another source code control system (such as CVS or Subversion/SVN)working with Access on an object level. You'd need...

I have my VSS database on a Windows Sever 2003 box set up to automatically analyse the database every night. Sometimes the analysis fails night after night with the following in the logs: Visual SourceSafe Analyze Version 8.0 Copyright (C) Microsoft Corporation. All rights reserved...