Search results

Last Month shown: http://www.databasedev.co.uk/records_in_last_x_months.html

hi guys, i need to be able to sort the whole set of data from a query, by selcting a value from a combo box. i have about 900 records with 5 different status options. i found this guy on youtube: http://www.youtube.com/watch?v=khndDXtFC7I&feature=relmfu but he has an entry field, and i need...

well the issue i have, is that when i select one value from one combo box, i want only a certain set of results appear in the second combo box related to the answer in the first, which i can select. :banghead: Any ideas how i might be able to resovle this problem? [and both of the values are...

How come the homepage of the website looks so fresh and highly moddern relted to the woring eviroment: http://www.access-programmers.co.uk/ where as the forums have a more classic appeal? is it maybe possible to invsigate in a more moddern look?

How do i link an excel document in .xlsb format to a table so that i can enable aumtic update (i.e. when a new record is entered in the excel document, i see it in my table in access)? I know that there is a standart method of linking normal excel with access, but it doesn't seem to like .xlsb...

Unfortinotlythere is no validation on the form, or even in the table in use. There are also no required fields in the form =/ so what should i d next? because re-creating this form could take a while...

I have a form, and when i change a value in one of the fields, i get the following error message which is attached. This is the worst thing, as it took me for ever to get to that form, and there is zero help from MS :mad:!! Any ideas how i can save my records without the bother of access saying...

your idea didn't work on mine :(

its a good theory, exept: how do i store that in a table, and for dates such as 1st of January 2012, the number displayed is 112012, and i need the zero's to make up a number like 01012012... Any ideas on how i could solve this?

I have a lot of dates in one column (dd/mm/yy), and i somehow need to duplicte them into another column where they are shown without the date seporator (ddmmyy), so that i can use that figure in a future calculation where a veriety of fields are combined to show one unique product number. Any...

quick question: how do i then activate or asign that moduel to my wanted column in my table, so that theresults are projected and recorded in there?

Hi, I fell into the same problem, however, when I do your steps, it doesn't seem to work when i change one field within the form. however, if i was to put the code into Form_Current(), the LastUpdated field changes every time I open that form.. how can i make it, so that the LastUpdated...

Okay, so where do i put this code (function) so that i can use it? :o

How can i make a seporate column in the table to tell me what sum i entered in the other column in writing? So that for instance in one field i will enter: 122 and automatically in another field i will have: one hundred and twenty two i read that i could create a moduel, but how and where, i...

Thanks a lot pr2-eugin!! it actually worked!! :) however i do have another little problem which i will post in another thread.. Many thanks, Cos

sorry, my keyboard is like a billion years old.. i ment "is there an expresion which means: enter value?" and where and how am i to use that code which Pat Hartman provided?

is there an expresion whichmans enter value? so that i culd put that in the last part of my IIf statement?

can you plese describe how i can achive what i am trying to do by using the forms/vba as you say you are confident that there's a way which should work?:)

this is what it shows when i place it as a default value in a text datatype field... and using the "If" statement in the calculated datatype will ither give meoneresult or another, not allwing me to type anything in.. and no, i never used VBA and i have no idea what it is or how to use it =/...

I have three filds: 1 a standart entry box 2 a tick box (Yes/No data type) 3 the calculated txt box { =IIf([tick box]="Yes",[standart box],Null) } when the tick box is on "Yes", the text from 1 goes in 3, but when the tick box is not on "Yes", i.e."No", I want to be able to type...