DataBase - Change a text box to a combo box
Asked By forest8
19-Mar-10 12:45 AM
Hi there
I have created several forms in my database.
I realized that I should have made them combo boxes instead of text boxes.
Is there any easy way for me to change them into the format I need?
Thank you in advance for your help.
EmployeeID
(1)
Database
(1)
ColumnCount
(1)
BoundColum
(1)
FirstName
(1)
Stafford
(1)
ChangeTo
(1)
Sheridan
(1)
Reggie replied to forest8
Right-click on the text box and select changeTo from the menu.
--
Reggie
KenSheridan via AccessMonster.com replied to forest8
Do as Reggie said, but you???ll then have to enter the control???s RowSource
property at least; and possibly also have to amend its BoundColum,
ColumnCount and ColumnWidths properties if the combo box is to show a value
from a column or columns in another table referenced by a ???surrogate??? foreign
key in the form???s underlying table. A combo box bound to an EmployeeID
foreign key column for instance might be set up as follows:
RowSource: SELECT EmployeeID, FirstName & " " & LastName FROM Employees
ORDER BY LastName, FirstName;
BoundColum: 1
ColumnCount: 2
ColumnWidths: 0cm;8cm
If your units of measurement are imperial rather than metric Access will
automatically convert the last one. The important thing is that the first
dimension is zero to hide the first column and that the second is at least as
wide as the combo box.
Ken Sheridan
Stafford, England
--
Message posted via http://www.accessmonster.com
Library Database DataBase Firstly, I am not sure if Library database is the correct term. I am talking about Dbs to which you set a reference drew blanks last time. Now assuming I have several referenced (library?) databases in my main database, how do I get the names of all the forms in all the Dbs? CodeProject AllForms.Count gives me the correct number of forms if I am in that referenced database. What I think I need is a method of looping through all the different CodeProject names in the main database, but there is not a sort of CodeProjects parent object. Or somehow moving the focus And, No, there is not any parent object for all the code projects. Because each database only knows about its own objects (or documents), you have to use a procedure in each database to refer to the objects in that database. E.g. to open a form in
SQL query slow DataBase Hi In the code below I found that it takes 1.3 seconds to load suited to handle databases beyond stamp collection size and lacks most features of a "real" database management system. Consider using a relational database, i.e. SQL Server Express, its free. Make sure to set primary key properties to to worry about problems like SQL injection attacks to you application. best, MiB. The JET database engine is often faster and more efficient than similar retrieval with SQL Server. And simply can be summed up as your general ignorance on the matter how = 20 computers and database engines function and operate in our industry. So your galactic stupidity and ignorance is well years - version 4 came with Office 2000. If JET is so vastly superior to regular database servers, kindly share the pearls of your wisdom and explain why companies like Oracle (guess rationale, but I am sure you will enlighten us. Can you also explain, please, why database client products like Sparxsystems Enterprise Architect using the same relational schema, same index structures, and to criticize an important MVP like you. Maybe this source is: http: / / databases.aspfaq.com / database / what-are-the-limitations-of-ms-acc = ess.html. I would like to humbly hint
Append to two different tables DataBase I think I know the answer: I want to Append "working" table fields to two passengers on the same reservation, etc.) which are associated with one tblReservation record. My FE database form for tblReservations uses a subform for tblReservationDetails so the main reservation information is presented append into BOTH Reservations AND ReservationDetails. Here is my SQL sequence: SELECT Reservations.ReservationID, Reservations.FirstName, Reservations.LastName, ReservationDetails.ReservationID, ReservationDetails.RidersName, tblWorking.FirstName, tblWorking.LastName, [tblWorking].[LastName] & ", " & [tblWorking].[FirstName] AS FullName FROM tblWorking, Reservations INNER JOIN ReservationDetails ON Reservations.ReservationID = ReservationDetails.ReservationID; Keeping it simple, I want to take tblWorking fields FirstName and LastName (put them together in a field called "FullName" created from LastName, FirstName) and place them accordingly: Append tblWorking.FirstName AND tblWoring.LastName to Reservations.FirstName AND Reservations.LastName. THEN, in the SAME Append, append
Reference another database DataBase I have no idea if this is possibe. Suppose I have 2 separate front end is supplied from the BE databases. What I want to do is have yet another database called say Menus.accdb which contains the 2 aforementioned forms, and remove those forms from I redesign either of those forms, I only need to do it once, and any database referencing the Menu.accdb will "see" the new design. So 1 Can it be done However, this is not my experience. I use many forms from a Menus.mdb- like database as generic forms in all my applications. If one needs another generic form, well, make the time element) is that I need to use the linked tables in the BE database for the menu system. How and when do you link the menu database to those table? How & where do you set the reference to the menu.accdb? is forms Thanks for your help Phil Phil If you are really going to automate your database, you write code to link the tables when you start it up. Microsoft has stopped
Store Employee ID in table, Display User Name in form DataBase There are two tables and a form: tblAssets tblEmployees frmAssets tbleEmployees, among other things, has columns for User FirstName, User LastName, and EmployeeID. frmAssets primarily deals with tblAssets but pulls from other locations, including tblEmployees. frmAssets has field for EmployeeID, but not employees names. There are two requirements: 1) When displaying entries in frmAssets, I want to see the employees name corresponding to the EmployeeID stored for that asset record in tblAssets. 2) When entering new records in frmAssets, I the appropriate employees name from a drop-down list and have it store the corresponding EmployeeID value in tblAssets. Can I do this simply using a query or coding and tblEmployees because it already has both the EmployeeID and the names? Or would it be better to build this using a query that IDs to names? Or is there another way I am missing altogether? Access Queries Discussions EmployeeID (1) ColumnCount (1) BoundColum (1) FirstName (1) TbleEmployees (1) TblEmployees (1) FrmAssets (1) TblAssets (1