Search results

Cheers. I have my Tab order worked out and set, so no probs there I'm kinda trying to get to grips with with the events & syntax and im experimenting with things like If Me![DateOpened] = Null Then Forms!Main!DateOpened.SetFocus but not working properly as yet

I want to force the data input to be done in a specific order(the forms tab order) I suppose the simplest way would to prevent the mouse from interacting with form completely. and force the data in-putter to rely solely on the Keyboard. (a few googles revealed no clues as to how this might be...

I fixed the problem, I dont know what it was, I had a working version mdb on my work PC. I emailed it to myself, but when i got home it didnt work on my machine at home:confused: I thought maybee it was 2003 / 2007 thing after a google or two I used the Detect and Repair tool which reset...

I think I understand what the issue is, but dont know how to fix it. If the 3DigitCode keeps returning a value of 1 then It must be reading the DateOPened field on the current form as Null, because thats the only way it could return a value of 1.

Yes I changed the field names in the DMax code syntax as well It didn't work either with my simple little 3 field DB that i did from scratch EDIT: which is why I am so confused

yes the data looks fine in the table (UK date format DD/MM/YYYY) I kind of thought it maybe that the data (when dealing with the current record) wasnn't being counted as being in the table because all the form data hadnt been entered but that wouldnt explain why after making multiple entries...

Im sure all the datatypes in the form and the table are set to shortdate

I have Main table and one form with about a dozen fields I have field which is counter of records which 'opened' on a given date The openDate is a field in the form and in the table I originally got the function to work like this Private Sub InputBY_Exit(Cancel As Integer) Me![3DigitCode] =...

Okay after a bit ( a lot actually) of trail and error I got IT Private Sub InputBY_Exit(Cancel As Integer) Me![3DigitCode] = Nz(DMax("[3DigitCode]", "[Main]", "[DateOpened] = #" & Forms!Main!DateOpened & "#"), 0) + 1 End Sub It took me a while to realise there was something not quite right...

Thanks paul, if I can get the counting bit right, then ill worry about the formatting, had a brief look at your link and will explore that content further after the weekend just a quick response when you say the criteria isn't right do you mean this bit Private Sub...

I have a simple table & form the table has a created date field (value is set by default when the record created) and Openeddate field (value is inputted as datetime) I have a Counter Field which I want to set as 3 digits so that the first record inputed which has a openeddate of say...