Help

Access Database Programing Questions
I am looking for a group that would help me with a few questions I have on setting up an access database. I have been pushed into using access so there are some things about it that I am still learning. specifically I am looking for a way to click on a button that will fill in a microsoft word document and fil... 20 Feb 2006 18:52

Pivot Table Help
I am attempting to learn to use pivot tables. I have noticed that if I have used the Lookup Wizard when creating my tables so allow the user to select from a list of choices when entering data, this causes a problem with the pivot tables. When I try to use a field like "Customer_Name" and drag it onto my pivot... 20 Feb 2006 09:26

Help with converting DAO to ADO
I'm looking at converting DAO to ADO in my app. All of my DAO connections are of the following structure: Dim wsName As DAO.Workspace Dim dbName As DAO.Database Dim rsName As DAO.Recordset Set wsName = DBEngine.Workspaces(0) Set dbName = wsName.OpenDatabase(CurrentProject.FullName) Set rsName = dbName.OpenR... 18 Feb 2006 23:36

database server interface
Hi, I just wanted to ask if someone can give me examples of the common database server interfaces. I am getting confused if ODBC, JDBC, OLE are some of the interfaces or if APIs are considered to be interfaces to the database servers. I appreciate all the replies I will receive from this post. Thanks. ... 9 Feb 2006 23:34

Data Access Pages
Hello, I am looking for some advice on whether to use Data Access Pages. Basically they will be used on a organization's intranet. The pages will be a simple survey, about 20-40 questions, where the users will select an answer for each question. The number of individuals answering questions is between 50 ... 4 Mar 2006 14:19

VBA collections question
Hello. If I create a collection in VBA and populate it with entries indexed by text keys, is there a way to go back and enumerate the actual key values used? For example: 'Create collection of really weak passwords, indexed by username public cPW as new collection cPW.add "dogs_name", "mark" cPW.add "daug... 9 Feb 2006 06:13

Access 2002 vs. 2003
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server 2005, and, since he already has licenses for Office Pro 2002, he wants to upgrade to that. I've been saying that w... 16 Feb 2006 17:34

You do not have exclusive access
If this message appears as soon as you try to design a form, look at the processes running. I found ADPPROXY.EXE and a search revealed this file in an Adobe folder to do with Photoshop Album starter edition. Others have mentioned Adobe in this context, so I uninstalled the program - I was not using it anyway - and... 6 Feb 2006 05:42

Lost and Found Database
Has anyone come across a Lost and Found database to track a hotel's lost and found items? I would be curious to review a system of such. I've created one myself and have a question regarding design. A lost and found record can have two different contact types. One is the reporting person and the second is t... 2 Feb 2006 18:44

How to ensure accurate mileage expense calculations??
Hello, I have read about currency calculations, etc. in this newsgroup, and I understand that currency math will be sufficiently accurate for what I need to do for a mileage/expense report. Where I'm stuck is what data type etc. I should use for the mileage distance number -- single?? decimal?? for the amount ... 30 Jan 2006 09:10