Search results

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?

Try this out. DoCmd.TransferDatabase acExport, "Microsoft Access", _ "H:\Projects\SSSS.mdb", acTable, _ "tblInventorySource", "tblInventoryDest", False, False H:\ is your mapped drive. Or use UNC instead. DoCmd.TransferDatabase acExport, "Microsoft Access", _...

Force it to save to a new file name. .ActiveDocument.SaveAs FileName:="c:\newfilename.doc", FileFormat:=0 'wdFormatDocument :)

We can't use Index property and Seek method with linked table. Check this How to perform Seek on Linked Tables for a workaround. :)

Hello Nilses, It's me again. Sorry for leaving you high and dry. Check the revised code below. Function BetweenHoursInSecond(DateStart As Date, DateEnd As Date) As Long Dim lngSeconds As Long, lngHours As Long, intHour As Variant Dim IntWeek As Integer, intCount As Integer '...

Try this. DoCmd.OpenForm "frmDenBookingDay", , , "DenId=" & Forms!Main!DenId & " And Date Between " & Now() & " And " & DKount