Recent content by DJN

Yes it is possible, but with that amount of data, it could prove problematic. A more complex table, which has multiple sections, merged cells, totals and subtotals, and so on, importing it won't be straightforward. Access tables have to be absolutely consistent: every record must have the same...

I prefer to make each line seperate with a space at the end. I can see what I am doing then.Just my opinion. It may help. Dim strSQL As String strSQL = "INSERT INTO TblScore ( AssessmentID, ParmsID, SiteID ) " strSQL = strSQL & "SELECT Assessment.AssessmentID AS Expr1...

In the forms Load event, put Me.txtMyCalendarControl = Date Just change the name of the calendar control to your own.

There is a much shorter code version. Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Public Function GetNTUser() As String 'Returns the network login name Dim strUserName As String 'Create a buffer...

Group on column 1, sort on colunm 2

This will transfer the contents of the two queries to two worksheets in the one workbook. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryYourQueryName1", "PathName.xls", True, "WorkSheetName1" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryYourQueryName2"...

Simple answer, you can't.

Try this Private Sub Command0_Click() Dim msg As String If IsNull(DLookup("FieldName", "QueryName")) Then msg = "No data. " MsgBox msg End If End Sub

Have you thought of using the 'Like' operator?

DoCmd.RunCommand acCmdNewObjectReport will open the Report Wizard Dialog box

Sorry, forgot the link. http://www.granite.ab.ca/access/email/lotusnotes.htm

Don't know if this is of any help?

What exactly are you trying to print. The table or its data?

Have a look at the OpenArgs action in the help files.

Try using the full path name. Call Shell("C:\program files\Microsoft Office\Office11\excel.exe PathName:\XL\XLSFileName.xls", 1)