Search results

Im a real novice at Access, so i do not know if this is the standard or most easiest way to do it, but i usually put: If DCount("*", "Query name") = 0 Then MsgBox "No Records Found", vbInformation End If HTH

Well as i have said it wasn't my database, i was just told to look after it and solve any problems which may occur. The main reason for the input maski think, was because i work in a fuels company, with 14 different nationalities working here, they would all be entering dates in different...

Thanks for the reply, although i have tried that and thy are set to: English (United Kingdom) as i want. The strange thing is that they have been able to enter the dates before and have had no problems and its only a few people who are having this problem too.

Hi, I have a slight problem with the some of the dates on my forms. All of my date fields are set with the input mask: 99/99/00;0;_ and are in the format of 'short date'. Some users have found that once they have entered a date, the date mixes up, for example when 31/03/06 is entered it...

ok i will, thanks for your advice :D

Hi all, I have a wizard made delete record button on my form and up until today it worked fine. Now when clicked an error message comes up saying: cant find the field 'forms' referred to in your expression. I have no field 'form' in any of the tables or queries relating to this form, in any...

:) thats great, thank you for your help

Hi all, when the users are saving the form, i want to make sure they have filled in certain fields. On previous forms my code has worked, but for some reason on this form it won't, i usually put: If tankID = "" Then MsgBox ("Please Enter the Tank ID") tankID.SetFocus End If Can anyone...

I have sorted it now, thanks for your help FoFa :)

The data type is number, thats what i can't understand, i thought it would work using < and > but it doesn't

Hi all, This is just a quick question, for one of my fields the users enter a number, this could me a minus or positive number. I have been asked to produce a report which shows the total of the minus number and the total of the positives. I have set up a query for the minus number and have...

Thanks for your reply, no there isnt an audit trail currently in place. I didn't think i could do it the way it was, it just didn't seem to be logical, thanks again :)

Hi all, Im just wondering about a date stamp which is in one of my queries. The database which i am working on is for a fuels company, one of the tables they have is a runout table, obviously for when fuel runs out at a station and also contains sales history. They have used a date stamp, so...

Where can i find the name of the control, i am using the name of the text box currently

Hi all, I just have a little question which i can hope someone can help me with. I have a form where the user selcts from a combo box a shop name, i have then a text box which the user types in a number. This number is to show all of the shops which have had a profit greater than the value...

Hi, I have a small problem with a cross tab query. The query works perfectly when i run it and displays the data in the way i would like it to, i want it to be on a form though and when i try and do this i get problems. I get either a message saying i have possibly chosen a query with no...

Hi all, at the moment all of my field are control sourced. I heard there is a way whereby the field could be unbound and one button it the control source for them all. Im not entirely sure what this means or how to go about it. But i think it would solve the problem of if my users start...

hi, i have a form which shows all of the transaction that have happened in the business, a field in the form is 'logged by'. The 'logged by' field records the name of the person who completed the transaction. For monitoring the employees performance i have created a query which shows all of the...

Thank you very much :)

Hi i have designed a database where the users use a combo box to find a particular code they want..for example dog_brown or dog_grey, on the report which i have produced this code for the type of dog shows up to. I have another table which has a column with the code and also the...