Search results

I was wondering if there was a way to handle abbreviations. I have a form that has a field called Project Name where a user types the project name. We have certain abbreviations we use for a building making it hard to search in the future. I know we can set the autocorrect option on Access...

I have this estimate database for a construction company. In this database I calculate how much will a project cost. It’s pretty much complete the only problem that I have is trying to figure out how to update the cost of a trade without affecting older records Example let’s say we have a...

Hello I have to build an estimate worksheet from scratch on Access I am almost finished with the project but I have a few questions. (SEE ATTACHMENT FOR CLARIFICATION) 1. There is a labor section on the form where the user selects the combo box adds the quantity of workers, and number of...

Hello I have a combo box named L1 and after it is selected I want it to retrieve the hourly rate associated. After that i want it to multiply with the number of hours. I came up with this code but it will not accept the "=" in trades. I took it out and it only gives me the value of the first...

Hello I’m fairly new to access and I do not understand relationships I want a table that has a Primary key as an SRNumber which is like a workorder, this table will include Labor, Materials The second table I want it to be a Labor table, which has a combo box with a list of labors, an hour...

I need help with these formulas, i tried using this one but it told me it was to long =IIf([Combo5]=“Building Service Engineer”,[Forms]![Estimate]![Text787],IIf([Combo5]=“Carpenter”,[Forms]![Estimate]![Text788],IIf([Combo5]=“Custodian”,[Forms]![Estimate]![Text789],IIf([Combo5]=“Custodian -...

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...

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 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...

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...

I entered this iff statement and it says expression you entered is to complex can someone give me advice on how to approach this. Do you think i should split the formula Thank you IIf([MarkUpI]=100 And [Stock/NonStock1]="Stock",[QTY1]+[UnitPrice1]*1.22, IIf([MarkUpI]=101 And...

Hello I have a database with data already entered. I have a Table that has a Field Name BoxNo which is also is my ID. The boxNo goes from 1,2,3,4...and stops at 50 has a gap and then starts again at 100,101..etc I want to be able to have an increment of one with the boxNo. I made this code with...