Access Database

mixed 2000 db and 2007 mixed datepicker results

I had an old access database (2000) and ported it to access 2007 all well and good then created a new date field in my form, now i get the datepicker option for the new field but none of the old date fields. any ideas how to get access 2007 to give date picker to my old date fields, i have already...

Navigation Pane

In Access 2003, my database window showed me all my database objects. Now I have a navigation pane that I have to scroll through to locate things. Is there any way to display all the objects in my database at once?

Complex Database Issue

I'll try to be brief: I have excel files that are downloaded via ftp to a folder where I have my DB. each of the excel files is "roughly" the same headers, I want to import all of these files, filter out all but 3 columns and then filter out certain rows in each table (at minimum, 25 tables) can...

Export report into seperate Word docs

Hi, I have created a Crystal report that runs from an Access Database. The report shows details of different projects. There are around 300 projects in total, and when I am exporting these at the moment, all the details are being produced in one report. However, I want to be able to export the...

Export Attachmets

How do you export all attachments for all records from Access 2007 database?

Adding new entries to a table via a combo box in a form

I have a Database for tracking conference attendance. Because of this I want to be able to both retrieve attendees and also adding new attendees. I have a form that allows me to retrieve attendees already input into a table via a combo box, but I can't add new attendees via that same combo box. ...

How to change the location where jpg is looked for in ACCESS

I enter data for trophy fish catches into an AK. Dept of Fish and Game database. I inherited the DB. I have no IT help. All pictures were in a messy folder with the DB. I sorted the pics into sub-folders. Now the program cannot find the JPG associated with a particular entry. I assume somehwhere...

permission to open database

ACCESS 2000 which we used to write two databases. We added a new user, and correctly added the group. Then the next morning and every day since we can not gain access to the database. There are 3 user computers. 1 user reads the reinstalled ACCESS database fine, the other two can't gain...

Transferring a database from Microsoft Access to SQL Server 2000

How would I transfer a database from Microsoft Access to SQL Server 2000?

display data item which is start from Perticular leter from database table in c# .net

in c# .net (SELECT * FROM [tablename] where fristname LIKE 'k*') this query is not work with MSaccess database

Pivot Table Error Field Message

I have a pivot table in my spreadsheet that is linked to an access database. When clicking on the refresh data button at the top toolbar to refresh the data in my spreadsheet from the new data hitting the access database, I receive an error message stating "The Pivot Table field name is not valid....

Should we use Web services to develop this integrated application?

We are developing an integrated application that will incorporate excel application, access databases and pda applications using visual basic 2005. Problem is whether to use web services to develop the project. This request for help was originally submitted to the Research Assistant on WhatIs.com.

Modifying a module in Access 2007

I have a database with around 40 queries. I have a module which runs all the queries using the following (abbreviated) code: Function RunQueries() On Error GoTo RunQueries_Err DoCmd.OpenQuery "Query_1", acViewNormal, acReadOnly DoCmd.Close acQuery, "Query_1" DoCmd.OpenQuery "Query_2",...

Union Query

I 've a problem with porting my ms access database to sql server. In my inventory database, i have 4 tables: (1)Purchase, (2)Sales, (3)Quantity Adjustment, (4)Amount Adjustment. I want to calculate the stock position from those 4 tables. In access database, i do with this kind of queries : a....

How do I retrieve the most recent date from an access database

I am building a report in Access 2003 and am trying to pull data based on the most recent service call for a customer. There is typically several service call dates for each customer, but the only record I am concerned with is the most recent date.

Access databases

I have a database that is in Access, Does anyone know if it is possible to query this DB using SQL server 2000..?