Hotkey For Toggling Between Field Row In Table Design View And Its Field Properties?
Feb 15, 2013
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?
I 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.
Why 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?
I am working in the design view of a form, the controls properties sheet disappeared-gone and even clicking the properties sheet button it does not come back.
I am trying to hardcode in the field name. This is what I want to hardcode "TEXT(ROW(A17),"-0")" but the parenthesis and quotation marks are causing a syntax error. It appears like this
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.
I have a table in Access 2010 containing the results of a survey. One of the fields in table is the actual quotes from customers who gave direct feedback. I have created a simple report containing all of the quotes. My manager would liek them included in a summary Word doc but wants quotation marks around every quote. It's too many to manually after the report is exported to Word. Is there a way to include quotation marks around the field in the report design view?
I have an old db. I would like to see the forms and tables so I can select them and make changes. I know there is a way to access those items on startup but I have forgotten how. When I bring up the db I see a form and I can get into VB for that form but I cannot see any embedded table, forms reports, etc.
I try to put an expression for the property "bound column" so that my lookup values will be directly dependent on one of attribute's choice
I have got four options for my attribute. Each option will use a slightly different set of lookup values. I save all four sets in another table.
Then in my properties definition I refer directly to this table as lookup base. When I put bound column number equal to an expression so as to choose the right column of lookup values it refuses. It seems that it does notl ike anything other than a numeric value.
If that's a no-go, I am not sure how to achieve what I try to do then?
Essentially I have a table that 4 attributes: QID,itemID,CatType,Catchoice
CatType can have only 4 values. Each value will make Catchoice take on a different set of combo values
The problem I am having is that I am stuck at the Catchoice lookup definition because it is dependent on what kind of CatType the user picks.
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!!
Recently I'm helping a friend to convert his MS-Excel spreadsheet into MS-Access. I met a problem and need some help on defining the table fields.
In one of spreadsheets, he gets 3 columns, the 3rd column values is calcuated by a formula based on the previous two entries as the followinf: D3= C3+B3
When I tried to turn this table into MS-Access design, I don't know how to define the 3rd column (field).
Is there any chance I can set any expression/formula for 3rd field in the table defnition to retrieve data from previous columns( I don't want to design this function in the query)?
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...
problem using MS Access 2010. One of my database field's is using multiply values (you can add one than more values in that field by checkbox). So, for example, one record in that ONE field looks like this: "Gastropoda; Mermithidae; Nematoda; Oligochaeta; Scorpiones". When I'm going to "PrivotTable view" I have only "Ga" for instance instead of full names...
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.
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.
I 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
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).