Recent content by nealvenables

Thanks! I'll have a play with this code when I've got an afternoon free :)

Unless a process has a file in the Temp folder open it's safe to delete anything in there. In fact, it can be a good idea security-wise to empty the Temp folder regularly. I use a utility called TempCleaner to empty my temp directory on bootup - you'll find it here http://www.ipaw.net/index.php

Hi, Short version of this question first:- Is it possible to configure WinXP Pro so that it automatically executes a batch file (or other type of script) whenever it resumes from standby mode? Longer version:- I use a PCI latency utility to override the default PCI latencies on my PC...

D'oh! This string is being constructed in VB or Acces VBA isn't it? If Access, try: "TimeSheet.MonthYear = '" & format(formonth, "dd mmm yyyy") & "'" I don't know off-hand what the VB equivelent of Access' format function is, but if your code is running in VB...

Hi, Try "TimeSheet.MonthYear = '" & cast(formonth as datetime) & "'"

Hi, Try this... dim adoCMD as new adodb.command dim strSQL as string <your TransferSpreadsheet and msgbox code here> strSQL = _ &quot;INSERT INTO tblExport (User, [Computer Name], [Date]) &quot; & _ &quot;SELECT '&quot; & Environ(&quot;username&quot;) & &quot;' as Expr1, &quot; & _...

Hi, At the very least, error trapping keeps your application up and running (especially important if it has been compiled as an mde), without presenting your user with too many unfriendly system dialog boxes. A very simple error trap would look like this: public sub MyProc() dim strMsg as...

Thanks Doug. Excellent suggestion and excellent resources too.

Hi, You could also use: strBalanceSc = format((rstOCR!Balance * 100),&quot;000000000&quot;)

This is driving me nuts! I'm trying to open an ADO connection to an Excel file, so that I can load the contents of the Excel file into an ADO recordset. The code looks like this... adoCNN_XL.ConnectionString = _ &quot;Provider=Microsoft.Jet.OLEDB.4.0;&quot; & _ &quot;Data Source=&quot; &...

Hi, Open the form in acDialog mode, e.g. ' Open a form that will effect the rowsource of me.lstitems docmd.openform &quot;myForm&quot;,,,,,acDialog ' The following line will not execute until frmMyForm has closed me.lstItems.requery

Hi, This may not be exactly what you're looking for, but in 2000 I've always used DoCmd.TransferDatabase with the acLink constant to link tables.

Surprised that there's a subquery involved here(!). Can you post the SQL statement that your query is based on and I'll take a peek...

Hi, If you could persuade your users to be disciplined in naming their queries, e.g. by prefixing them all with user_, then you could clean them up programtically. Public Sub RemoveOldQueries(dtmCreatedBefore As Date) Dim daoDB As DAO.Database Dim daoQDF As DAO.QueryDef Set...

Hi, Try this query... SELECT FilmTitle, iif((Responsibility like &quot;*produced*&quot; or Responsibility like &quot;*direct*&quot;), &quot;&quot;, Responsibility) FROM YourTable