I have created a database table with 100+ fields with data. I now need to insert an additional 33 fields that will have a static default value between 1 and 33. I have already inserted the Line # field in the table between every 6 fields and gave it a default value. I now would like the existing database to update and reflect the new changes that were made for the new inserted fields.
View RepliesI have a table called NewTransactions_tbl that I have been using for some time. I am trying to add a new field called CustomerProjectNumber. It's not being displayed when I look at the table view. I've attached an image showing the settings for the field. I am probably missing something obvious.
Any ideas why it is not showing?
I am using Access 2000.
I'm looking for a keyboard shortcut to expand the columns in "design view" of a query.
What I mean by this is rather than selecting all of the columns and double clicking to see the entire text, I'd like to be able to a shortcut.
The entire process as I see it involves 3 steps so I will need thesolution to the 3rd step.
(1) [ctrl+spacebar] to select initial column
(2) [shift+arrows] to select all of the columns I need
(3) [keyboard shortcut] will expand all of the columns "field" names to the size of the column heading
Alternatively, if you know of a shortcut that will expand the columns without having to select them first I'll take it!!
You know how normally in design view there would be a table at the bottom of the screen where you can drag your fields from the view above.
Well, I have a query where this table view has disappeared ?
I can edit the query in SQL view, the query works, just the table view is missing.
Ever happened to anyone else ? I've done the obvious and scrolled down as far as I can and nope, it's not there ??? :confused:
Greetings.
As a relative newcomer to Access, I am having trouble deciding on how to design the form flow for updating and creating related records. I'm looking for a variety of suggestions so that I can decide what's best for the user and what's best for screen flow.
Here's the structure: I have what's called "an Event". Each Event can have multiple "Trials". Each "Trial" can multiple "Classes".
(This is the structure for a dog obedience competition)
Tables:
tblEvents - PK = eventID
tblTrials - PK = trialID, FK = eventID
tblTrialClass - PK = trialclassID, FK = trialID
Currently, for "display" or "browse": I have the following form structure:
frmEvents - single form format with a subform called sfrmTrialInfo, no navigation control - entry to this frmEvents is from an unbound pop-up form that uses a combobox to select the Event for viewing.
sfrmTrialInfo - single form format with a subform called sfrmTrailClass, has navigation control so that the user can display all trials for this event
sfrmTrailClass - continuous form format with navigation control so that user can display all classes for this trial.
My dilemma is what is the best method for letting the user create a NEW Event-Trials-Class structure. Right now I have a button on that pop-up that is used to create a NEW Event. It brings up a blank frmEvent form with the blank imbedded subforms. This is still in the design stage.
I want to have control over the data (as the user is typing ... don't let the user move forward until all requisite data is entered), but I, also, want to make the process relatively pain-free for the user.
Do you have any suggestions on a design?
Thanks, in advance, for your input. :)
Regards,
SueB
While viewing the query in design view, I am unable to see the relationship tables at the top.
View 3 Replies View RelatedI have two tables in Access 2010:
Tbl1 - Abbreviations: with fields (1) "Abbreviation" and (2) "Definition"
Tbl2 - Piping: with multiple fields one of which is "Unit"
In Design View of Tbl2, I'd like to set the "Validation Rule" for the "Unit" field so that it is restricted to values in field 1 of the Abbreviations Table (i.e. one of the listed abbreviations").
I tried variations of "[Tables]![Abbreviations]![Abbreviation]" in the "Validation Rule" portion of the Design View for Tbl2 (Piping) but, couldn't get this to work.
Hi, I have a table if I do view in design view has all validations in description.I am trying to copy this to excell or word so that I can get things started.. and I just cant seem to copy that view which I see in design. I got 174 fields so its obvious I cant copy and paste 174 times...
Regards
Is it possible to print the design view of a table?? If so how do you do it?? When Im the in design view and go go to file the print button is greyed out.
Thanks in advance.
Andy
I have four tables in a single .MDB file. I need to export the contents of the Design View of each table to a text file. How do I go about doing that? I've tried the help files and Access for Dummies, but neither are giving me the info I need.
View 3 Replies View RelatedI have tables that are linked to the AS400 via a file dsn. Whenever i go to the table properties, i receive a message indicating that i may not be able to save changes, but im trying to go to the properties=>description so that i can change the description of the table, which will enable me to change the filepath of the dsn from a mapped drive to the full path of the filename. Whenever i change the description, the changes do not stick? Any solutions?::D
View 2 Replies View RelatedWhile creating table in design view is it possible to set the value of a field as sum of two other field?
for example:
I have a table with field a and b.
I want to have one move field c in the table such that c=a+b.
Please advise on the above
Thanks
Badri
can anyone explain how to use a percentage in a table.
i have a field designated as data type "number" and format set to Percentage.
when i go to datasheet view and attempt to enter in these percentage (1%,50%, 34%, etc) it is multiplying the data entered by 100 (100.00%,5000.00%,3400.00%, etc).
gotta be something easy.
TUKTUK
I have several Access DB's that I work with and all of them have a close option(x in the upper right corner) on forms/tables/queries except for one. This is one that I did not create. So, when I open a form in design view to modify it, the only way to close it is to close down the DB?
View 1 Replies View RelatedHere's a query that the bottom listview in the attached form i.e. a listview representing a table of calls(many) to fims (1 top listview)
Code:
SELECT calls.id, calls.firm_id, calls.called, calls.said, calls.spoke_to, calls.next
FROM calls
WHERE (((calls.firm_id)=[firms].[id]))
ORDER BY calls.called DESC , calls.next DESC;
When I run the thing...I get a dialog asking me for firm id.
I want to change this so when I move up and down the firms LV (top)... the bottom LV updates taking firm id from the top LV with focus.
Access 2003.
Lets say I have the follow Tables:
Code:
Outfits:
ID | Top Color ID | Bottom Color ID
1 2 1
2 3 4
Colors:
ID | Name
1 Red
2 Blue
3 Green
4 Orange
I'd like to have a query in design view to have the following result
Code:
Outfit ID | Top Color Name | Bottom Color Name
1 Blue Red
2 Green Orange
In design view, I can link "Color ID" to "Top Color ID" and "Bottom Color ID" but I don't know how to specify in the GUI to create "Top Color Name" and "Bottom Color Name".
I have a Form which I have linked correctly to a subform. The Text boxes are showing in the Design view but are not when one switches to the Form View. Labels for Fields are visible in the Form View. Have even created a new subform and that will also not display the Text Boxes.
View 1 Replies View RelatedWhy the ability to view the properties of an object within a form is not available when you double click on it in design view?
I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.
I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.
Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?
trying to create an update query to Budget table using the Access Design View:
Field: PctSls (in tblBudget) Update to: [Expense] / [Sales]. The update query always returns 0. However, if I create a Select query using the same calculation, the correct results is displayed. PctSls is defined in the Budget table.
I haven't worked with Access (2003) for several years but this seems too simple to be causing me such frustration. (Was only a casual user even then).
Anybody ever heard of this before? I open a form, and it is empty, just a blank window. I open the same form in Design View, all appears well. :mad:
View 2 Replies View RelatedI have a sub form in DataSheet view and I would like to lock the design so that the User should not change the layout
Even when I set the property of the Datasheet “Allow Design Changes: Design View Only” users are able to unhide the hidden columns and they can also change the size of the column by dragging the column end line
Does any one know how to lock the design of datasheet ( I am using this sub form datasheet for data entry but do not want users to change the layout)
Thanks
Rahul
I am wondering why the alteration to my form in design view is not reflected in the "normal" form view. I have included the two views. In design view I moved "Staff In"/"Staff ID" to the top of the form believing that as I work left to right thay would appear on the left hand side in normal view.
However, in the image of "normal" view you can see that "Staff In" is way over on the right hand side of the form.
Any ideas how I can fix this?
Thank you
http://www.btinternet.com/~peter_paterson/Access/SubFormDesign.jpg
http://www.btinternet.com/~peter_paterson/Access/SubformFormView.jpg
I am making a new Record in the design view of a table (creating a new field in the table), and I am assigning it a date type, is there a hotkey that will select the field properties sheet so that I can select the format of the field without having to move my mouse?
View 1 Replies View RelatedAfter reading many of the posts here, I decided that one of the problems with the tables in the db I was working on was in the primary keys. I had used the same field name as the primary key in all of my tables. This was RecipID, which was a user entered textbox with an example in a label beside it showing the format to use.
After reading stuff here, I decided this wasn't a good idea. So I changed RecipId to be an autonumber in the parent table (Household_Info) and a long integer foreign key in the children. Also, I added some fields to the parent table to identify the head of household (lastname, firstname)
I already had a continuous form made with a subform and a pop-up form associated with it based on my previous tables. Reran the query underlying the form, and the new fields showed up in the field list box for the form. The fields are all still present in design view, but I get a totally blank form in form view. I checked the forms recordsource and made sure that it was set to the new query.
Can anyone give me an idea about what I'm overlooking? Do I have to recreate the form?
(Sorry if this is a repeat of a question someone has already addressed, but I couldn't turn up any relevant threads after several hours of searching.)
Thanks, Charlotte
I am still new at database design, and cant quite come to terms with my project and access way of doing things.
I have to keep a register of people who participate in projects. The projects can be of two different kinds. BUT (here comes the tricky part) The projects are being evaluated on three different indicators, with each one of these having 4 measurements, in the range of 4-0. That was a quick introduction. Now let me break it down in parts.
The people:
I have made a Uniqe identifier (Social Security number (PK))
First Name
Last Name
Department (This can be 4 different departsment) made a drop-down menu type.
The Projects:
Unique identifier (Project ID (PK))
Social Security number
Project Type
Start date
End date
Project type:
Unique identifier (TypeID (PK)
Project type (Cti / Regular)
How might i design this the best way, so i can combine the people with the projects there on. And which type.
There can only be one person, but he can be on many projects. These projects can vary in type. My problem is ensuring there connected proberly.
Furthermore, once the basic design is made i need to make evaluations based on their performance if they are on the projecttype "Cti".
here i need 3 x this:
Evaluations:
Objective (range 0-4)
Baseline reading (range 0-4)
Midway reading (range 0-4)
End reading (0-4)
Success = Yes/NO (here i will do a End reading <= Objective formula).
That was a rather long list, but i have sat working on this in three whole days, and im getting a little fed up with not knowing up-and-down.
I've designed a database at work to collate information about locations around the world that are contaminated by conflict and military activities. I'm struggling with the use of the lookup wizard to populate some fields in one table from another table.The database is ultimately meant to be used to identify contaminated sites in various countries and also to be a source of data for an online interactive map. As such, it needs to hold a fair amount of information. I figured that it would be normal that some fields and tables would be connected to one another. So, for example:
Country table is looked up by the conflict table to provide the names of countries participating in a conflict. To do so I used the lookup wizard. Similarly, the Site information table is looked up by the Site contamination event table to provide the names of contaminated sites. The Site contamination event table. Then the Site assessment table looks up the Site contamination event table to provide the name of contaminated sites. The relationship between these three table is intended so that at any given site multiple instances of contamination and their subsequent assessment can be recorded. This is where I started noticing problems. When I tried to input some fields into the Site assessment table, specifically the 'Site name', it would only display the primary and foreign keys in the drop down menu but not the 'Site name'.
- Have I messed up by relying on the lookup wizard in my table design? This seems to be the consensus in this and most forums (I checked another thread in the 'Tables' forum here). That said, I've seen some people making a distinction between using 'Lookup tables' and 'Lookup fields within a table', but given my relative newbyness I'm struggling to see the difference!
- If the answer is yes then what approach should I take to achieve the same aim (having multiple tables that feed information to one another). Initial research seems to suggest putting lookup/combo boxes in my forms. I'm dabbling with that at the minute but so far the results haven't been as desired.
I've attached a zip file with a screenshot of my relationships diagram to give an extra idea. Note that the relationship between the 'Site assessment' table and 'Site contamination event' table isn't showing up as I removed while trying to troubleshoot, but it is supposed to be one-to-many from 'Site contamination event' to 'Site assessment'.