Hi,
I am using Access 2003 and my database has 1 table, 30 colums. I keep getting the error message "File sharing lock count exceeded. Increase MaxLocksPerFile registry entry" when I want to ...
I've created a form for users to Search/Edit records they create. I want to allow them to search for records using the Record ID, Sales Engineer, or Customer Name. I have the first option (ID...
I want to reset the autonumber field in a table so that the current values are replaced counting up from 1. Can this be done?
I have one table called tblGood. And it has primary column named goodId.
How should I set the primary column to be auto-increment, and the value starting from 1 in design view of table of MS...
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 just wanted to ask how I can set a default value in MS Access that is equat to another column in the same row. Also, I want to set another column's default value to be 2 higher than another...
Microsft Access 2003 Report design
I want to combine two subreports into one report. There is one subreport2 for every record in subreport1
Subreport 1 = table (5 records, ok)
page break...
I haven't touched Access in a long time and need some direction for help. I am using Access 2007. Here is what I have.
TableA: Main Information
TabelB: Multiple entries that links to Table...
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 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...
How do I hide/unhide multiple tables/forms/reports at once? Currently I have to right click>properties>then check hide. This is frustrating to do with over 300 tables/forms/reports. :(
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 -
Our company is getting a number of new machines with Access 2007. However, most of our company has Acess 2003.
Is it possible to design and build a database in 2007, bu...
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 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...
In Access 2003 I want to include a wildcard in a parameter query. So for instance, in a field called defect, some of the records show Seatbelt, and others will show Seatbelt, door and another ...
I have a quiz Q & A database (MS Access), where members can ask and answer questions and also vote on other answers and questions.
sample data and table structure / fields:
------------
...
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...
I have a DB I am importing and apparently the error I am getting is
"The number of values exceeds the column limit in Access" that is the error that I understand is my problem. Not what Acces...
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...
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...
Does anyone know why my Menu bar toolbar is missing from my database - both the file menu at top of screen and on the toolbar customize list.
I have reinstalled Access - Repaired and Healed...
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 ...
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...
Sample Project ----some one who already has Forms,Switchboard,Reoirts,Query,tables
to have a idea
