Search results

SELECT Labor.Laborer FROM Labor ORDER BY Labor.[Laborer]; that shows up And also i previously typed in the values in the combo box so i had to go back and change it to get the data from a table

Well Im going to do this for 10 combo boxes so it would be from Combo2-12 and the last 0 is not important. How do i Post the SQL for Combo4

Now its saying Text to long to be edited

I fixed it but it would not let me enter it to the expression builder =IIf([Combo4]=“Building Service Engineer”,[Forms]![Estimate]![Text787], IIf([Combo4]=“Carpenter”,[Forms]![Estimate]![Text788], IIf([Combo4]=“Custodian”,[Forms]![Estimate]![Text789], IIf([Combo4]=“Custodian - Shift Pay (5am -...

http://www.access-programmers.co.uk/forums/showthread.php?p=1284670#post1284670 Sorry, I re-posted the question in a simpler way

Hello I have a form that is used for data entry; from there I want to create a new form where I can select a field from a combo box which would generate the amount associated. Example on the first form it has a Carpenter that has a calculated output of $1000, on the second form I would want to...

Hello I have a form that is used for data entry; from there I want it to go to another form where I can select a field from a combo box which would generate the amount associated. Example on the first form it has a Carpenter that has a calculated output of $1000, on the second form I would want...

I figured it out i used conditional formatting, but thank you for your time

I like your idea but I'm afraid it is a little to late to turn back that far, I want to know if it is possible to have a unbounded check mark control the color of a text. If so can you help me out on that.

Well hello everyone I created a form that has about 200 fields and all the fields are utilized at a point depending on the work order assigned to us. I wanted to know if it’s possible to put like a toggle box or a check box etc. next to the field so if it is checked it would be in a Dark color...

I want to create a tutorial inside a form showing how to use my database. I created it in PowerPoint and saved it as a PDF. I was wondering if it was possible to attach this PDF in my form. I also saved these slides as images on my computer, tried to attached them to a form and it exceeded 22...

I copied and paste the whole file then it worked fine i am not sure is this is a temporary solution but now it works fine... can anyone explain to me what went wrong

http://temp-share.com/show/KdPf2ipFh that is my database

The boxes on the form are unbounded boxes with control =[box1]+ [box2]+...... or else it would be an if statement for overtime and markups. it all worked correctly before =IIf([MarkUp]=100,+[Building Service Engineer]*1.15+[Building Service Engineer],IIf([MarkUp]=101,+[Building Service...

I just right clicked on the form on the navigation pane copied and past it then renamed it as Estimate(for reporting purpose) and another one for budgeting purposes the original form has the word #Name? the copies have the word error!

I created an estimate database, I have a form that is used for data entry purposes it was working fine until i crated a duplicate that is arranged diffidently for printing purposes. Before i would just enter the data and it will perform alot of calculations and shoot a grand total now all it...

This is the form i am talking about

Ok I will do my best to explain my problem. I crated an estimate database that consists of labor, markup, material etc… I crated a form which is intended for data entry use. The form has about 200 fields and calculates a lot of my data. Each record has its own project Id. I worked on my first...

Thank You, Words cannot express how happy I am right now!:D

But i have a quick question can i enter this in a calculated field on my table