exactly, thankyou my bro! ... From: Bill <graphix.guy71@...> To: ms_access@yahoogroups.com Sent: Saturday, April 26, 2008 1:45:30 Subject: [ms_access]...
I am a newbie, working with a non-profit organization. They publish a newsletter,I believe it is either MS Word or Publisher. The email address are in an...
Hello All I have a query I run to tell me when expiry dates for records fall within 90 days of todays date I use this expression in my expiry date column...
In the first Form place a Button (Go, Next, OK, Proceed whatever) and in its event procedure: DoCmd.OpenForm "SecondForm" for transfering control to your...
Kindly check the following links that I hope are of help to you: http://support.microsoft.com/?kbid=210100 http://support.microsoft.com/?kbid=263021 ...
Just to add to what m_saleem_khan said below, you may need to add a criteria to the statement that opens the second form like: DoCmd.OpenForm "SecondForm", , ,...
Thank your Mr.Saleem, I've manage to have it printed. The only problem now is that the printed result overlaps the other printed fields where as I've set the...
In need of assistance here again, I've created navigation buttons that enables the program to display the next or previous record. I have also managed to...
Hello, How do I display a value from the dropwdown list to a text box in the form? If I immediately display the value of the dropdown list in the textbox, it...
Not sure what event you are going to use to get the value in there and it also sounds like you have two columns on your drop down. In the After Update of the...
I have two tables: One contains all the fields I need to create a report, except that I'm using an ID number for employees that are listed under 5 fields (A1, ...
Hello, Has anyone used an user defined function in Access 2007 as a calculated expression? When I do I get an error message stating that the Undefined Function...
I am self teaching Access by reading, tutorials, and asking ?'s. I have never worked with it before much less set up a data base. I am doing pretty well, but...
What is it that you want to achieve with Access? More information is needed for us to guide you and we are ready to assist you. Regards Liveson ... From:...
Well I am not sure either what is it that you are looking for. However, I am appending below some links that I hope will get you started. Kindly note that some...
I have MS Access 2003. When I open my database and try to create a report it does nothing when I click on "Create report in Design View". When I click on...
Quick question is there a simple expression I can use to tell if a date is 5 years old i.e. I have a date field when a qualification was attained but want to...
But beware! The DateDiff function works on integer years. It doesn't round to the nearest year. So, if you ask it to give the number of years between...
I wrote it like this as criteria in my query for example if I wanted to know if it was expiring within a year with a 30 day advance warning now ... it seems to...
Our workplace went from Access 2003 to Access 2007, now my page footer sum modules on my reports do not seem to work anymore. Is there a better way to do...
FOund the solution myself. Looks like Macros were disabled on the options menu. Once that was removed, modules work properly. Passing info along to anyone...
Hello, Does anybody have idea on how to set a column value to Now and move back 60 days. Eg I want the rows values as 05/13/2008, 05/12/2008, 05/11/2008... ...
Hi, I've been an Access developer for a few years and I've been able to create some nice databases. But now I need to move that skill-set to a web-based...