Recent content by nyaworld

I saw another older posting (not here) and I think I'm missing something because it doesn't work... As this project progressed I found a slightly different way to do it which worked even better for me, it involved using an empty text box as a repository for each item I wanted to display as in...

Is there a way to do this via VBA ? I have 100 + yes or no check boxes and I was hoping not to have to add an IIF statement for each checkbox field.

I am using Access 2016 and when I extract and open with Access, it shows a blank screen. No navigation pane, F11 or ALT + F11 doesn't do anything. The ribbon only shows "FILE" tab and everything else is locked. What am I missing?

Hi. I'm looking for a solution to this very issue and I tried to download the zip file you attached. Maybe it's corrupted, but when I attempt to open it, it's just blank.

The original formula works for one calculated field. I then added the IIF statement because you can't divide by zero and what I posted afterwards was the final formula I finally figured out to combine 3 different fields including the original formula for BMI and has a result of "Missing height"...

I have the same issue. Did you ever get this resolved?

The formula I am using is correct, I just didn't run the weight and height via my formula when I was giving an example. The BMI result from formula for 200lbs and 60" is 39.1 I eventually figured out the correct expression in my calculated field: IIf([Height (in)]=0,"Missing Height","Height...

I need help with something more challenging.... A=weight B=height A is number, B is number and I need the following output in a calculated field, C: Weight is: 200 lbs. Height is: 60 inches BMI is : 20.5 39.1 I want the above statement to be in one field.... field C The BMI is...

Re: merge two field value in one field in access As you know, Access 2013 Web App allows you to add a related item control. Unfortunately, it only allows you to display no more than 4 fields. I have found a workaround for displaying more information by adding a field to my table with Calculated...

By "It", I mean the result of field in my form. Thank you, the formatting did work.:D

It shows an extra couple of zeros. How would I get rid of the seconds? OLD -> NEW Start Time StartTimeNEW 15:30:00.000 3:30:00 PM

I wanted to make any adjustments into the query that is feeding my form. How do I combine these two formulas into one so I can write the formula into a new column and use that field in my form: Original problem : [Start Time] = 17:30:00.000 <----text value StartTimeNEW: Mid([Start...

How would I trim off the decimal portion?

Would you be so kind as to share the syntax for this? For example the current text value is 17:30:00:000 (5:30pm), how would I trim off and then convert this text to a time ? I have tried this and it doesn't work in a query: =CDate([Start Time) Is it supposed to be in my query, or in the...

How do I convert the field (a text value) into a time value? Can't I do this in a query? If I can, how? I have tried all sorts of functions and I still get #Error.