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: *

  • Users: timhans
  • Content: Threads
  • Order by date
  1. timhans

    How to get top 2 variance

    Hello new to Crystal Reports. I have a report based on a survey I have tbl.Theme where there are 14 Themes under each theme there are questions. I have the variance calculated for each theme, how do I either 1) Get the top 2 variance and the bottom 2 variance for all themes 2) Get all...
  2. timhans

    How to print report to pdf by members of group

    New to Crystal Rreports I have a report based on a group (using the group expert), the items of the group are peoples names; Bob, Jane, ... Is it possible print the report to separate pdf's based on the group's items i.e. the names; Bob, Jane, ... with a formula or...something(I know there are...
  3. timhans

    Format zero in chart to hyphen or null

    Hello, very new to Crystal Reports. I have managed to write a conditional formula (it is my first and only took 15hrs to figure out). Table name is 360 two of the fields in the table are "Relationship" and "Score" Conditional_Client If {'360_'.Relationsnhip}="Client" then...
  4. timhans

    create two new tables from one existing table

    Hello very new to writing sql,I need to create two new tables from one existing table. One table is all of the data of 1Section and the second table is all of the data of 2Section. I have been trying but not getting it. Any help is very appreciated. Thanks | ID | SUBJECT | RELATIONSHIP |...
  5. timhans

    Transparent form with text

    Hello, Odd request maybe, but has anyone seen or have a link to or now how to make a bound transparent form that show the text from a text box. I have found to code for a transparent form but you can not display text on it, which I need to do, i.e I need to place text boxes on a transparent...
  6. timhans

    Many Records to one

    Hello, not sure if this is the right forum for this questions. I have a crystal report which I imported into Access, the table is like so ID Insurance Name ID1 Ins1 Name1 ID1 Ins2 Name1 ID1 Ins3 Name1 ID2 Ins1 Name2 ID3 Ins1 Name3 ID3 Ins2 Name3 ID3 Ins3 Name3 ID3...
  7. timhans

    combo box to open on nth entry

    Hello, I am triing to get a combo box to open on a certain entry when I open it every time, I was tiring Me.Mycombobox.listvalue(n) where n is the nth entry in the combo box, clearly confused about listvalue property. Thanks
  8. timhans

    ado Cmd.Execute ignoring sql statement

    My apologies for posting so much, but I am making a big push to get this stuff and I am finding it confusing. So I can know execute a update and insert sql statement, but not a select statement that parse's my table I don't get a error it just is completely ignored, the sql statement runs in...
  9. timhans

    Trying ADO Cmd.Execute first time

    Good morning, Trying ADO Cmd.Execute for first time, getting error msg run time error '-2147217833(80040e57)' Field to small to accept the amount of data, but runs in GUI as well as Docmd.Run SQL Attempting to update table with SQL statement here is the code I am using, any thoughts, comments...
  10. timhans

    ADO on load connection

    Hello, I am following a example in a book on how to ADO connect with on load event. The book I am using is for Access 2007(I have at home and do most of my work) and puts the following in a class module: 'Declare connection object variable Dim cnn As New ADODB.Connection 'Declare...
  11. timhans

    In ADO ecacute multiple SQL Statements

    Hello, say if I have multiple SQL statements say SQL1, SQL2,SQL3 is there a perfered method of execution i.e rs.open SQL1 & SQL2 & SQL3 or rs.open SQL1 rs.open SQL2 rs.open SQL3 any comments or insight is appreciated, thanks
  12. timhans

    msadox.dll error

    Hello, I was hoping some one could give me guidance, I use the code below to gather table and column names and it works but when I compile my database or when I first open it I get this msg. msadox.dll version 6.0. is missing or broken Tried googling answer and using different libraries but...
  13. timhans

    ADO: Get table name / exclude name

    Good Morning, The code below collects table names and column names and fills combo boxes with them(I did not write it, just using it), can the code be altered so that a table name can be excluded from from being captured. Thanks Sub ListTableandColumNamesADOX() Dim Conn As New...
  14. timhans

    Another Parsing question

    Hello,in a earlier thread PHV provided succinct parsing function for a single delimiter of choice but at time's I have need for a multi parsing function. Found the following code which parse's with multiple delimiters, can not get it to work, not sure I am calling it correctly, in query...
  15. timhans

    Generalizing a Parsing function

    Hello, I have a parsing function which parse's with respect to a comma. If I go in to the module and change where the comma is declared and change it to a . then it will parse w.r.t a . similarly for a space or tab. So know I have three modules to parse three different ways. This is for a...
  16. timhans

    Function or Public Sub ?

    I cobbled together my first function two days ago(with help from the form) Function ClearAll(c As String, f As Form) Dim ctl As Control For Each ctl In f.Controls Select Case ctl.ControlType Case acTextBox, acComboBox, acListBox, acCheckBox If ctl.ControlSource = "" And ctl.Tag <> "c" Then...
  17. timhans

    Programing a Function 1st time

    Hello, my first attempt at coding a function, I have this Function ClearAll() Dim ctl As Control For Each ctl In Me.Controls Select Case ctl.ControlType Case acTextBox, acComboBox, acListBox, acCheckBox ctl.Value = Null End If Case Else End Select Next ctl...
  18. timhans

    max value

    Hello, I am making a parts order form and I need to get the max value from three fields MSRP MarkUp HcpcPricing Naively thought there would be a built in function. Thanks
  19. timhans

    Printing problem

    Hello, I all the sudden developed a proplem with printing, Have bound(autonumber) form which I send to a report with following code Private Sub Command101_Click() DoCmd.OpenReport "rptBuildSheet", , , _ "ChairBuildDetailsID = " & Me.txtChairBuildDetailsID.Value DoCmd.GoToRecord , , acNewRec...
  20. timhans

    Alter a &quot;found&quot; ADO Statement get table names

    Hello,I "found" this from googling, it prints to the imediate window all the table names and there field names. I have a need for this but for all the table names to fill a combobox and the field names per table to fill there own combobox. This past my skill level. Thanks Sub...

Part and Inventory Search

Back
Top