Copying txt from 1 textbox to another OR if value formatted a certain way delete the

[pimpzter]

On F_Schedule_review_wide there are text boxes called Task_Code and one named WO_Description. Everything works as it should except when the task_code value format is xxxxxxxx-xx-xx (can be numbers or letters). In most cases it is xxxxxxxx-xx. When task_code value format equals xxxxxxxx-xx-xx then I need wo_description to be blank otherwise put what it normally would which is control source wo_description. Any help is appreciated in advance.

[June7]

You could check the length of the value.

Is this for a report output? In ControlSource of textbox:

=IIf(Length(task_code)>11,Null,WO_Description)

[pimpzter]

Thank you for the reply. Where would this go ? I tried putting it in the text Box but not the output is #Name? on all the WO_Description Boxes. This is for a Form which pulls data from different places and basically... output in the form.

You could check the length of the value.

Is this for a report output? In ControlSource of textbox:

=IIf(Length(task_code)>11,Null,WO_Description)

[June7]

Are task_code and WO_Description your exact field names? Are they both included in the form's RecordSource?

[pimpzter]

For some reason this file is protected from getting into design mode to see all forms and queries. Holding shift as you open it dont work neither does alt f11 or ctrl g or any of the other shortcuts I have been told to try. Not sure of a way aroud that either. The part that I do have access to get into is this particular form you can right click and hit form design. The one box that pulls the actual Work Order Description has a control source of WO_Description. The same goes for Task_Code. I hope this answers the question you asked or gives you a better idea of what im seeing. If it would help I could email you this database.

Are task_code and WO_Description your exact field names? Are they both included in the form's RecordSource?

[June7]

From what you describe the expression should work but should be the ControlSource for the WO_Description textbox. Can attach project to post. Follow instructions at bottom of my post.

[pimpzter]

I tried again to put your code as the ControlSource for the WO_Description text box but got the same results. I compacted and zipped the database and it is 6mb

From what you describe the expression should work but should be the ControlSource for the WO_Description textbox. Can attach project to post. Follow instructions at bottom of my post.

[June7]

Can upload to a fileshare site such as box.com and post link to the file.

Or extract just the objects relevant to the issue into another db.

[pimpzter]

I have created a box.com account and the link is
http://www.box.com/s/aad23726ec40e1882e3a

Can upload to a fileshare site such as box.com and post link to the file.

Or extract just the objects relevant to the issue into another db.

[pimpzter]

Im sure it would be helpful if I told you where the form was.

Search Engines
Search P3e schedule
T Sschedule Review
From the top right green box select any start date schedule
Then click open selected schedule
Click Wide View
Right Click to get to form design and now you are where I am

[June7]

Little problem here. When I open the db it wants to search for some referenced files. I can see the Navigation Pane while this search is active. I cancel search (two of them) and even with holding down the shift key, a form opens and the Navigation Pane is not visible and can't seem to get it open. I am using Access 2010, not 2003 but I should still be able to view the db objects if I can get past the automation. Never encountered this before. Need a clue.

I click the Search P3e Schedule button but nothing happens.

[pimpzter]

hmmm... when you click the search p3e button its prolly pulling data from tables.. but you should still get to the next form. If I knew of a way to get into design mode to view all the tables and forms you could just clock on the one I have a question on. another roadblack... any suggestions on what i can do to help ?

Little problem here. When I open the db it wants to search for some referenced files. I can see the Navigation Pane while this search is active. I cancel search (two of them) and even with holding down the shift key, a form opens and the Navigation Pane is not visible and can't seem to get it open. I am using Access 2010, not 2003 but I should still be able to view the db objects if I can get past the automation. Never encountered this before. Need a clue.

I click the Search P3e Schedule button but nothing happens.

[June7]

Why is the form opening automatically and the project window (Navigation pane in 2010) hidden? Even when the form does open, If I try to switch to design view, Access closes. Also, have to run the file from C: drive. Can you eliminate the code causing all this? Is there an Autoexec macro?

If you cannot alter behavior in this project, might have to build another project that imports all the objects and then selectively import code (macros and VBA). Maybe the code that causes this can be eliminated this way.

[pimpzter]

A little background. The guy who made this project no longer works here. Now they have tasked me with changing a few things. I also have the same issue of trying to get to the design mode where I can view all tables, queries, and forms therefore I cannt manage to access any of the code. I know he has all his databases set to run from C: because when everyone runs them from a shared drive they can get corrupt. suggestions ?

Why is the form opening automatically and the project window (Navigation pane in 2010) hidden? Even when the form does open, If I try to switch to design view, Access closes. Also, have to run the file from C: drive. Can you eliminate the code causing all this? Is there an Autoexec macro?

If you cannot alter behavior in this project, might have to build another project that imports all the objects and then selectively import code (macros and VBA). Maybe the code that causes this can be eliminated this way.

[June7]

Try the import to a new project.

This is not a split database?