Conversion from FileMaker Pro to Microsoft Access database

How do you convert FileMaker Pro 7 database to an Access 2007 database file?

Ccardona5 pointsBadges:

Microsoft Access: ACCDE and ACCDB

what does the word ACCDE and ACCDB stand for?

Humphrey25 pointsBadges:

Issue With Buttons in Access

I'm building an Access DB and would like to have people interact with it through forms and command buttons.  Adding command buttons should be very straight forward with the wizard, and it is until I test the button - the buttons I create don't work and give me this error message: A problem...

JTB15 pointsBadges:

How to delete a database – MS Access 2007

I am using MS Access 2007 and I thought that I had managed to delete a database, but every time I open MS Access 2007 the database is still showing in the Recent Database list. Is there a way that I remove all traces of that database and stop it from showing in that list?

NLC30 pointsBadges:

How do you create an order form where you can enter multiple product line items?

I am trying to make an order form in the data base for product.  I want this form to have customer ID and Company name once on the form then numerous qty, item name, and item number lines to be able to type more then one product ordered on the same order form.  I am having quite a bit of...

PorcelainConfections10 pointsBadges:

Multiple user login in one Access 2007 database

I found a lot of answers how to make a multiuser login but when count of users is known. I want to put all my users and passwords in one table and search for them. For example (I am admin with full access. I want to add a new user and give him different access. So I'll put a new record in my...

Johnnyt05 pointsBadges:

Auto populate field in Microsoft Access

From a two column table, I want to choose from column 1 to populate one field and have the next field populated with column two. How can I do that?

centerdirector5 pointsBadges:

Modify Access 2007 report printing

I want to close up blank lines in reports caused by null fields. How can I do that?

pauldetmer5 pointsBadges:

Microsoft Access 2007: Select field with dropdown list

I have a situation like - In a form created in MS Access 2007, I want to select a field named 'service type' having dropdown list with training, consulting values. From the dropdown, if training is selected I want the form to display field name 'types of training' which is another dropdown and if...

supriyapinky5 pointsBadges:

Need project plan for Access 2007 database migration to SQL Server

Does anyone have a project plan for Access 2007 database migration to SQL Server?

Anflores5 pointsBadges:

Populate Access 2007 object in form

I am trying to populate a form object based on the value from a combo box. I have tried FindRecord and SetValue and so far nothing is working. Please help.

OhioPat5 pointsBadges:

Importing data from an Excel spreadsheet

Hello, I have a relational database that was created by a former employee. The database has old data and I need to update it with current information. I have the most recent data in an Excel spreadsheet. Questions: How can I get the new data into the database and maintain the relationships and...

Bluize20 pointsBadges:

Crystal Reports 8.5 Access 2007

When rewriting a report I get an error that the table of a 2nd datasource in the report could not be found. This happens when trying to verify the DB which I need to do since the db has changed. A field was added. Any idea what to do? Thank you in advance.

kravetzgita5 pointsBadges:

Microsoft Access Relationship/Query Question

I have a database with around 3,000,000 records organized by account number, and another database with 100,000 or so organized by the same account number. I import both these databases into Access, and link up the account numbers… I want to pull data from both databases in order to create a new...

Highamperage15 pointsBadges:

Database deletion

How do I delete a database from Access 2007?

plasma15 pointsBadges:

Converting from Access 2003 to Access 2007

Hi everyone, I have 3 desktop with Access: One have Access 2003 two of them have Access 2007. So I divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop's. Because of that difference I convert for...

BUG68235 pointsBadges:

Access 2007 database query question

I have imported a 2007 Excel spread sheet. There are mutible columns that have date information. I need two types of gueries. First query to look at one column and only list records that have todays date, previous dates and dates through 7 days in the future. the query also need to reference a 2nd...

JHartley10 pointsBadges:

Access 2007 Report displaying the content of three different fields in one box?

I am creating a report in MS Access 2007. I want to create one box that displays the content of three different fields. i.e. Salutation First Name and Last Name. I used to do this in Access 2003 this way =[Salutation] & " " & [First Name] & " " & [Last Name] but in 2007 I am getting an error. Any...

JustDave5 pointsBadges:

Importing Data GAL entries into Access 2007

Need to import outlook GAL entries into Access 2007 & have the database updated when I change a field in the GAL entry.

AGB25 pointsBadges:

Access database table linked to Excel file question

Can multiple instances of the same access database be open when linked to same excel file?

SeenFresh25 pointsBadges: