Search results

Thanks, that was it. God knows why it was working before but I have removed the duplicate code and all working now. Although different error but I can sort that one.

I have the function below that obtains the windows username and appends it to an SQL table via an MS Access append query along with information about the job created. This has been working for a few years now without any issues. However the application has been moved to a new database server but...

Yes apologies for not providing a clear enough example from the outset, hence edited post.

Thank you, I got there in the end :D

I've sorted it now just formatted it to #,##0 and this works perfectly. Thanks everyone for trying to help

no it does show 2,500 correctly, the issue is that I still want to display single 0 values too but when the value is just 0 it doesnt display anything just looks like an empty value.

I have a number field and that I want to display zeros on a datasheet form but also show the commas for the thousands. Eg. 2,500 I formatted the text box on the datasheet form to #,### but this doesnt show the zeros. How do I format it so that also show the zeros. row 1 value = 2,500 row 2...

Thank you so much this works perfectly. I had to make a slight adjustment to the field name OperationNo as it called OperationNumber but otherwise it works great. Here is my final code SELECT A.StockCode, A.OperationNumber, Count(B.OperationNumber) AS FinalOp FROM OperationRenumber AS A INNER...

Hi CJ_London I have tried your suggestion but I am getting an error that I dont understand. This is my SQL as my table is called OperationRenumber SELECT A.StockCode, A.OperationNumber, Count(B.OperationNo) AS FinalOp FROM OperationRenumber AS A INNER JOIN OperationRenumber AS B ON A.StockCode...

I have a table which has two fields with a stock code multiple times together with an operation number in ascending order for each of the lines. I then need to generate a new number in the 'Final Op' field incremented by 1 up to the last line for that stock code and then start again at 1 for the...

No it's just a single user app. Ive added the code and all appears to be working fine now. Many thanks much appreciated

I have an Access database that is used for comparing changes to existing sales orders from a new file which I import and then do the comparisons and mark the records accordingly in several columns in the table. I have a main form with a Datasheet sub form containing a list of the orders that...

Thanks for your post but I have managed to sort this out using the DMin function provided by 'plog'.

It was just the one table so all good there. I have been able to sort this out simply by using the DMin function that you provided. Thanks for providing such a simple solution. I hadnt heard of this one before so I have learned something new

I have a table of jobs that have a sequence of operations in the order that must be carried out. Each operation has a Y/N flag to indicate if it is completed or not. I am creating a dashboard which shows each Operation on a separate form and a list of jobs currently at that stage of operation...

Thanks Mark, I will ask the end user what resolution their TV is. I have found out that it is actually a 55" but I guess that is irrelevant now. I have learned a lot from this post so thanks to all for their suggestions.

Thanks to everyone for their input on this. It is very much appreciated. I will digest this all tomorrow and hopefully I will find a solution amongst all of this advice.

Thanks for this information. Its very useful. I have connected my Laptop to my own TV and they are identical in what it displays. However I have mocked up some forms that fill the space on my 21" monitor but when I move the application over to my laptop screen I have to scroll down and across...

I have been asked to build a dashboard to fit on a 42" TV Screen in a Warehouse. I understand that Access doesn't scale very well so just wondered if anyone has any suggestions on how I go about building this on my 21" monitor so that when I pass it over it will fill the whole 42" TV screen? I...

Just realised that I have some code running on one of the controls lost focus event and this is interfering with the after update event on the check box. If I comment out the lost focus code then all is working perfect. Just got to sort the lost focus code out :) Thanks for helping :)