Search results

open your table in design view and make sure the datatype setting for the field that you want to display 2 decimal places is set to number and not text. Then you should see the Decimal Places property at the bottom under the general properties tab. Set this to 2 and the table should display your...

OK, so I forgot an equals sign. Big deal. (I forgot an equals sign in the text box that gets retrieves the job name from a query created in the combo box.) I knew I was writing it right, but it kept returning an error. Anyway, now that my text box displays the Job Name that corresponds to the...

I thought I had a good handle on all of this, but I'm really lost now. I've changed the Job Name control on the form (the form's name is "Time Book") to a text box and I just want to use AutoLookup to get the name based on what the user chooses in the previous combo box (which is called Job ID...

The job name is important only so that users can see that they have put in the code that they meant to add. It's more of a mental reference to them than anything. The code is just not "memorable" to them, but is very useful for others. How would I retrieve the Job Name from the Work Orders...

What if you use a button to call a macro that opens the form. The macro action OpenForm allows you to specify what you need under the Action Argument called View Does this help? Path

What if when the text box is hidden you write a default value of some obviously false date or info, so that you can tell in the table to which it writes that no closing date was given. Path

I'm not sure I know how to join the JobName from the WorkOrder table to the JobName field in the TimeBook table. I understand the reasons for doing this, as it would eliminate possible errors in the field, but I'm just not sure how. Pat, do you think you could explain the process? And, if I...

I have a very specific problem with synchronizing two combo boxes on a form. The form name is "Time Book" and contains about 8 fields (all required), of which only two are combo boxes. Their names are "Job ID Code" and "Job Name". Currently, the user picks a "Job ID Code" and the choices in the...

Thanks Fizzio I was going to post virtually the same question, but was able to solve my problem in 5 minutes thanks to your help. I've been grappling with this problem for almost 2 weeks w/o a solution. I used the method you suggested using a query by form as my record source. Making sure that...