Recent content by ianward

DJKarl - fantastic - works perfectly now just as i had envisaged Many Thanks

Thanks people, will have a look at that Ian

Afternoon all, I am trying to create a very simple progress bar that just continually scrolls and resets to show something is working, I have a query that runs off sqlserver that takes around 5 mins to run and make the table, what i wanted to do was just to show that something was happening...

Hi Missinglinq, I am using Access 2003, very strange - i am not aware of any updates etc that have been applied which may cause the variation... think I may just end up putting this down as "gremlins at work" however - at least the workaround is playing ball so far... Regards - Ian

Well this has baffled me as to why it used to work on my machine but no longer does, and works fine on others... anyway as they say there is always more than one way to skin a cat, i found another piece of code for displaying usernames, which i thought i would give a try to see if i could...

Hi Missinglinq, Yes in this instance the textbox is unbound, but i also use this in an append query to append to a logon table the date/time, Username, ComputerID & DbVersion, so that i know who has used the db on which pc and which Front End version they are using, this has worked on my...

Hi all, I have on a form a text box where the Default Value =Environ("Computername"). Now this has previously worked just fine, but for some reason for the last couple of times i have gone into the form the text is displayed as "#Name?" not the computer name which is expected. ...However if...

Thanks DCrake, conflicting/ambiguous criteria... I think today is one of those days where I cant see the wood for the trees I have removed the second '<>....' and it now appears to be working as it should Thanks again - Ian

Hi all, I have been trying to adapt a piece of code I found on this forum some while ago which checks a fields value before updating to check for duplicates for both new and existing records. The first part of the code works fine for new records. It is the second part which i am struggling...

Thanks all who have contributed - I have now decided to go with the Min and Max values in a between clause and using NZ(ContractValue,0) to show zero value so all contracts are now shown. Would be interesting though to see if there is a way of passing < > = and a numeric value to a query...

Hi Mike, The SQL for the query is as follows: SELECT tbl_Contracts.ContractID, tbl_Organisations_And_Sites.[Organisation Name], tbl_ContractType.ContractType, tbl_Contracts.StartDate, Sum(tbl_ServiceLine.Activity) AS Activity, Sum(tbl_ServiceLine.ServiceValue) AS [Value] FROM...

Thanks David for the range suggestion, but we are looking really to filter contracts with a value less then or more than. Mike - the value of the textbox Me.txt_FinancialFilter is "<1000000" without the quotes. The criteria I am entering into the query is: Like...

I have a listbox which is populated by a query, however i have been asked by our Commissioning department if it would be possible to search contract values, with more than, less then etc. I added an option group to my form with the following afterupdate Select Case Me.opt_FinanceOption Case...

Hi Peter, you are more than welcome, just glad you got your problem solved - The people on this forum has saved me from baldness on several occasions when i feel like tearing my hair out. and... yes the ".Value = stWhatever" will work with text boxes, etc Regards - Ian

Hi Peter, OK think we might have the solution now - the reference would need to be in the format of: Forms![Sales]![Sbf_SalesDetails]![discount reason].Value = stDiscountReason I have attached a working sample if you do run into trouble and named the forms as you have so it should work for...