Recent content by Tim K.

You can use an Update query to help this out. UPDATE list SET omit12 = sendto; But why do you want to duplicate this? It's not recommended to store repeated info in both fields. :)

What error message did you get? You might use ' instead of " in the SQL statement. Something like this. SELECT DatePart('ww',Date()) AS WeekNum; :)

Just follow the example step by step and you'll understand soon. There are lots of code involved. Just copy and paste in Access. Feel free to discuss more. :)

To me, GetSetting/SaveSetting are limited. I perfor to do this by using API functions. Check this http://support.microsoft.com/default.aspx?scid=kb;en-us;Q145679 out. Hope not to confuse you even more. :)

You have to put this line too. forms("main_form")("sub_form").form.filteron = FALSE

Try this out. ... Dim tdf As Object folder = Application.CurrentProject.Path Set db = OpenDatabase(folder& "\RI Account.mdb") For Each tdf In db.TableDefs If Left(tdf.Name, 4) <> "MSys" Then db.TableDefs.Delete tdf.Name End If Next tdf ... :)

I always use late binding style coding to avoid the References problem. Dim dbs As Object, rst As Object Set dbs = CurrentDb Set rst = dbs.OpenRecordset(...) :)

Change this line from DoCmd.DeleteObject acTable, db.TableDefs(i).Name to db.TableDefs.Delete db.TableDefs(i).Name and make sure to delete all relationships before doing this. :)

A Microsoft Access project (.adp) is an Access data file that provides efficient, native-mode access to a Microsoft SQL Server database through the OLE DB component architecture. Using an Access project, you can create a client/server application as easily as a file server application. In your...

I think you have to add a Number field to the tblExcelimport. Then loop thru its records and assign the newly added field with the DMax("[ID]", "tblData"). Then you can append it to the tblData. How this sounds to you? :)

You can import or link the text file into Access manually and see if all records show up or not. :)

Did you see the sp_ActiveAccounts in Access Queries tab? Is this ADP? If you see the sp_ActiveAccounts in Access, try adding dbo. prefix to its name. dbo.sp_ActiveAccounts :)

It seems to me that you also have set ADO in the References. If this this the case, you have to add DAO as a prefix to all DAO objects. Something like this. Dim dbs As DAO.Database Dim rst As DAO.Recordset ... :)

FileSearch already has a SortOrder property. Check your similar post in the other forum for more details. EMP, LoadFromText is one of several undocumented procedures hiddenly provided by Access. It enables you to create a form from a text file that was created by SaveAsText procedure. To learn...

You can use VBScript in Access with no problem. What are you trying to do with CreateObject?