Search results

Greetings to all. I encountered an interesting issue on a project today. We have an MS Access 2010 Database that uses Local Tables, External MS Access Tables, and ODBC Linked Oracle Tables (Accessed for Read Only). The unsual issue occurs with the ODBC Linked Oracle Tables. One of the more...

I have a Form to Display Projects that has a SubForm displaying Sub-Projects related to them. The main Project Form has a Combo Box which allows a user to select a ProjectID to display. The SubForm has a ProjectID Field as well. When the Project ID is selected in the Main Form, only the...

I am looking to get involved with Access User groups in the USA. I am aware of an Access User Group in New England that Pat Hartman is/was involved in, but was hoping to find something in the NJ or Eastern PA area. Going to meetings online is great, but I am still old fashioned enough to think...

Greetings to all. I have been assigned the task of supporting an Application written in Access 2003. I have made modifications to the Application for the purpose of user enhancements as well as bug fixes. The Application was never split into an FE/BE Format, and due to the fact that only...

Recently, I became involved in a project that required the Migration of an Access 2003 Database to SQL Server 2008. I tried to use the Upsize Wizard, but that left me with too many issues to contend with. I got SSMA installed and working, and the project was listed as having been migrated...

I hope the Title explains the situation appropriately. I have a problem with a data source that requires special handling. I need to import information (including user names) from another Database that is not structured like ours. I have detailed only the user name issue, and assume that other...

I want to add an Option Group to an existing Form to describe the management type for certain projects (Internal=1, External=2, Other=3). The Selected value is to be stored in a new Field of an existing Table. The new Field has been defined as type Number, and Size Integer and pre-populated...

My group is currently reaching the end of an Access 2003/SQL Server 2005 Migration Project. The original system has a standard Front End/Back End setup with about 35 Tables in the back End. The first Phase of the Project required that four of the Tables be migrated to SQL Server while the...

I have had great success using the Front End Update Tool ( basFEUpdate ) in one of my applications. When I installed it in a second application, it did not seem to work correctly. The First Application works as advertised. An update is recognized and the message is displayed A replacement...

Greetings to all, I have started a new project and encountered what appears to be a simple Query that causes MS Access 2003 to crash and restart. Any ideas as to where to look for the issue would be appreciated. The Query itself does not appear to have anything obvious wrong with it, and...

I have come across an issue where I need to have conditional Formatting of a Field based on the value of a different Field. My company produces customized animal food for our clients. When a new Formula is developed, there is a need for Verification of the Formula before it can be put into...

One of the requirements of the project that I am presently working on (MS Office 2003 Format), is to write VB Code to validate the contents of Excel Cells as they are being filled in. To fulfill this requirement, the contents of an MS Access Table are imported into a Worksheet and then used as a...

I am trying to simulate an Acccess Combo Box on an Excel Spreadsheet. The effect would be to click on a cell and have a dropdown box with a list of choices appear. The User would then select one of the available choices. I am aware of how to do this via Excel ranges (both on the same WorkSheet...

I have the need to have an Excel (2003) Spreadsheet open my Access (2003) database to locate data to display on the Spreadsheet. Below is a Function that was crafted from bits and pieces of several examples that I have found on the internet, and is intended to do just that. The Function...

I am having issues with a database that uses MS Access 2003 as its Front End, and MS SQL Server 2005 as its Back End, and because of this fact, as well as the issues below, I am not sure which of the Forums that this post best fits in: I have an issue where Compact and Repair causes errors in...

I have an SQL Server View that identifies records that are required for shipping. We are attempting to automate the UPS WorldShip Application using this View. Currently, the View identifies the correct shipping records, but the information is not correct, because UPS WorldShip Application...

I have the following command that is being used to import an Excel Spreadsheet containing Invoices into an Access Database Table called tblInvoices DoCmd.TransferSpreadsheet acImport, , "tblInvoices", strSourceInFile, True The import works fine with the exception of the Column that contains the...

I will admit up front that I should know the answer to this, but here I am anyway. I have a pricing structure that will vary according to several Combo Box choices. An Example of one of them is below. Note that a user only sees Column 1 as the column widths are set at 1.5";0". My question is...

I was completely confused as to why the producers did what I did until I read some articles related to the reason for the unexpected Plot Twist. For anyone who does not know (and has any interest), the show killed off one of its more popular supporting characters without any warning. Just...

For over a year I have been learning to use MS Access for projects at the company that I am working for. Now I am being asked to look into a new issue with MS Excel. The Nature of the Project is as follows: The initial Data Source is a Spreadsheet containing Invoice Records Each Invoice Record...