I have table with 80 employees all with different locations. I would like to apply a filter when my form is opened by a user to ask "Which location would...

I have a table called MLS DATA i am trying to rank the dates in it. i just want a value 1 being the highest date and or the lowest, and so forth. Which way...

I am doing dataentry and have to repeat into each record the same date and would like the date of the record above to be repeated

I want to change my database in excell for a faster one in acess, and i don´t know how to get values from other tables or queries. Exemple: Querie 1...

Are there any particular issues with having multiple different front-ends interacting with the same back-end? I am contemplating a searching and reporting...

This question is so fundamental that Microsoft will probably draw up a court order that forbids me from coming within 10 feet of Access ever again. I feel...

Can anyone tell me if a Data Base designed in Access 2002 will run with Access 2007? It seems that the data base will load to the main menu but on selecting a...

Is it possible to take an existing access application and store it on the web and run the application. And if so what it the best way of doing that.

Hi I was wondering a easy way to this. I have a form that I need to update on a regular basis. I want to be able to open it up the form without having to...

I already have Microsoft 2003 Student Edition but I need Access 2003. Is it possible to purchase Access 2003 without buying all the software again?

Hi, Please can you help me as I have run a query on a aud table and defined it by the date and status but how do I run the query to only specify the changes...

This is a really good one...I have been trying all sorts of different combinations and I get the same result each time. NOW with this said, I did solve this...

Sorry for what might be thought of as a silly question. I have a Combo that I use as a "Find" Field. I also have a "Bound Text Box" to display the...

I have a Data Base on the main server and linked data bases on two remote machines. They all have passwords to open them. They were working fine, but all of...

I have Access 2007 - when I export a query into Excel, it will come up and ask me for the parameter values again. For example, if the query prompted me to...

I wish to be able to filter records between the dates of 01/07/2007 to 30/06/2008 this year which I have done by using the Between Dateserial(Year(Date(),07,1)...

i have created a new db with a tblMain and tblDescription. Here is how it is layed out.. tblMain ID OP LN Rig Parish Vend

Hey guys... I've created a new column in my database that reads "Year". I need to keep this populated with the current year so that I can pull yearly data...

I have a field on a report that is formatted for currency and displays zero dollars as the default. What I would like is for the field to be NOT visible if...

I have a form with lots of command buttons, 12 of which I would like to a move to a newly created form. I tried copying and pasting them but they wouldn't...