Search results for query: *

If u use pre-defined styles or images as backround check this : http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q236977

Try use only Chr(10)

You dont say what is the source of your reports, but you can put this (or something like this) as recordsource SELECT [chrCompanyID] & [chrModelID] & [chrHullID] & [chrManufactureMonth] & [chrManufactureYear] & [chrModelYear] AS HIN, chrStage AS stage, chrModelID AS ModelID, Order AS INVOICE...

keusch, You can make an unbound textbox in the form where you want to see the 'Sum' of your remarks and use this code in form's current event Private Sub Form_Current() Dim db As DAO.Database Dim rst As DAO.Recordset Dim str As String Set rst = db.OpenRecorset("SELECT remark FROM...

This may help: SELECT Contacts_Full.ID, Contacts_Full.Address1, Contacts_Full.City, Contacts_Full.ST, Contacts_Full.Zip FROM Contacts_Full WHERE (Contacts_Full.Address1 Is Null OR Contacts_Full.City Is Null OR Contacts_Full.ST Is Null OR Contacts_Full.Zip Is Null) AND NOT...

Try this: SELECT contacts FROM Your_Table WHERE Street IS NULL OR City IS NULL OR State IS NULL OR Zip IS NULL where contacts are the fields you want

Use totals queries (the Sigma button at top. BTW greetings from Greece :-) ). Group by subcategories and sum anything you want.

Put this in SQL view of query (delete anything else) SELECT fname1 & " " & lname1 AS MainAuthor, fname2 & " " & lname2 & ", " & fname3 & " " & lname3 AS Authors FROM Your_Table No need for programming

FoxProProgrammer, Try: If TabCtl0.Value = 0 then RecordSource = "QueryTab1" Else RecordSource = "QueryTab2" End If Me.Requery

Gresford, Why use page brakes? Make your subreports as thin as possible, put them together and put ForceNewPage property for the footer of subreports to After Section. ps: It works but debuging this thing may be a nightmare :-). Its usefull if these reports dont change often.

cdwd, Try: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bapp2000/html/mdbdownload.asp

visualuser, About 80+ sheets, 3MB file, no odbc, no charts, no icons, only calculations, visual basic and some dropdowns.

For the first question u can add a subform to your form bound to your table using all the fields. Then put this code in the nodeclick event of the treeview : Private Sub test_NodeClick(ByVal Node As Object) Dim strPath As String, strSQL As String Dim str1 As String, str2 As String, str3 As...

If you use Treeview Control version 5.0 (SP2) make sure that the coresponding reference, Microsoft Windows Common Controls 5.0 (SP2), has higher priority in references from Microsoft Windows Common Controls 6.0 (SP4). On the other hand, if u use Treeview Control version 6.0 (SP4) do the...

Its not the network i think. I got a user seeing this message with a stand-alone computer, with fresh installation (2 months, formating disk, win98, office2000), working only excel, but quite complicated spreadsheets. No solution till now...

ActiveXCtl0 is the name Access gives to the Treeview control by default (and for other ActiveX objects, but now we deal with Treeview :-) ). Replace it with the name u gave to your control. (Talking about Common Controls 6.0 (SP4) )

Make sure u have references to the DAO object library and to the Microsoft Common Controls object library

Quite complicated but much better : Private Sub Form_Open(Cancel As Integer) Dim db As DAO.Database Dim rst1 As DAO.Recordset, rst2 As DAO.Recordset, rst3 As DAO.Recordset, rst4 As DAO.Recordset Dim tree As TreeView Dim n1 As Node, n2 As Node, n3 As Node, n4 As Node Dim a As Integer, b As...

Put this code in the open event of the form wich has the Treeview control: Private Sub Form_Open(Cancel As Integer) Dim db As DAO.Database Dim rst As DAO.Recordset Dim tree As TreeView Dim n1 As Node, n2 As Node, n3 As Node, n4 As Node Dim x As Integer Set tree = Me![ActiveXCtl0].Object Set db...

At the OnClick event of the button Private Sub OnClick_Button1() Dim oApp As Word.Application Dim oDoc As Word.Document Set db = CurrentDb Set oApp = CreateObject("Word.Application") Set oDoc = oApp.Documents.Add("C:\Your_Word_App.doc") oApp.Visible = True . . do...