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?
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 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...
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...
Sample Project ----some one who already has Forms,Switchboard,Reoirts,Query,tables
to have a idea
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...
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...
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...
I have developed an access 2007 runtime application. I have a few fields that are OLE object fields. But when I test the application in runtime it will not allow the user to attach the docum...
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...
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 ...
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...
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'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'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...
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:
------------
...
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 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...
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 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 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,
In Access 2007 I'm trying to add values to a table field with a data type of Number, format set to standard, decimal places set to 2. No matter what i do, if I type the value into that ...
