Search results for query: *

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)

I would try a compact and repair. Also I would try to find out why it became corrupted? Not easy I know, but it could happen again.

In your query, create another field, CombinedNames:[FirstName] & " " & [LastName]

If you are trying to average a set of fields, e.g. average[fld1],[Fld2] etc.etc, you could use this function. Function RAvg(ParamArray FieldValues()) As Variant '---------------------------------------------------- ' Function RAvg() will average all the numeric arguments...

No need to feel fooish. Sometimes you can't see the wood for the trees. Anyway, glad to be of help.

OK lets start from scratch. Create a new form. On the form place two unbound text boxes, txtStartDate txtEndDate.Close and save the form as frmSearch. Next, create a new query. In the design grid choose your table. Choose the fields that will appear in the report. Now, in the criteria of the...