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

Hi sorry for the late reply How large is a single record? 28 fields, including 1 PK, no FK What's the table schema? Schema dbo How is it indexed? 3 Indexes, UID Clustered this is the primary key, Semana Non Clustered this is the filter paramter, EmployeID Non Cluster What's the query? a...

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

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

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?

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