Advertisement

250 organizations, including eBay, Ericsson and Lockheed Martin, now work smarter with Corporate Accounts. Save up to 42%

 

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

 
Top Access Architecture/Design Solutions: 1 - 25 of 84
 
I have created an Microsoft Access 2003 database.  It includes Tables, Queries, Forms, Reports, and Macros.  I want to be able to give this database to a a select group of people that don't ha...
I have an MS Access program that monitors bids/quotes.  Each bid has a bid manager and a due date associated with that bid.  I run a query to determine if any bid are due within the next day. ...
I have developed an MS Access app which has been successfully implemented on several machines as a MS Access runtime 2007 .accdr install. It successfully runs on combinations of XP and Vista a...
Hello experts, For some reason I can't find ANYTHING on Google about how to build a simple asset tracking database. All my searches come up with software to purchase. I have Access 2000 and...
I'm updating a client's Access front ends programmatically to change linked tables from an insecure Access back end to a more secure MSSQL database.  The linked tables seem to be read-only, bu...
I recently migrated my Access 2003 database to 2007, and now only one person can open it at a time.  Access 2003 allowed my program to be run by several people (I don't remember the exact numb...
I have a database frontend and backend in access 2000.  The frontend uses tables from 3 other backend access databases.  I am working on delete routines for certain records. My question is ...
I have a Access 2003 database that has been steady for over 4 years now and it recently is crashing.  It is happening when working in reports in design view but not the same reports.  I have r...
Does anyone know if there is a way to email a report in the body of an email? I currently am emailing invoices to customers but they are only as attachments which can't be opened on all com...
I currently have an Access App with a Pop Up / Modal Form. Upon opening, it hides the Access DB window using the attached code... It works perfectly... except when the app is minimized, the ...
Hi, I have an Access Database built in Version 2003, stable and has been going for over 4 years.  Its a very niche database and running in quite a few companies.  I have a meeting in an hour w...
Currently, I have a Microsoft Access Database 2007.  Multiple people need to access the application at one time, but receive "Read Only" accesss.  Is there anyway to allow multiple users full ...
MS Access 2003 has a great Imprt utility for XML.   I would like to accomplish the same task programtically using C#,   I have search the Google over and never found a true solution.  Does any...
In Microsoft Access 2003, you could create a "start-up file" or autoexec batch file that set the preferences for Access itself such as: Macro Security, start-up form, etc.  I'm looking for a t...
I recently had to reinstall MS Access, and since then I have been unable to link table to Excel or import data from Excel. What am I mssing,  Do I need to load a different service Pack.  I ...
We've used access runtime in the past connected to a backend (Access then MS SQL Server) that could support multiple users. Can a single standalone runtime db on, say, a network server support...
We want to put our Access db on a network. There are only about 5 users. When the first person opens the file there is an ldb created. Is it created in the network folder or on the individua...
I have an MS Access application that I want to make available as a runtime app. I know that the VSTO has the package wizard. I can get a copy of the VSTO w/out a product key for a nominal ...
Attached is a database file by mbizup - The request was to be able to add a new record from the top as opposed the the bottom.  He did a great job with this. In short, I am trying to get th...
I have set up an access system which will take bookings for a company.  The user ideally wants to have it in a calendar style (like Outlook), so I am trying to implement a FlexGrid.  I was giv...
Hi I am a visual basic/access beginner. I have been tasked with setting up a central contacts database for a small business. We want to be able to access distribution lists based on job num...
Hi, I'm trying to create a uner menu bar for use in my Access 2007 database system i am creating, however i'm a little unsure as to how to impliment a custom ribbon.  I have sotware which a...
When access opens the Switchboard, is there a way to cover or hide the start menu bar at the bottom of the screen?  I am trying to make prevent users of the database from 1/2 entering data or ...
Hello Experts, I have a basic Access/dbase question i think..... When buliding forms for end users should I use lookup tables for the dropdown or Select queries for the dropdowns.  At fi...
Experts, I have a simple question in MS Access table. In one of the fields, we want the data type to be date/time and we want it use a look up wizard. So, first we select the data type to b...