Search results

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

To be honest either or would be the ideal solution. Ultimately I would be looking to output it to a report. Storage as a bitmap longterm would be useful also. Just had a look at the image you have produced and it seems to have done the trick. Can you explain how you reached the desired result?

Hi I am not sure if anybody will be able to help on this one but I am hoping so as its been driving me nuts for weeks :confused: I have an image, specifically a signature, stored in my database as a hexadecimal string. The coordinates are represented in 4 character groups, 2 bytes for the...

Well I thought it was but now I'm not too sure. Its all a bit complicated really. The full story is: I have built a comms network for communicating data from PDA's over the GPRS network. The data is to be written into an AS400 back office machine. All the data connections work correctly and...

Hi Can anybody offer any assistance as to how I convert long binary data into a bitmap file thanks

Thank for the help DK!!! I was trying to update the pricing on all the records using values stored in a linked excel sheet. Initially it wouldn't work using the method suggested. Something about the expression not being able to update values in an unupdateable field. i imported the excel...