|
Change Limit to List to "No"
I need to change the look-up field in a form to "LimitToList" to "No", but I
keep getting the message:
"Microsoft Office Access can't set the Limit to List Property to No right now.
The first visible column, whcih is determined by the column widths property,
isn't equal to the bound column. Adjust the column widths property first,
and then set the LimitToList property."
I have tried to ...
|
4 |
11/10/2008 3:26:11 AM |
|
|
Combining an Autonumber field & a Text field
I have a table where I need to combine a auto-number field and a text field
to creat a new field which can be either a number or text.
Any suggestions on how to do this
Thanks
Michael...
|
2 |
11/10/2008 2:17:35 AM |
|
|
Is it possible to start again with old data?
I have built a tool inventory database in access 2007.
I admit I dind't plan it very well, as I just built tables for each type
of tool we use; 9 in total, with no actual relation between any of them.
The fields for each consist of:
Manufacturer
Product
Range or Drive (Tool type dependant)
Increment (again same as above)
ManufactureSerialNo
OtherSerialNo
AssetNo
LastTestDate
Ne...
|
2 |
11/9/2008 1:39:18 AM |
|
|
Relationship for Market at Customer-Product Level
I am creating a database that among others it has these tables:
Product (Primary Key ProductID, Product Description)
Customer (Primary Key CustomerID, Customer Description)
Forecast (Primary Key FcstKgID, CustomerID, ProductID, KG, Date)
I want to be able to produce forecast at market level, the market is defined
at customer-product level, my questions are:
1. Should I create a table ...
|
5 |
11/7/2008 10:46:09 PM |
|
|
Automatic Hyperlink Text
Hi,
I have a table that's currently 604 records and will be a lot more shortly.
It is a document center with links to the document. Of course, each document
has it's own hyperlink, but every record only says one thing: "Click Here".
I have dragged the links over (604 times) but I hate the idea of having to
change each hyperlink's text to "Click Here".
I was hoping I could do som...
|
5 |
11/7/2008 5:45:01 PM |
|
|
Minor changes result in much larger file size
To modify and further develop my database safely, I first copied it to
another folder. After making various minor changes and general cleaning up,
the 14.2 mb file has grown to 20.9 mb. The number of records has not
changed. What could possibly account for this gross increase in file size?...
|
5 |
11/7/2008 5:36:55 PM |
|
|
how to design to input info
Need a db where i can have many businesses and each business has many
employees. These business have their employees come to my seminar.
I want to be able to create a form for the seminar call "SeeYouTomorrow"
and then from that form choose the business that will attend the seminar
called "SeeYouTomorrow" and from their choose a few employees from only that
business that will attend the ...
|
2 |
11/7/2008 5:07:59 PM |
|
|
database design help
We oversee fifty six subgroups and generate a report on each group using data
we receive on a monthly and quarterly basis. Each report has 23 categories,
two per staffer, and the reports are provided to management on demand.
Currently we are using one excel workbook per group, and the data is a
mixture of text and numbers. File sharing hasn't worked well for our senior
staffers who w...
|
2 |
11/7/2008 1:35:02 PM |
|
|
msAccess capacity
I'm intent on using access to manage inventory, trouble tickets, contacts,
and events for a company with 500 users.
Am I asking too much of Access? There will only be about 5 to 10 techs
making entries and I expect to switch to SQL once I have a feel for it but
right now Access is enough of a challenge.
Assuming we have about 50 new records each week - is this practical? ...
|
3 |
11/7/2008 7:33:00 AM |
|
|
I need a template to kepp track of all my Personal bills.
Anyone has a template for keeping track of Personal Bills.
Utility
Credit Cards
Rent
Etc......
|
3 |
11/6/2008 9:30:06 PM |
|
|
I can't see a New Table I added To The Back End
Hi,
I have a database I split and I added a new table to the backend but I
can't see it. How do I add a link to that table in the front end?
Thanks.....
|
4 |
11/6/2008 9:05:56 PM |
|
|
SharePoint Person/Group fields and Access 2003
In a SharePoint list, I have defined a field as "Person or Group" and the
"Choose From" option is "All Users".
When a selection is made in this field, the name displays as expected in the
SharePoint list. However, when Access links to the SharePoint list, it sees
this field as a number rather than text.
Does anyone know how to explain this and how to work around it?
Thanks....
|
2 |
11/6/2008 8:37:01 PM |
|
|
Relationships
I am creating a DB for a recruitment agency, so it will hold all our clients
records and all the candidates that have worked for them.
I have a Clients form which combines fields from 2 tables Clients tbl and
Candidates tbl as a subform on the second page (tab control). When I go to
complete the second page of the form, I get an error message saying basically
I need to complete the infor...
|
4 |
11/6/2008 8:16:25 PM |
|
|
RunSql with " ' " in it...
Hello -
I'm Trying to run an sql statement that I'm creating in the VB code.
DoCmd.RunSQL sSQLforUpdate
The code is creating an update query ("sSQLforUpdate") that update table 1
from the current form (that bounded to table 2).
It is working ok, up until there is a special char such as " ' " in the
string that need to be updated (sSQLforUpdate).
For example:
The word "Hello" will be u...
|
6 |
11/6/2008 6:26:06 PM |
|
|
Lookup function for closing price stocks
Hi there,
I upload on my table a data text file containing a list of stocks everyday.
with the following column headings: Ticket, high, low, close.
I would like to find a way to create another table containing the previous
closing date. Therefore the column headings would be; Ticket, previous$,
high, low, close, gain/loss.
Some days a stock might no be trading for 3 days and also s...
|
5 |
11/6/2008 4:11:01 PM |
|
|
Getting a calculation in a form to update a table
Hi I have recently set up a new database but what I need it to do is a simple
calculation in a form, that will automatically update a table but when i set
it up, the form carried out the calculation fine, but it did not enter the
outcome of the calculation in the table. I am clearly doing somehting wrong
i just can't figure out what it is. The table is call Table 1 and the
formula for...
|
4 |
11/6/2008 2:37:01 PM |
|
|
three combo boxes
I am in a process of developing a database, but I need to ask many questions
before I get started and then find out that certain functions won't work will
be frustrating so here goes my question. Let's say I have a Form that is
consisted of many combo boxes and I want particulary 3 combos to synchronize.
For example, I have set up three tables (tblBeginningStatus, tblGrade, and
tblSeco...
|
2 |
11/6/2008 12:24:28 PM |
|
|
Need Design Help for payroll tracker for about 150 employees
Hi there,
I have been self teaching myself Access for the last 5 years. I have been
good except that I have to rebuild my Access 2003 database each year. I have
try clearing the data and copy to a new file name, but each year something
happens. I would like to design it correctly and be able to have multi year
data in the system.
Here is the design:
We have employees about 150 pe...
|
2 |
11/6/2008 1:58:00 AM |
|
|
Unable to create relationship
I am trying to create a relationship between two tables with referential
integrity. I'm trying to link on the following fields:
[ContractorLaborCategories].[CSCLabCatCode]
[Employees].[LabCat]
When I try to create, I get an error message that says "Data in the table
'Employees' violates referential integrity rules.
YET, when I create an unmatched query, I cannot find the offending
...
|
6 |
11/5/2008 11:13:01 PM |
|
|
Import as substitute for Compact/Repair
I have a large db in production for a couple years. I recently converted it
to A2007, and the app keeps getting "out of memory" errors. I'd guess there
is corruption. No other evidence of it so far. I do get errors from time to
time due to an issue with Citrix and Remote Desktop (clipboard sync
problems...), but I'm getting far more errors now than before...so,
I thought I'd create a ne...
|
3 |
11/5/2008 10:08:01 PM |
|
|
Database Design question
I am designing a custom database for tracking various pieces of software we
use at my job. Each user has access to different pieces of software and many
pieces of software require a separate username and password for each user.
I'm trying to figure out the easiest/best way to do this. I'm using our and
Employee table with EmployeeID as the PK and the EmployeeID FK in the
Software table. ...
|
4 |
11/5/2008 10:00:05 PM |
|
|
Can't join
I have an A2007 backend db (recently converted from A2003) with a new simple
tables. tblWOTasks is a list of tasks needed to be completed on a work order.
Only a few fields:
ID Primary Key
WorkOrderID Lookup item linked to Work Order table by its primary key
TaskDescription Description of a task
TargetHours Goal of hours to be worked on that task
TargetC...
|
4 |
11/5/2008 9:13:01 PM |
|
|
Setting up Survey Database
I am trying to create something of a survey database. I have seen the sample
database "At Your Survey", but I am not sure how to tweak it to what I need.
I have a form that is for safety observations. Supervisors will observe
procedures and mark them as "safe" or "at-risk". I have a list of things they
can observe but they don't necessarily have to observe everything on the
list. For exa...
|
6 |
11/5/2008 8:20:01 PM |
|
|
Form Queries
Hi,
If I have a form showing results of a query how can I get them to
automatically rerun/refresh the query each time that I open or close the form
to give up to date data?...
|
2 |
11/5/2008 12:36:34 PM |
|
|
access 2007 database
Can anyone advise me how to create a search field to open first and find
specific record to then open...
|
2 |
11/5/2008 4:52:23 AM |