 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / December 2004TEXT BOXES.. HELP!
Im new to access and I have been having problems with my text boxes in my form. I am currently using Access 97 and I have text boxes that are supposed to be filled in with the First Name, Last Name and Employee ID but when I run the form it shows the FName, LName, and EmployeeID populated with just the EmployeeID in all the fields. How do I fix it that it is populated with the correct information. Thank you in advance for your time and patience! Cathleen Open your form in design view. Select the FName textbox. Open properties and go to the Data tab. There's a control source property first in the list. Click on the down arrow at the right and change the value there to FName. Select the LName textbox and change the control source to LName. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications resource@pcdatasheet.com www.pcdatasheet.com > Im new to access and I have been having problems with my text boxes in my > form. I am currently using Access 97 and I have text boxes that are supposed [quoted text clipped - 4 lines] > Thank you in advance for your time and patience! > Cathleen Cathleen, In Design Mode, place your cursor in the FirstName control. Find the ControlSource property for FirstName, place the cursor in that property, and use the little arrow on the right to drop down a list of available fields you can use for this ControlSource. IF [FName] (or whatever your table field name really is) is not on the list... then you haven't included it in the query behind the form. You'll need to correct the RecordSource query for the form and include FName field. If it is displayed in the list, then select it. Now... what the user enters in the FirstName control on the form will be stored in the FName field of your table. Do the same for LastName on your form with [LName] hth Al Camp > Im new to access and I have been having problems with my text boxes in my > form. I am currently using Access 97 and I have text boxes that are [quoted text clipped - 7 lines] > Thank you in advance for your time and patience! > Cathleen I did what you suggested and it still shows the Employee ID, what else can I do, why wont it show what is in the control source... I would be grateful for any more suggestions. Thanks! > Cathleen, > In Design Mode, place your cursor in the FirstName control. Find the [quoted text clipped - 24 lines] > > Thank you in advance for your time and patience! > > Cathleen Cathleen, Well, something is definitely amiss. There's no way that a field with a ControlSource of [FName] can display the [EmployeeID] value. What are the Names of each control on the form? What are the ControlSources for each field? What are the field names from your table? Please post your SQL statement behind the report. Is there any code that runs when the form opens, that relates to any of the fields involved? Let's try that for now. If still no luck, would you consider sending me the MDB? (if it's not huge) hth Al Camp >I did what you suggested and it still shows the Employee ID, what else can >I [quoted text clipped - 38 lines] >> > Thank you in advance for your time and patience! >> > Cathleen I will try and answer all your questions the best I can, Im sorry I dont know what things are quite yet. Here is what I have,the Form is called Inventory Transactions: Supply Request/Order From Vendor...CS... Supply Request/Order From Vendor Transaction Date...CS...Transaction Date Product Item Number... Control Source...Product Item Number Transaction Description...CS...Transaction Description EmployeeID...CS...EmployeeID First Name...CS...First Name Last Name...CS...Last Name Product Description...Product Description Units Requested...UnitsRequested Invoice Number...Invoice Number Reference Number...Reference Number Units Ordered...Units Ordered Units Received...Units Received Units Backordered...UnitsBackordered Discontinued...Discontinued Unit Price...UnitPrice My SQL Statement(RecordSource) is: Inventory Transactions The code when I open the Form is: Private Sub First_Name_BeforeUpdate(Cancel As Integer) End Sub Private Sub LastName_BeforeUpdate(Cancel As Integer) End Sub This Database is huge, and I have had people in my office look at it and they cant understand why it's doing this, it acts like it is completely ignoring the control source, I can even select other fields and it displays correctly. It just doesn't display the first name and the last name. This has been a very weird experience trying to use Access without the help menu, and only knowing enough to be dangerous. Thank you so much for trying to help me.. Cathleen > Cathleen, > Well, something is definitely amiss. There's no way that a field with a [quoted text clipped - 54 lines] > >> > Thank you in advance for your time and patience! > >> > Cathleen Cathleen, If the 3 fields we're discussing in your table are: EmployeeID, First Name, and Last Name... And the 3 fields on the form have a RecordSource of EmployeeID, First Name, Last Name... And... given that I can not actually "see" MDB then I can only offer these suggestions... 1. What happens when you just open the InventoryTransactions table in datasheet view... (not using the form)? Does EVERY (and I do mean every!) record contain the right values for EmpID/FN/LN?? Is there any chance someone may have entered EmpIDs in the FN and LN fields in several (or many) records, by mistake, and they happen to be the records you see when you open the form? 2. Using the form, does EVERY (and I do mean every!) record display the EmpID in place of LN/FN? I think you said all the other fields on the form are correct?? 3. Compact and Repair your tables... I've seen that cause really strange stuff. Back up your stuff just in case, but Compact and Repair is well worth the try. That's all I can suggest without seeing the MDB. If you have some hidden or obtuse code somewhere that's causing this problem, there's no way we can determine that via email. What version of Access are you running? Is your application Split? (ex. DATA.mdb and PROGRAM.mdb)? If you Compact your MDB AND Zip it... what is the size/s? I can accept up to ~8MB files in my email... I develop Access applications for a living... your information would be confidential. If you think sending me the MDB is viable, please post back your real email (cryptically encoded in some fashion) and I'll contact you "off-line". Try today's suggestions, and if that doesn't work, I'm afraid that's all we can do for now. hth Al Camp >I will try and answer all your questions the best I can, Im sorry I dont >know [quoted text clipped - 106 lines] >> >> > Thank you in advance for your time and patience! >> >> > Cathleen Al, 1. The form in the datasheet view shows the wrong information in FN and LN 2. I am the only one that is entering any information into the table right now. I have the record source pulling from the Inventory Transactions table and all the information is correct in there, so I dont know how it is pulling the EmpID for FN and LN. 3. I tried to repair and compact and nothing happened. I am running Access 97, and its not split. I appreciate the offer to look at it but I could be fired if I e-mailed this information, I am grateful for all your suggestions... Thank you for all your help. Cathleen > Cathleen, > [quoted text clipped - 149 lines] > >> >> > Thank you in advance for your time and patience! > >> >> > Cathleen Cathleen, > now. I have the record source pulling from the Inventory Transactions > table > and all the information is correct in there The data in the table is OK... that's what I needed to know. Anything I can suggest beyond this would just be guessing. Well, we tried... Al Camp > Al, > 1. The form in the datasheet view shows the wrong information in FN and [quoted text clipped - 189 lines] >> >> >> > Thank you in advance for your time and patience! >> >> >> > Cathleen Good afternoon If your record source does in fact contain First Name, Last Name and Employee ID, and the appropriate text boxes are bound to the fields, then they have to show the appropriate information. Best Regards Maurice St-Cyr Micro Systems Consultants, Inc. >Im new to access and I have been having problems with my text boxes in my >form. I am currently using Access 97 and I have text boxes that are supposed [quoted text clipped - 5 lines] >Thank you in advance for your time and patience! >Cathleen |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.