(My session seems to have timed out, so I am reposting. I apologize if this is a duplicate.) I have a database I used all last year. One of the primary...

Hi, Can we set few properties (as we have NLS in Oracle) at database level in ACCESS 2003? Most important is setting a date format for the whole database...

I've been tasked to revise an existing slide show that uses Access and Powerpoint. This show is displayed weekly to a large audience and covers many...

I am having such a frustrating problem and would appreciate any advice. I have a split database and have approximately 15 front ends. All of a sudden, i am...

Hi I have an access 2000 database with some linked SQL server 2000 tables. Everytime i open the database it always asks for the SQL user and password. This...

My combo box shows fiscal month choices and autofills another field with the date the fiscal month ends. This works. But, when I make my choice, save, and...

I have a database in which I want to autonumber a Field based on the number of occurances. Say I have a database that holds calls for a client. (Table...

I want one of my forms that I'm going to be using as a switchboard to be the item that one sees upon opening the database in Access. We have another...

Hi All, I have two related tables that are updated via a form. I need an item of data in the second to be mandatory i.e.. Default Value only populates...

I am having problems linking tables in a hosted SQL 2005 database on GearHost.com. I have Vista with Access 2007. I am linking via ODBC DSN. The DSN test is...

This appears to be easy for me, but for some reason I can't get my head around it. I have a find button that I would like to give me the results for all...

I posted this in forms design and didn't have a response - I really need help. I need to create a form or report in pivot table format for data from a query...

When I query the the central project table to allow entry of multiple contact information, the query fails. I.E. The query is only successful when adding ONE...

I'm working on a very basic database design for entering data from a survey. I am used to working with numeric data in the analysis stage. How do I define a...

pl advise "how to open ppsx."

Is it possible to convert union into a new table in Access? I need it to see union's data in Excel Pivot table. Thanks a lot for your help.

Hello, I was told that in a Networked environment with multiple users to design an Access application with 2 mdb files, where 1 goes on the users HD (Client)...

If Tabe A is linked to Table B using a left outer join, everything in Table A displays on a query, even when records don't exist in Table B. So far so...

I created a chart to display monthly data. Each month has distinct data that is reflected in the cart. The chart displays the data properly, but also...