Recent content by johnherrerajuan

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

For the first method, where would I store this information? For the second method I started doing something similar (RangeOfWageDates Table), but my question is would I need some coding that determines what price is going to be selected based on the date?

where with in the project would i need to store the data, in an other table? I tried to add a sub form with the fields [Material SR] [Material] [Description] [Stock/NonStock] [QTY][UnitPrice] but when I jump to the next record on my main form the subform stays the same! This is why I went with...

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

The reason I used a form is because I am not sure if I could use VBA codes on a report, so what I do now is adjust the size to fit in a page Also, how can I preserve values? I know I have to use VBA but can you help me out with that And flex grid is a flexible grid that expands based on users...

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

You are amazing!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! :) thank you!

I put it in the Expression Builder and it said Syntax Error i put it on the Vb an it came out with a red column There is no Primary key so i tried 0 as well

Ok [L1] [L2]... [L12] are just combo boxes on my form that retrieve information from Table: Labor, which have (Trades,MonthlyRate,HourlyRate) as columns. Im using any random unbound box right now for experimenting. What i want is the value of trades(text field) to equal the number of hourly...

I used: =[12].[HourlyRate] But, #Name? is the return when i typed it in on the expression builder

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

It is! I have a form that is mainly used for data entry. and all the information will migrate to a second form as shown here the thing is that i dont want all of them to show, just the ones that have a value great then one. so i want to replace the boxes with combo boxes so i can just click...

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

I also tried it this way but there is an invalid syntax =Switch([Combo5]=“Building Service Engineer”,[Forms]![Estimate]![Text787],[Combo5]=“Carpenter”,[Forms]![Estimate]![Text788],[Combo5]=“Custodian”,[Forms]![Estimate]![Text789],[Combo5]=“Custodian - Shift Pay (5am -...