Search results

My solution to my problem is: Instead of using all the vba code, just use the expression builder for each text box an insert the following: =Round(Sum(IIf([Breakfast]="Evening Snack",[TotalCalories],Null)),1), I rounded it to keep it from getting to large of results. that was the first one there...

CJ_London Thanks for all your input. i have solved the problem with the help with someone else. thanks again steven

CJ_London let me do some back tracking here. I am building an nutritional and health app for diabetics. Keeping track of insulin usage, food nutrition and exercise with the ability to print reports to make working with my doctor a little easier. Now back to your question. I know that part works...

CJ_London when then app opens it open a user login form that set the user number via TempVars.Add "CurrentUserID", cboUserLogin.Value get it from the user profile table.

CJ_London It is a query and it is used for 2 other forms neither of which is open. there is one parameter that refers to a global user number.

I’m trying to use this little tid bit of vba code to fill in some textboxes on a report I’m putting together without any kind of luck finding anything on google. Private Sub Report_load() Dim db As DAO.Database Dim rst As DAO.Recordset 10 Set db = CurrentDb...

Thanks for the quick reply. 1/3 = .333333∞ I Just wanted it to get it to read .3 = 1/3 teaspoon or cup in my Nutrition Facts form. I'm working on a nutrition tracking db or as it is now called application in Access 2013. I'm just getting started with Access and VBA, but with the help from...

Mark I have a question, how can I modify the numerator of your code snip so that instead of it outputting 3/10 for .3 get it to output 1/3. Trying to get fraction like 1/3, 2/3. I'm using it for measure like 1/2, 1/3 cup and all those other thingy's. Other than that it works great. Thanks for...

Hi there buratti It's been a few years since anyone has posted here. I was just wondering if you have done anything else with your Menu Creator, and have you made any upgrades to it? I just downloaded it and it's working great. I'm using it with Access 2010 Thanks Steven :banghead:

I'm fairly new to the forum thing. I just started working on a Access 2010 project and I prefer to do as much VBA coding as possible. I've been doing coding with basic since the old 16 bit Atari days. that's what got me hooked on it. I would like to further my knowledge working with access. I...