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'm working on a large project for my emplyoer. We now have enough data that we are worried that someone could open up the database and accidentally delete things etc.
What are my options f...
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 need to create an MS Access Database that collects information from employees mid-way through a long-term assignment at an offsite location. I need to track the following information and all...
Hi
I have a split Access database. On opening the databse (not sure where to find this event) I want to
check if a table tbl_A exists and then if not create the table using SQL code, run b...
Currently there is a Microsoft Access Database containing thousands of customer records, details such as emails, address, phone numbers and more. There are many linked tables, and the data is ...
I have developed some MS Access dbs using version 2002 and want to test them in the 2007 runtime enviornment.
If I right click the db icon and choose 'Open with' and then click on the 2007 ...
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...
Is there a VBA way to change the users monitor resolution in an unpon open event proceedure?
I have developed an application in MS Access. It resides on a shared network drive. It appears tha...
Converting ADP format from Access 2002-2003 to Access 2007
I'm running a test instance of Office 2007 to work out compatibility issues. The project opens fine, however, the ability to conve...
I'm trying to use user-level security in an MS Access 2003 database to disallow access to some forms (this I can do without much trouble), and allow read-only access to others so that the user...
Hi
I've imported a table from excel to access.
the dates field was imported to a text field (because there were multiple date formats including text in this field)
the problem is that t...
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 Experts,
I am trying to design a jewellery making database in access. I have certain components that I buy from various different suppliers. I'd like to have an individual record for the...
I am trying to add a registry key using Access package solution wizard see this question for background.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Architecture-De...
Hello, I'm still a rookie to MS Access, using version 2003, and would like some help/input on determining table relationships for a few examples. I do have one other post at the MS forums in t...
I have a replicated database that I need to make design changes to. I've opened a new, blank database and want to import the objects from the design master so I can redesign and test changes ...
We have an Access database written using Access 2000 then modified in Access 2003. The users are now using Access 2007 and we set up the trusted locations and all seemed fine for a week. Then ...
Found part of my answer in the following answered question:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23333891.html?sfQueryTermInfo=1+2007+access+secur
It says to o...
I recently developed an Access database at my company with Access 2007. Developing the database and all of the forms, etc was problem free until I split my database. Since that point, problems...
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 ...
Please offer alternate methods that may accomplish the same thing if needed
I have two tables with a table structure as follows
Table Name = ITEMS
item code
item description
item...
I am working on a project to convert all of our Access 97 database to Access 2007 with a backend of SQL 2005. The Access 97 databases are secured with a System.MDA workgroup file and need to ...
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 ...
Hello Experts,
I am working on an assignment for school, which is actually completed, but the instructor left me with some "thoughts for the future", that I don't quite understand. My table...
