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...
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 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 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...
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. :(
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 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 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:
------------
...
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 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...
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...
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. ...
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 am planning on creating a database for our inventory. We have parts that have several variations. Ex. SP =1.00
CY = 1.00
SP =1.00
CY = 1.25
SP =1.00
CY = 1.50
SP =1.00
CY = 1.75
...
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 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'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 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 ...
I have a Microsoft Access 2003 database that was created so management can track when they received/reviewed reports created by their subordinates.
On a master form, there's a unique comman...
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'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...
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 ...
