Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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