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..?
Answer Question
| August 29, 2008 2:26 PM
Access Database, Microsoft Access, SQL, SQL Server 2000
I have a database that is in Access, Does anyone know if it is possible to query this DB using SQL server 2000..?
Answer Question
| August 29, 2008 2:26 PM
Access Database, Microsoft Access, SQL, SQL Server 2000
MS Access Forms
I created a database in MS Access with 2 simple tables and 2 or 3 related queries. I also created a form which I use for data entry. I based the form on a query that uses two tables (related by one field) and an additional column for an age calculation. I was happily entering [...]
Answer Question
| August 12, 2008 8:20 PM
Access forms, Database programming, Microsoft Access
I created a database in MS Access with 2 simple tables and 2 or 3 related queries. I also created a form which I use for data entry. I based the form on a query that uses two tables (related by one field) and an additional column for an age calculation. I was happily entering [...]
Answer Question
| August 12, 2008 8:20 PM
Access forms, Database programming, Microsoft Access
Access mailbox through the file system?
We are running Exchange 2003 Server Enterprise with SP2, on Windows 2003 SP1. We have a user who wants to make a connection to an Exchange mailbox folder from an MS Access database. I know that Exchange 2000 used to have the M: drive for file system access, but that no longer exists in Exchange [...]
Answer Question
| November 1, 2008 5:44 PM
Exchange 2003, Exchange mailbox management, Microsoft Access, ODBC, Outlook 2003, Windows Server 2003
We are running Exchange 2003 Server Enterprise with SP2, on Windows 2003 SP1. We have a user who wants to make a connection to an Exchange mailbox folder from an MS Access database. I know that Exchange 2000 used to have the M: drive for file system access, but that no longer exists in Exchange [...]
Answer Question
| November 1, 2008 5:44 PM
Exchange 2003, Exchange mailbox management, Microsoft Access, ODBC, Outlook 2003, Windows Server 2003
Can’t change Navigation Button Caption for subform
I’m following the instructions in the New Perspectives Comprehensive Access 2007 and can’t seem to get the Navigation Button caption to appear in the window when I use the Form selector and select the subform. Any ideas?
Answer Question
| July 31, 2010 6:16 PM
Access 2007, Access forms, Microsoft Access
I’m following the instructions in the New Perspectives Comprehensive Access 2007 and can’t seem to get the Navigation Button caption to appear in the window when I use the Form selector and select the subform. Any ideas?
Answer Question
| July 31, 2010 6:16 PM
Access 2007, Access forms, Microsoft Access
Problem deleting an object(form) in Access 2000
When I try to delete a form that is visible in the object list a message ‘could not find the object’ is being returned. I have tried compact/repair and decompile on the database to no avail. Any ideas….
Answer Question
| August 22, 2008 9:40 AM
Access 2000, Database programming, Microsoft Access
When I try to delete a form that is visible in the object list a message ‘could not find the object’ is being returned. I have tried compact/repair and decompile on the database to no avail. Any ideas….
Answer Question
| August 22, 2008 9:40 AM
Access 2000, Database programming, Microsoft Access
Date Ranges in Access 2000
How do I show multiple date ranges in Access 2000. I need to see counts of items that are 0 to 15 days old, 16 to 30 days old and so on, on my reports?
Answer Question
| August 8, 2008 7:31 PM
Access 2000, Microsoft Access
How do I show multiple date ranges in Access 2000. I need to see counts of items that are 0 to 15 days old, 16 to 30 days old and so on, on my reports?
Answer Question
| August 8, 2008 7:31 PM
Access 2000, Microsoft Access
database form
I used microsoft access 2003 to create a simple database to track asset destruction. I would like to create either an application or a web based form that will allow my employees to fill out, submit, and update the database without having to manually update it. What is the easiest way I can go about [...]
Answer Question
| August 8, 2008 1:41 PM
Access 2003, Microsoft Access
I used microsoft access 2003 to create a simple database to track asset destruction. I would like to create either an application or a web based form that will allow my employees to fill out, submit, and update the database without having to manually update it. What is the easiest way I can go about [...]
Answer Question
| August 8, 2008 1:41 PM
Access 2003, Microsoft Access
Highlight Keywords in Access 2003 Forms
I have a searchable form in Access 2003. Users can type in a keyword or phrase to filter records. Is there a way of highlighting the keyword or phrase used in the set of filtered records?
Answer Question
| August 7, 2008 1:20 AM
Access 2003, Database programming, Microsoft Access
I have a searchable form in Access 2003. Users can type in a keyword or phrase to filter records. Is there a way of highlighting the keyword or phrase used in the set of filtered records?
Answer Question
| August 7, 2008 1:20 AM
Access 2003, Database programming, Microsoft Access
Importing from an excel worksheet to access form
I have set up my database in access including the form that I want to import my information into, however when I try to import from an excel worksheet into access, it changes all my field names to field 1,2,3 etc. Then when I look at the form page all my sections have the word [...]
Answer Question
| August 2, 2008 5:36 PM
Import external data, Microsoft Access, Microsoft Excel
I have set up my database in access including the form that I want to import my information into, however when I try to import from an excel worksheet into access, it changes all my field names to field 1,2,3 etc. Then when I look at the form page all my sections have the word [...]
Answer Question
| August 2, 2008 5:36 PM
Import external data, Microsoft Access, Microsoft Excel
send data from sqlserver to ms access
i am a biginner to vb.net and i want to transfer my data in sqlserver to ms access.please anyone can help me to this regard .
Answer Question
| August 1, 2008 1:48 PM
Data transfer, Microsoft Access, SQL Server migration, VB.NET
i am a biginner to vb.net and i want to transfer my data in sqlserver to ms access.please anyone can help me to this regard .
Answer Question
| August 1, 2008 1:48 PM
Data transfer, Microsoft Access, SQL Server migration, VB.NET
VBA-question
How do I transfer 30 text files at a time into my access DB? I was able to get the files, but it did not transfer into the database. Thanks.
Answer Question
| August 1, 2008 3:11 PM
Database programming, Microsoft Access, VBA, Visual Basic for Applications
How do I transfer 30 text files at a time into my access DB? I was able to get the files, but it did not transfer into the database. Thanks.
Answer Question
| August 1, 2008 3:11 PM
Database programming, Microsoft Access, VBA, Visual Basic for Applications
MS Access DB – Query
I have an Access database this is in place for in person registration at a convention. The registration system uses a few data fields then prints a report. I can’t get the report to work the way that i want it to. I need the report to pull the record that i just entered via [...]
Answer Question
| August 5, 2008 6:23 PM
Access 2003, Microsoft Access, Query
I have an Access database this is in place for in person registration at a convention. The registration system uses a few data fields then prints a report. I can’t get the report to work the way that i want it to. I need the report to pull the record that i just entered via [...]
Answer Question
| August 5, 2008 6:23 PM
Access 2003, Microsoft Access, Query
Error 2501
While navigating my database I have a button that will take you to a different form using parameters. It works when you either simply click ok or type in a parameter, but when you click cancel it returns an error 2501. What code should i put in to VBA to make it simply close the [...]
Answer Question
| July 30, 2008 1:38 PM
Access errors, Error 2501, Microsoft Access, VBA
While navigating my database I have a button that will take you to a different form using parameters. It works when you either simply click ok or type in a parameter, but when you click cancel it returns an error 2501. What code should i put in to VBA to make it simply close the [...]
Answer Question
| July 30, 2008 1:38 PM
Access errors, Error 2501, Microsoft Access, VBA
Highlight Query last executed
How do you modify Access 2007 access options to keep last query executed highlighted?
Answer Question
| July 29, 2008 8:36 PM
Access 2007, Microsoft Access
How do you modify Access 2007 access options to keep last query executed highlighted?
Answer Question
| July 29, 2008 8:36 PM
Access 2007, Microsoft Access
rtf text in SQl Server
We need to migrate a column of rtf-encoded text in SQL Server 2005 to a plain text field in a different table. Using Access, I can save the encoded text in a .rtf file, then open the file in Word and save it as a .txt, then read the .txt back into Access – Word [...]
Answer Question
| July 30, 2008 8:22 PM
Microsoft Access, Microsoft Word, Rich text, SQL Server 2005
We need to migrate a column of rtf-encoded text in SQL Server 2005 to a plain text field in a different table. Using Access, I can save the encoded text in a .rtf file, then open the file in Word and save it as a .txt, then read the .txt back into Access – Word [...]
Answer Question
| July 30, 2008 8:22 PM
Microsoft Access, Microsoft Word, Rich text, SQL Server 2005
Access Query Tag
Is it possible to tag an access query with keywords like you can do in other MS applications?
Answer Question
| July 29, 2008 2:50 PM
Microsoft Access, Query
Is it possible to tag an access query with keywords like you can do in other MS applications?
Answer Question
| July 29, 2008 2:50 PM
Microsoft Access, Query
Access 2003 – adding values to a specific record via a query
i have a situation where i have a table whose fields are : -Date reference: is a number which repredents a date in the Date Table (this way it is easier to manupilate dates) -value of payment: the monetary value of the payment that has to be paid at that date -Paid: here i enter [...]
Answer Question
| July 24, 2008 11:45 AM
Access 2003, Database programming, Microsoft Access
i have a situation where i have a table whose fields are : -Date reference: is a number which repredents a date in the Date Table (this way it is easier to manupilate dates) -value of payment: the monetary value of the payment that has to be paid at that date -Paid: here i enter [...]
Answer Question
| July 24, 2008 11:45 AM
Access 2003, Database programming, Microsoft Access
Access 07 Database to Import to Outlook 07
Hi there, I would like to upload the database I have in Access (07) into my Outlook (07) contacts list. However I can’t seem to find a way to do this. Can any help me? CC
Answer Question
| July 24, 2008 12:16 AM
Access 2007, Microsoft Access, Outlook, Outlook 2007, Outlook contacts, Outlook Import/Export
Hi there, I would like to upload the database I have in Access (07) into my Outlook (07) contacts list. However I can’t seem to find a way to do this. Can any help me? CC
Answer Question
| July 24, 2008 12:16 AM
Access 2007, Microsoft Access, Outlook, Outlook 2007, Outlook contacts, Outlook Import/Export
Crystal Reports 6.0 and Windows Vista
Has anyone been successful at running Crystal Reports 6.0 under Vista? I get error File could not be opened: “filename”, at file location: “filename” OK to close followed by error – RptName – Run-time error 20535: Unable to connect: incorrect session parameters or just the 20535 incorrect session parameters. I had these issues trying to [...]
Answer Question
| July 23, 2008 8:40 PM
Crystal Reports, Crystal Reports 6.0, Error 20535, Microsoft Access, Windows Vista
Has anyone been successful at running Crystal Reports 6.0 under Vista? I get error File could not be opened: “filename”, at file location: “filename” OK to close followed by error – RptName – Run-time error 20535: Unable to connect: incorrect session parameters or just the 20535 incorrect session parameters. I had these issues trying to [...]
Answer Question
| July 23, 2008 8:40 PM
Crystal Reports, Crystal Reports 6.0, Error 20535, Microsoft Access, Windows Vista
Report Question-Is it possible to get a “new user” report when the only date is used also for date they used services?
Is it possible to get a “new user” report when the only date is used also for date they used services? The only fields in the table are Student ID, First Name, Last Name, Date of service and hours used.
Answer Question
| July 22, 2008 7:49 PM
Access reports, Database programming, Database reporting, Microsoft Access
Is it possible to get a “new user” report when the only date is used also for date they used services? The only fields in the table are Student ID, First Name, Last Name, Date of service and hours used.
Answer Question
| July 22, 2008 7:49 PM
Access reports, Database programming, Database reporting, Microsoft Access
