Recent content by Big_Si

  1. B

    Run Time Error 6 Overflow

    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!!
  2. B

    Run Time Error 6 Overflow

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

    Another Progress Bar

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

    Another Progress Bar

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

    Delete Query Help??

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

    Append Query Error Message

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

    Append Query Error Message

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

    Adding a Count to a Query

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

    Adding a Count to a Query

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

    Adding a Count to a Query

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

    Adding a Count to a Query

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

    Schedule Planner...How to?

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

    Hexadecimal String to Image

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

    Hexadecimal String to Image

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

    Long Binary Data to Image

    Sorry about the confusion guys
Back
Top Bottom