Recent content by Big_Si

Thanks Guys!!! Will have a read up for future reference but the change Bob mentioned seemed to do the trick for the here and now. Thanks again!!

Hi All I am having problems with a module I created some time back. The script is used to calculate the number of working minutes between two dates and times. For the most part it works as it should however when the two times and dates seem to be more than a few months apart I get the error...

Well atleast it has answered the question. Thanks for the quick relpy Mr B.

Hi Yes its yet another question about how to get a progress bar working correctly. I have been looking arround the forum for some time and am struggling to decide if what I am after is even possible. When the database is opened a query run to find new records updated since the last time it...

Is there a way of configuring a delete query to remove records from a seperate database to the one which is running the query? I was thinking something similar to the method used when appending new records to an external database but so far can't seem to see any options to allow for this...

How do I get the wizard to check against entries in the external DB? It only seems to give me the options against Local tables and queries. I already perform the check for unmatched data locally but the problem occurs when it writes the records out to the external DB. Below is the SQL...

Hi All I have recently contructed an Access DB which is used to search for new records over an ODBC connection on our AS400. When it finds new entries it then appends them to a second Access DB at regular intervals for user input. The query works fine in so far as it appends the appropriate...

Hi All It seems that this question seems to come up a lot and for the most part remains unanswered or unclear for us less experienced developers. I have managed to coble together some code which seems to do the trick perfectly so thought I would post it should anybody else be in this situation...

Not to worry. Unfortunately this doesn't achieve the right result either. I suspect the fact that the job number is unique in each case results in 1 record also. If I take the "job" number out of the code then i get the total count of jobs allocated to each user but without the actual detail...

Cheers for the advice Alc It doesn't quite work the way I need it to. This code creates the field in the query but allocates each record in the query with a JobCount value of 1 ID Name Job JobCount 1 Simon 1 1 2 Simon 2 1 3 Simon 3 1 4 Simon 4 1 5 Simon 5 1 6 Mark 6 1 7 Mark 7 1 8 Mark 8 1 9...

Hi I collect three column of data in a table as below ID NAME JOB 1 DAVE 1 2 DAVE 2 3 JIM 3 4 JIM 4 5 SIMON 5 6 DAVE 6 I am trying to construct a query which will include a column...

Hi I have recently finished a project with a PDA application which is used to allocate work load to service engineers and collect report information. I have managed to build a reporting application to analyse this information in access but am struggling with one aspect. Its a cosmetic thing...

It appears that this solution was just the trick. Many thanks for all the help on this. Had a few issues setting it up initially but it turned out to be a glitch in the ink tool on the PDA. All resolved and works perfectly.

Here's the original C / C++ code which I was given. I was told this will perform the conversion I require. Unfortunately I have no knowledge of C or C++. Not sure if it can be reverse engineered from here

Sorry about the confusion guys