Search results for query: *

I already found a solution myself I used a measure in power pivot and that worked perfectly

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

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

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

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?

Olaf i tried you approach "Change the query to: Select employeeid, name, lastname, seccionid from premployees where semana = ?This.dSemana" and like for a magic enchant it worked!!!! I am very happy, now on the client side takes milliseconds thanks to all of you

thanks to all of you guys after all your replies I have to conclude my design is wrong and I need to change it

Mike This is one of my points mentioned originally if i pull only one record at a time, this will affect the behavior of my Search windows which uses a grid to display all records also will affect my next, prev, first, last buttons behavior i understand this is the best approach, i am just...

...key, Semana Non Clustered this is the filter paramter, EmployeID Non Cluster What's the query? a basic select statement with explicit fields (no *) and a where Clause ?Semana = ?ldSemana What back end are you using? MSSQL 2008 Network I thought about this, buts doesn't seem to be the...

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

Good point Mike, i didn't think that message through i will remove it regarding the Form Collection Class. I think it could be helpful when you need a lot of things. but when the only thing you need is one small thing, _screen.forms is quite enough

Tnx Olaf My code then should work. for some reason i thought i wouldn't

...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 *:Verificando si ya existe una instancia de la forma a correr. Solo se permite una instancia FOR EACH loForm IN _screen.Forms *:Si hy una forma...

Mike yes, your APPI is what i was looking for. i m sorry i didnt said so. my last post it was just to have all the context perfectly clear. thanks a lot for all the comments and help

For the benefit of the knowledge let us understand what I'm trying to achive This is a Time Clock Attendance App. This is a normal computer running Windows XP SP3 The applications Runs 24 hours a day 7 days a week Of course it has a timer, cause running 24/7 needs to do some "refresh" on...

i undesrtand what you are saying. and we will fix the OS issues. in the mid time i am pretty sure there is some APIs to access windows on the desktop and bring my app on top any one?

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

Indeed odbc error no is 1526 I am trying to find out if there are some other

I understood what you said. Let me point to the statement I made: AERROR gives you an array containing the error even if the link is broken My question would be what are the error numbers that tell me the link was broken?

...useless the form tries to read and write data to back end from time to time using SQL Passthrough like lnSQLResult = SQLEXEC(lnConn,"select * from table") i know if lnSQLResult is -1, this means something went wrong I know aerror retrieves the error from the SQLEXEC I Know element 1,1 is...