Recent content by baz7621

Hiya How do i ask the user if they are sure they want to exit the the database when the click cmd_exit?

ok fanx thats worked a treat

Hiya all soz if this sounds stupid but I am a newbie but is it possible to break down a massive line of code into a number of lines so it can be read with ease instead of having to keep moving the scroll bar Fanx

Hiya all I have a form see image below: What i want to do is set up a If statement (maybe) to ensure that when the type of transaction is "sale" it will take the quantity of the transaction in the subform and subtract it from the total of the equipment in the main form. For example if i had...

fanx alot mate that works a treat

Hiya all I have a form and on it i have a combo box from which the user has to choose a month. The row source for the combo box is code:--------------------------------------------------------------------------------...

I am sorry but i dont know what you mean by Calendar Control :o Can you explain please i am new 2 vba

Hiya fanx so far but i see one problem: If i create a table of dates for example 2000 through to 2005 then any year after 2005 will not work. So I thought about it and came up with this but it doesnt work. What i want it to do is get the year from the system clock and the start year is 2000...

ok thats well enough 2 use an input mask but whats 2 stop the user entering 9999 0111 1900 etc as the date?

Hiya all! I have a form and I have a txtbox called txt_year. In this txt box I want the user to enter the year of the date in the format of yyyy eg.// 2004 How do I put validation on this txt box so that the value entered is in the format of yyyy?? Fanx all