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 Rhinorhino 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: appelq
  • Content: Threads
  • Order by date
  1. appelq

    Cash Batch and Bank Fees in Dynamics GP

    Importing a Cash Receipts Batch would normally Debit Cash for the amount of the Check and Credit an A/R account for the same amount which is also the total of the invoices being paid (Entries in the RRM20201 Open Transactions Apply table). However US Bank when depositing money in our  KeyBank...
  2. appelq

    Receivables Batch Print the edit list is not working for an imported Cash receipts batch

    I imported a Cash Receipts Batch. I can open the Batch in Receivables Batches. But when I go to click on the PRINT icon to review the batch before I post it, nothing happens when I click on the Print Icon. I ran queries on several tables that were inserted into and compared to a manually...
  3. appelq

    SQL Server 2012 Bulk Insert CSV File where a column (Cust Name) May have commas

    I have a CSV File with 17 columns, where one column [CustName) has various customer names and some of them have commas. Example "ABC Company, Inc" I want to Bulk Insert the CSV file into a table. The command is: BULK INSERT [dbo].vPTInsert FROM...
  4. appelq

    SSIS import from CSV is truncating the Decimal

    I'm using Visual Studio Pro 2017 v15.9.11 to create a basic SSIS Package to read data from a CSV File. In my SQL Table (I am importing INTO) I have a column - [InvAmt] as decimal(19,2) In my Flat File Connection Manager, (for th eCSV Import file) the column is set : DataPrecision = 0...
  5. appelq

    Text Box based on Combo Box is slow when opening existing records

    I have a form [Containers] with a combo Box for [cboCustID] The Row Source is: SELECT dbo_tblCustomers.CustID, dbo_tblCustomers.CustName FROM dbo_tblCustomers ORDER BY dbo_tblCustomers.CustName; There are < 100 Customers in the dbo_tblCustomers and when adding a new record in [Containers] the...
  6. appelq

    GP Printing AP Checks is S..L..O..W....

    Running Dynamics GP 2015 with SQL Server 2012 SP2 Users connect with VMware Remote Desktop Servers. 2 A/P groups: 1 is local to here the server is hosted. The other is at a remote office with a 10MBs Internet connection that is not being over used. A/P checks are Laser Checks using Mekorma for...
  7. appelq

    EXCEL paste formula into cell after having Parsed on Commas causes formula to break into parts

    In Excel 2010 I pasted data from another source that was Comma separated values (not a CSV FILE) I then did the DATA / Text to Columns function; using Delimited, on Commas that worked fine. I then inserted a column and pasted a simple formula =IF(G2>0,LEFT(G2,6),"") <-- Note this has 3...
  8. appelq

    Allow user to Filter on Form with Button

    There may be a better way to solve the problem and I am open to any ideas. In short the problem: I have a form that tracks "Containers" when they come to our yard. A container may come and go many times or the course of time. My user would like to enter the Container Number and have the form...
  9. appelq

    Connecting a switch to the PC port on a IP230 phone

    I have Cisco switches with POE. 2 VLans (The phones are on VLAN2 (10.10.x.x.) VLAN1 is for the PCs, etc. (192.168.x.x) I plug the ShoreTel 230 Phone set into the Wall Jack and a PC into the PC Port and it all works fine. However I have 4 workstations that have small 4-port netgear switches, to...
  10. appelq

    Sub-form get value from main form

    Looking for guidance on how best to do the following: I have frmServiceHeader and a sub form sfrmServiceDetail. frmSeriveHeader has various information including the TaxRate and LaborRate for the particular customer. When I add a Row to the sfrmServiceDetail, I want to enter thing like Labor...
  11. appelq

    Access 2010 Report Print Preview problem from Switchboard

    I'm running MS Access 2010. I have a Switchboard that calls a report in Print Preview. This works OK. However, if I click options on the Access Quick Access Toolbar for Print, or Email, what actually prints (or emails) is the Switchboard Form, not the report. If I run the report directly from...
  12. appelq

    Populate Text Box From Combo box returns error #Name?

    I have a table - tblCustomers with CustID and CustName On a Form I put a 2 column combo Box - cboCustID and it works fine. The Drop down is set to show both columns from the table. I have an Unbound Text Box - txtCustName I want to populate from the 2nd value in the combo box. In the...
  13. appelq

    How to identify a PC using all the available bandwidth?

    I have a multi-site private network using MPLS. We have a Private IP scheme using 192.168/24 addresses where the 3rd octet identifies my sites. Users ate one site, have 2 bonded T1's for a 3MB port to the MPLS cloud. They tell me that during the middle part of the day, their access to the...
  14. appelq

    Drag Rows to sort a list - shortcut?

    I have a To-Do List in Excel, that I am constant reviewing and manually re-sorting items (rows). As priorities change, I may want to move rows around. What I do now: Highlight the row, hit [Ctrl]-[X], Right-Click on the Row I want to move the cut row to, and select "Insert Cut Cells" Which...
  15. appelq

    Need a way to set ALL Users to &quot;Must Change Password on next login&quot;

    We have Windows Server 2003 with active direcotry and most all users are setup that "Password Never Expires". We've recently had a security issue, and I want to set all of the User accounts to force them to change their Password on next login. Is there a way to do that with a script or query...
  16. appelq

    Access report - 2 &quot;Groups&quot; per page

    I have a report, "Winning Bidders" for a silent auction. The table "Baskets" has Basket#, Name, Winning Bidder, Amount Bid. the report groups on [Winning Bidder] and shows each basket they won, and prints a Total Due in the Group footer. the total number of won baskets for any bidder will be...
  17. appelq

    Tab into currency field only allows 1 digit. Arrow key OK?

    I have a form - frmProducts The Table is tblProducts with a field prd_Value prd_Value is defined as Decimal, currency, 18 ,2 The field on the form is a Textbox, bound to the prd_Value field,Format= Currency, 2 decimal places. The user is entering data and hits the Tab key to move through the...
  18. appelq

    Access 2007 output to Excel not working

    I have several MS Access databases created in prior versions of Access (i.e. 2003) that have reports that get exported to Excel. A Macro runs various queries, and the final step is using the Output To macro command to create a new Excel Spreadsheet. It works fine using Access 2003 but now some...
  19. appelq

    Excel from Access - Insert formulas after records

    I have an Access application that outputs data to an existing Excel Spreadsheet. I have code that writes a recordset with varying number of rows to the spreadsheet starting at Cell A25. My existing code is below and works great. What I need to do is: 1. Find the next blank row on the...
  20. appelq

    Need to View / Edit a DLL

    I was given an ASP.NET application that connects to a SQL Server Database. The Database was backed up off the old server and we installed it on our servers just fine. The ASP.NET application attempts to make a database connection but that function is in a DLL file and it seems to be hardcoded...

Part and Inventory Search

Back
Top