Search results for query: *

yes that does make it clearer... thanks.... by the way... I tried to include the inout_date field in the last query that you sent, but I was unable to get it to work properly... I think what was happening was that it was returning all the check out record, their file numbers and their dates...

please excuse that repost... mistake on my part - Matthew Montalto

ok... I now completely understand how this modules function works... though I still find it interesting that remainders of .5 are returned as 1 I am not exactly sure why that is.... but nonetheless I see how it works now... very clever... now the real problem is going to be getting the users...

ok... I now completely understand how this modules function works... though I still find it interesting that remainders of .5 are returned as 1 I am not exactly sure why that is.... but nonetheless I see how it works now... very clever... now the real problem is going to be getting the users...

holy moly.... George I am not even sure I completely understand how this even works... I can see the logic, but what is fuzzy is how this works no matter what the count grows to.... however... I plugged it in to my sql query window and bingo,.. it pulled the one record that has an odd number if...

this seems to be a great idea George.... how can I now make this query tell me all the files that have an odd number of entries in the child table and who that last odd entry references as the inout_person? in other words so that I can run a query to see any files that are checked out (have odd...

I follow your logic... makes very good sense... I have to run out of the office for the rest of the afternoon, but I am going to give this a run through first thing tomorrow morning.... Thanks so much for you help here George....I will get back to you tomorrow to share my results... thanks...

Thanks for the links Markros...was helpful to a degree... problem I have now is that I can pull the last (most current) date a file was checked out... however, that shows up regardless of whether or not that file has been checked in since...... not sure what I can do about that though...

Since the database is not in use yet, there is no actual data... But I can lay out the structure with some sample data very simple. main table columns = id (PK), file_number, client_name sample: 1 0001 John Smith child table columns = id (PK), filetbl_id (FK)...

I have a simple database that has 2 main tables... it is for handling the status of files (physical file folders) and there status...i.e. whether they are checked in or checked out. the main table holds the info regarding the file and the 2nd table handles the activity... i.e. activity (checked...

Thanks a lot SDPT... This looks promising.... I will have to try it out, but it looks like a good solution.... Thanks for your help.... - Matthew Montalto

I'm sorry... maybe it's just me, but I don't seem to understand what your response is saying here. - Matthew Montalto

I have a user who opens two copies of powerpoint and if he goes into copy #1 and "selects all" from a slide, and tries to paste into copy #2, all the formatting is lost and not carried over. (i.e. font type/size, etc) Can anyone tell me why and what to do about it. He is using XP Pro and MS...

Could someone tell me where Hotsync Manager stores the information that says what to do with each conduit (i.e. desktop overwrite handheld, vice-versa, or syncronize)? Basically I need a way to change this for a user from 'behind the scences' so that I dont have to work from their desktop...

Will running BES 4.0 enable me to push a specific application out to the handhelds wirelessly? - Matthew Montalto

It has been brought to my attention that a particular company i know is shipping Blackberry units to their customers and asserting that when the customer's get them, they will set them up remotely. Could someone inform me as to how the can do this as i am interested in being able to do this...

I already tried spyware removers bacster... - Matthew Montalto

I have a number of pc's on a corp network and it seems that the same certain sites cannot be browsed to (i.e. msn.com, google.com, ...) Instead of returning the content from these sites, the browser gets redirected to a site called "freeserver.com" - The same exact problem is occuring across...

Have Act 2005 and would like to run it from our own sql server. Tech support tells me that I have to install act on the server where the Act database will reside. Anyone have any information about this? I have 2 act users and really dont want to have to put this on the server if it is not...

Thanks... I dont think it is the AV, as all the users use the same one and the engines are all the same. Waiting for user to finish doing whatever he is doing before i can attempt repair again. Thanks. - Matthew Montalto