Search results

why isn't Required field working? I'm not that familiar with validation rules... One the text field it should store the persons name (whoever is entering the details) but this could be anything (john or malcome hayward) so how do I put validation in for random text entries? How do I add...

Hi all, I have split a database, then realised that I needed to change two fields in a form. Y/N field and Text field. I went into the backed database changed the fields to be Required but in the front end it doesn't seem to work? I haven't tried re-linking them but should I need to? thanks

I've sorted the part to run the query by adding the Requery in the code of the Lost Focus. All sorted...

Hi all, I've got this form working ok but need to add some extra functionality but haven't a clue how to do it! http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=10175 The uploaded database has two main forms. The first is used to enter customer data, the second runs from...

How can I move this to the Forms forum? I Don't want to double post but this is more relevant to Forms than tables...

hi this is what I use and it works to get everyone out of the db (as long as the form is open still) after a time period. http://www.rogersaccesslibrary.com/download3.asp?SampleName=LogUsersOff.mdb

sorry just noticed this is in the tables forum :-/ not sure if it's Forms or Queries?

don't know if itwill work but could you use something like OpenTable - RunCommand (Import) with a condition pointing to the file you want?

Hi all, I've got this form working ok but need to add some extra functionality but haven't a clue how to do it! The uploaded database has two main forms. The first is used to enter customer data, the second runs from a query and shows all those records that have been completed in the first...

Sweeeet! Nice one for that I like it, it works well and seems easy to modify! I'll check out Access Solutions UK as well :) much appreciated

Hi all, Is it possible to run web pages from within an Access form? I've heard there's an Active X plugin that will enable me to do this but haven't found it yet? Has anyone used this?

sorted... MaxLimit = 20000 MaxDivided: ([MaxLimit]/3) = 6666.66666666667 MaxRound: Int(([MaxDivided]/100))*100 = 6600 :-)

thanks guys, after trying the Round option it doesn't seem to give me the disired results. e.g. MaxRounded: Round([MaxDivided]-0) (If I add a number to the end other than zero, all the rounded numbers become incorrect) 20000 /3 = 6666.6666667 after Rouding and Formatting = 6,667.00...

'Microsoft Access Help' (this is the info) ------------------------------------------------ ROUNDDOWN Rounds a number down, toward 0 (zero). If this function returns the #NAME? error value, you may need to install msowcf.dll. Syntax ROUNDDOWN(number,num_digits) Number is any real number...

Hi all, I have a couple of queries where I need to round down the numbers. I thought I could use the Rounddown function but thisthrows up an error. (Undefined function 'Rounddown' in expression) Does anyone know why this error would occur (and more importantly how to get around it?) this is...

Pat, when I said there was another post, I don't mean it's the same...same problem for sure but I've been advised to do so many things that don't work, a three page thread isn't something people want to get in on. I've explained the issue in these threads so if someone does want to help the...

ah! really sorry for the multi post :o Pat the query's posted up here and in another post linked from this one, sorry I'm just keen to get this query (and the stress) over

hi ken do you have time to help me finish this query :-)

found it, I had to remove the comments round the second form part nice one data