Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. thekon

    Constant Memory Errors

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

    Passing carriage return to Word form

    Try use only Chr(10)
  3. thekon

    Passing values to On Format Event of Detail Section for Reports

    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...
  4. thekon

    Merge cells from the same field - group by three other variables

    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...
  5. thekon

    Need Access query for partial record information in 4 fields

    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...
  6. thekon

    Need Access query for partial record information in 4 fields

    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
  7. thekon

    Database query need to subtotal subcategories

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

    Combining multiple fields into one programmatically

    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
  9. thekon

    RecordSource Property Problem

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

    Conditional page breaks in a long report

    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.
  11. thekon

    Requery Method

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

    Excel won't save: disk full error message

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

    A question for Thekon

    ...As String Dim position As Integer strPath = Node.FullPath position = InStr(strPath, "\") If position = 0 Then strSQL = "SELECT * FROM Your_table WHERE Field1= '" & strPath & "'" Else str1 = Left(strPath, position - 1) strPath = Right(strPath...
  14. thekon

    A challenge for the experts

    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...
  15. thekon

    Excel won't save: disk full error message

    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...
  16. thekon

    A challenge for the experts

    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) )
  17. thekon

    A challenge for the experts

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

    A challenge for the experts

    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...
  19. thekon

    A challenge for the experts

    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...
  20. thekon

    Open a Word Document from an Access Form

    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...

Part and Inventory Search

Back
Top