Microsoft Access

Changing field format in Access 2003

We have an Access data base that includes date of birth in the format mm/dd/yyyy. For reasons I don't need to go into now, we have to change all of them to a different format - yyyymmdd. Is there a way of doing this without changing every individual record? This would save us hours of work. Thanks

Vertical text in MS Access 2003 report

I'm trying to create report headings that are perpendicular to the data fields. I have lots of fields with numbers and the headings fit on the page if they print at a 90 angle -- on a slant would be nice too. When I make a label (or text box) and change the properties to 'Vertical = yes' the...

Pivot table error when sourcing data from Access

Pivot table error when sourcing data from Access reads: Invalid bracketing of name 'mdb.'.

Linked Server Question

I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however...

rolling average VBA code MS Access

Hi All Anyone know how to create a VBA function and or SQL statement which will work in Access to find the rolling average as per example below + see excel file for working example in excel. Should work for a unknown amount of records. Not an easy one I think :-). If it can be done without using...

Date insert problem into Access from .NET

I have a procedure that inserts a record including a date into an Access database. If the dd portion of the date can equate to a month then the dd and mm parts of the date are switched otherwise the date remains as is. eg 12/11/2007 is being stored as 11/12/2007 but 13/12/2007 is stored as...

Problem MS Queries Refresh in excel file located on client network

I am having a problem refreshing the Ms Queries in an excel file located on client network, when connected through vpn. It is showing an error window such as "ODBC Microsoft Access Driver Login Failed" Disk or network error.

Hiding the system views table from Microsoft Access

How can you hide the system views table from applications like Microsoft Access? For example, whenever I link to tables in our SQL Server database, INFORMATION_SCHEMA and sys system views are included in the list of tables. This prevents us from finding our tables immediately. How can this be done?

Access Error importing data from Lotus Notes

I have a user that is importing data from Lotus Notes into Microsoft Access and is receiving a Microsoft error. I've already verified with IBM that it is not a Lotus Notes issue in any form. Here is an explanation of the process and the error: How the process is done: Opens lotus notes does the...

Edit data in an Access Form

I have done this before, but cant get it to work in my new database. I have created a form that is based off a query in my database. I want my users to be able to type data into one of the fields on my form and the table driving the query will update with what they type. Every form I've created...

Iseries Queries.

Hello, I have a query schedule that runs Daily and looks for events for the previous day and, it's access in access database, but on Mondays I don't get anything because is set for previous day and Sat and Sunday overwrite the query so I get ZERO results. I've set for YESTERDAYX. How can I change...

Adding a password to a SQL Server 2005 database

We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

Microsoft Access 2007 Data Input & Report

I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 ** 1 I I I 2 C C 3 ...

Export Access to Outlook

Is there a simple way to export an Access Database to Outlook? There seems to be an export to Lotus 123 but not one for Outlook, am I missing something?

Look at query results & pass a value to form in ACCESS 2003

I need to be able to look at the results of a query & based on the values in one field (?) on a subform/table enter a Pass/Fail value to the main table. Here is a basic breakdown of what I have: t_Main: table defining dimensional layout requirements. There can be multiple parts of the same part...

AS400/iSeries Queries on a schedule

I have several queries that I run daily manually, I will like to know step by step how can I have my queries to run on a schedule using the SBMSCHJOB command, then I will like to export them to Excel or Access.

Crystal Reports can't connect to Access 2007

We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB's. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB's.

Access Database - Colorize one word or letter

How do I colorize one character in a field in a table? I want the letter "O" to be in red for one customer and blue for another customer in the same column but different rows.

MS Access 2003 write in SQL query to convert string to numeric

How do I write in SQL code in MS Access 2003 to create a query that converts a string into a numeric? Thanks

Microsoft Access 2007 Query/Report Calculated Fields

I have a table with customer estimates and sales. I need a report to reflect the closure rate by total number of jobs within a given section (in this example subdivided by lead source). Each job can have multiple records. I need to get the % based on grouping estimates for specific jobs. (7...