Search results

I have created a form with some combo boxes to assign values to other boxes on the form. I can used the combo boxes to select the data I want to get the Task Code field to updated when I selected the Task Name in the combo box. I can't get the updated field (Lower right box) to update unless...

Good day all, I am familar with Access but haven't used it in several years and just started using Access 2010. I am working on a databased based on an exteranl database so I can't change the way the tables are set up. The tables combine serval parts of information that I need to seperate into...

SOS-Yes, I do know how to use Access (beginner level or a little higher) but it has been awhile since I used it and this is getting into using VBA which I am just starting to learn. I am a fast learner thought and am good with understanding how programs work. I know it is frustrating. I have...

SOS-When I changed the Control Source to the to the Table field, it change the data in the table to what is in the Split cell so I only get that part saved to the table not all 3 parts. Steve R.-It is for a work project. I myself could edit the full cell in the table but I am trying tomake a...

So do I need another Function in the Control Source for the text box I am changing?

Ok, I put the code in the Form Property under the On Current Event and got the Form to seperate the data like I want it to. I can change the data in the Form's text box but it doesn't change the data in the table. Am I forgetting a step somewhere?

I have tried the code you probided but Ma getting the #Name? error int he text box. I entered in the following code in the Control Source Property sheet box: me.Employee_Name=Mid(me.Bar_Code,6,5) but it gets changed to: [me].[Employee_Name]=Mid([me].[Bar_Code],6,5) where textbox2 is...

I created a form to edit the table Checkpoint. On the form I created 3 text boxes, one for each part of the cell BarCode to be able to edit each part seperate when it needs to be. How would I create a variable for each text box for each part?

The data is coming from a cell called BarCode from the table called Checkpoint. I can display the data by using the Mid string operation but won't let me edit the informatioin in the cell on the form. David

Good day to you all, I have been trying to figure out a problem and can't seem to find the solution. I have a data table that has 3 parts to it in one cell. I want to be able to break the part into individual cells on a form so as to edit the data in that part without having to edit the...