Search results

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.

You are right, I did. I got all excited and tried it the correct way and STILL got an error message: Real Time: CDate(Format([Start Time],"@@\:@@")) #Error :(

I get #Error run when I run the query ************Never mind. I used this in my control source and it worked! =CStr(Format(CDate(Left([Start Time],2) & ":" & Right([Start Time],2)),"hh:nn AM/PM")) This took 17:30:00:000 and made it show up in my form as 5:30pm . That's what I needed...

I tried this: Start Time New:CDate(FORMAT([start time],"0000-00-00 00\:00\:00")) and I get "#Error" when I run query.

I'm a newbie. I'm trying to accomplish what you did. The field I'm trying to convert from text to Short Date is called [Start Time]. Currently the value in this field is 17:30:00.000 (which I want to convert to 5:30PM (not military time)). Can you help me rewrite your expression so that it...

I put this into my query and when I run it, I get "#Error". Real Time: CDate(Format([Start Time],"@@\@@")) The value I'm trying to convert is a text string. So, 17:30:00.000 is supposed to be 5:30PM, but I can't convert it. I got excited when I saw this post, but it doesn't work. I'm using...