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

    Calculate percentage between to column values in pivot table

    Hi guys I have a pivot table Year and Week are Rows Orders and Return Loaded are calculations based on sum(OrderSum) and sum(Reutilized) respectively what I need is a third calculation based on the division of Return Loaded and Orders This is to show what % Reutilized represent of the...
  2. mejiaks

    Calculate % of a Row Grand Total

    I am stuck here with a Pivot Table if you see the image Business center and Month are Rows Rev, Exp are the type of values where USD Amount is sum The Gran total is the automatic Total that the pivot table add. What i need is to have another Column to show the % of the Gran Total against Rev...
  3. mejiaks

    Pivot table calculated colum

    Hi I have a table that looks more or less like this: Reference Orde BillTo Date 1 1 C1 01/11/16 1 2 C2 02/11/16 1 3 C3 10/11/16 2 4 C4 02/11/16 2 5 C5 05/11/16 2 6 C6 12/11/16 3 7 C1...
  4. mejiaks

    Windows 7 Embedded

    Hi guys probably this question has been asked one time too many, but i've been researching and not much info out there does a VFP9 application run on Windows 7 Embedded? AKA Windows Compact 7?
  5. mejiaks

    big backend tables and cursordapters

    I know that probably this question has been asked before but i haven't been able to get the answer i have been looking for. let me explain you guys in detail the scenario: 1. I have a table PREmployees, 2. The employees for this customer are about 2,000 people 3. The application was requested...
  6. mejiaks

    Count Child forms on MDI form

    Hi guys i am trying to avoid a Child form open twice in my MDI form how can i find out if an instance of the child form is already open? i know how to do this when using _screen as MDI, but now i have an own MDI class I want to use Karben Selim Mejia LOCAL lnInstances lnInstances = 0...
  7. mejiaks

    i want my application to be on top always

    i have been facing some issue with a time attendance applciation i developed recently. the last problems were not related to the application it self but with some errors outside the aplication. since this is a finger print recognition application, the application must have to be on top of...
  8. mejiaks

    Check SQL Connection Status

    I have one form open 24/7 and a global connection hanlder open from the main program (lnConn) from time to time the SQL Service become unavailable (please do not focus on this problem cause i am not trying to solve this) due to this, the lnConn becomes useless the form tries to read and write...
  9. mejiaks

    gif file in use

    Guys i have a gif file displayed in a form, this form is open 24/7 since it is a time attendance clock from time to time, Human resources wants to change the gif file, in theory, it it just save the new gif with the same name and the refresh will do the rest. but when trying to replace the...
  10. mejiaks

    IP Address or Host name on the email header

    Recently we faced an issue of somebody impersonating another users and sending emails using their accounts. We tried to investigate using the email header and we found out that when coming from outside the header includes this info, but when is internal communication, the exchange doesn't...
  11. mejiaks

    finding a user name using the S-1-2-5 .... seed

    i have some sort of ID in active directory S-1-5-21-91300945-something as the owner of a file i would like to retrieve the user name for that can this be done?? TIA
  12. mejiaks

    Location maintenance screen takes ages to refresh

    Hi, I really hope you guys can help me up with this. I just upgraded from 5.2 pervasive to 5.3 mssql, so far , so good, except for some issues. the one i need help with today is with the location screen on Inventory control module. For some reason when i tried to navigate from one record to...
  13. mejiaks

    more than 5 years of fiscal sets

    Our customer reach the moment of having more than five years of fiscal periods, now they want to run the closing of the year. They get this message saying they will loose the oldest period which is 2004. We tried to increase the number from 5 to 6 years but it wouldn't allow it. is there any...
  14. mejiaks

    Invalid input. Quantity must be a multiple of build qty

    I am getting an err message when running the end day process of IC accpac 5.3B when i run data integrity check i can see this two lines of error saying assembly 6977 Invalid input. Quantity must be a multiple of build qty 442.000 assembly 6978 Invalid input. Quantity must be a multiple of...
  15. mejiaks

    Accpac user guide and manuals in spanish

    Do you guys know where can i get the Accpac 5.3 manuals and user guides but in spanish? I have installed accpac 5.3 in english and have the language package also, but no spanish user guides do i have to buy them?
  16. mejiaks

    User profiles importing Accpac 5.3

    I did the upgrade from 5.2 Pervasive to 5.3 MSSQL, everything went good, but the user profiles seem not to be there the securty groups are there, but not the users? did i do something wrong? o do i have to do something additional?
  17. mejiaks

    Migration and Uppgrade of Accpac

    Finally after several months, my co. is ready to Upgrade versions of Accpac. Currently we have Accpac 5.2 with PervasiveSQL 8 for workgroup and now we are going to move to Accpac 5.3 for MSSQL My question is very simple, and i am pretty sure the answer is not that simple. but: What do i...
  18. mejiaks

    Dynamic Table using access db

    Hi, I am trying to work with a Dynamic table with ASP Java script. I have everything configured, the test server, which happen to be the same machine where i am working. the recordset is working properly, I have tested within macromedia and it shows me the records on my table. here is the...
  19. mejiaks

    Click on Flash Button doesn't work!

    I am trying to use a Flash Button in a html table to open a document or URL. Nothing seems to work. I have tried OnFocus event, OnClick Event with the getURL() but nothing seems to be working I also tried to change the flash button to a regular button and still doesn't work. I thought maybe i...
  20. mejiaks

    spry table layout

    Hi, I just added an spry table to an html page to show the content of an XLM file. so far so good, the table looks like this title | description Item1 Item 1 description Item2 Item 2 description here is the question: Is there any way to change the layout of the table to look like...

Part and Inventory Search

Back
Top