-
Conversion from FileMaker Pro to Microsoft Access database
How do you convert FileMaker Pro 7 database to an Access 2007 database file?
Last updated: -
Microsoft Access: ACCDE and ACCDB
what does the word ACCDE and ACCDB stand for?
Last updated: -
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...
Last updated: -
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?
Last updated: -
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...
Last updated: -
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...
Last updated: -
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?
Last updated: -
Modify Access 2007 report printing
I want to close up blank lines in reports caused by null fields. How can I do that?
Last updated: -
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...
Last updated: -
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?
Last updated: -
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.
Last updated: -
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...
Last updated: -
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.
Last updated: -
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...
Last updated: -
How do I delete a database from Access 2007?
Last updated: -
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...
Last updated: -
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...
Last updated: -
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...
Last updated: -
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.
Last updated: -
Access database table linked to Excel file question
Can multiple instances of the same access database be open when linked to same excel file?
Last updated: