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!

  • Congratulations strongm 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. BradCustom

    Need help with setting a value to 0

    Thanks for the help! I'm using Crytal Reports 2016 and I'm trying to set the value of a field to zero if the sum of FG_Trans_Qty doesn't equal the Invoiced quantity. The trouble I'm having is there are many variations in the shipping records. Most times there is one record for each...
  2. BradCustom

    Passed variable from Subreport to Main skips one row

    Thanks fisheromacs, Your suggestion worked! I had to change the structure of the report but it works so that's the important thing! Brad
  3. BradCustom

    Passed variable from Subreport to Main skips one row

    Thanks for responding! I think it's correct too, that's why it's driving me crazy. Below is a screen shot of the main formula. Here is a screen shot of the Main Report. The Unit Price field that is suppressed is from the Job table. The Unit Price I'm using in the Subreport is from the...
  4. BradCustom

    Passed variable from Subreport to Main skips one row

    Hi Everyone and thanks for your help in advance! I'm using Crystal reports 2016 and I'm having a problem with passing a shared variable. Oh the subreport "Sub-PartActInv" I have the following formula which passes the Unit Price to the Main Report. Here is the formula for the shared variable...
  5. BradCustom

    Connect to Excel Spreadsheet

    I'm using Crystal Reports 2016 (32-bit) and trying to connect to spreadsheets created in Microsoft 365 (64-bit). The original reports were created with CR 2016 and Microsoft Office 2016. Now that we've updated to Microsoft 365 the Microsoft Office 12.0 Access Database Engine OLE DB (ADO) is no...
  6. BradCustom

    Running total on variable

    Thank you lbass, that works perfectly! I did make one change because I want to hide the detail section. I moved the subreport to Group Footer 2. Thank you for your help!!
  7. BradCustom

    Running total on variable

    Sorry everyone, I noticed this morning that I posted the same formula twice. The formula for the Scrap Cost for each line is wrong in the above post. Below is the correct Scrap Cost for each detail line. (({Job.Est_Labor}+{Job.Act_Material}+{Job.Act_Service})/{Job.Make_Quantity})
  8. BradCustom

    Running total on variable

    I'm using Crystal Reports 2016 and I'm having a problem with displaying the calculated running total in the report footer. As long as I don't Hide or Suppress the Detail or Group footer all of the formulas calculate correctly. If I Hide or Suppress the Detail or Group footer (which is what I...
  9. BradCustom

    Convert Access query to SQL query

    Andy, Thanks so much for your reply. I found the issue with the SQL statement. Because the tables are linked to the Access database the table name has a "dbo" prefix which of course isn't needed in the SQL statement. Below is the code that works. SELECT Employee.Employee...
  10. BradCustom

    Convert Access query to SQL query

    Andy, Thanks for the reply and suggestion. I've fixed all but one error which I don't understand why this error is coming up. Below is the second version of the code. The reason I didn't use your suggestion for the DateDiff is because it's a DateTime field and some of the entries are only...
  11. BradCustom

    Convert Access query to SQL query

    I'm working with Access 2016 and SQL 2012. I'm trying to convert the following query from Access to SQL but I keep getting errors. I've listed the statement and the errors below. Any help would be very much appreciated. SELECT dbo_Employee.Employee, dbo_Employee.Last_Name...
  12. BradCustom

    Form Field limited to 255 characters

    WOW!!!! Thanks strongm and Andy!!! It actually works as expected!! Here is the wining code Private Sub cboOperation_AfterUpdate() With Me.cboOperation Me.txtOPNo.Value = .[Column](2) Me.txtSetupHrs.Value = .[Column](3) Me.txtRunRate.Value = .[Column](4) Me.txtRunType.Value =...
  13. BradCustom

    Form Field limited to 255 characters

    Andy, How is your Note_Text field defined in your dbo_Job_Operation table? Note_Text's Data Type is Long Text with a Text Format of Plain Text So if you do this request in a SQL view of a query: SELECT Note_Text FROM dbo_Job_Operation WHERE Job = "202550" AND WC_Vendor...
  14. BradCustom

    Form Field limited to 255 characters

    Unfortunately the output is the same as before. So here is what I've done. I added a Debug.Print txtOrgChange so that I could see what text the code is calling. So, here is the output from your code in the last post. [WC_Vendor] = 'CMV-KIT3XI' And OpNo = '60' And Job = '202550' [highlight...
  15. BradCustom

    Form Field limited to 255 characters

    Yes they are all on frm_ChangeEntry
  16. BradCustom

    Form Field limited to 255 characters

    Still the same problem, Note_Text is not the correct value.
  17. BradCustom

    Form Field limited to 255 characters

    Good Morning Andy, Below is the entire code for both cboJob and cboOperation as well as each cobobox's Row Source. cboJob Private Sub cboJob_AfterUpdate() Me.txtPart.Value = [cboJob].[Column](1) Me.txtPartRev.Value = [cboJob].[Column](2) Me.txtPartName.Value = [cboJob].[Column](3) End Sub...
  18. BradCustom

    Form Field limited to 255 characters

    Andy, You either have all of these 'double' controls on the form, of you should have a whole lot of syntax errors while running your code. Before I copied and pasted your last suggestion I had changed all the references to comboboxes to be cboNAME. Unfortunately it didn't seem to correct the...
  19. BradCustom

    Form Field limited to 255 characters

    Ok, so I copied and pasted your entire code, saved it and then closed the form. I opened the Form and selected Job 202550 and then Operation CMV-KIT3XI which is OpNo 60 but the text that was populated into orgChange from Note_Text was from Operation CMV-KIT3XI, OpNo 10. I don't get why it's...
  20. BradCustom

    Form Field limited to 255 characters

    I tried that but I will try it again. I thought it could be a timing issue.

Part and Inventory Search

Back
Top