Search results

Yup, I got it work with me.refresh. One last thing I didn't think about is how to handle a null value. I set the Tablet Ratio and Participants After updates to run the query. I deleted the value out of the Visitors box (Participants) and it errored out saying invalid use of Null and brought...

Works great, but the base calculations weren't correct, i've corrected the formula and all is good. You are a rockstar !!! Thanks again for your help

Yes and No, I have to run it twice in order for the CurrentBases to update. I split into 2 separate queries, one for the TabletCount and then one for the Base Count and all is working as desired. Thanks again !!!

No problem and thanks again for everything. My query will look like the following as the tablet ratio could be different per facility. UPDATE TabletCalculator SET CurrentTablets = RoundUp(Participants/[Tablet Ratio]) WHERE...

If you look at post 24, I've attached a sample of what i'm trying to accomplish. As there could be multiple facilities being setup at the same time, I need to be able to display the results per facility, either stored or calculated and ultimately printed in a report. I am open to any...

Think I get it now, I was missing how the calculation worked out which is why I added it to the function, the calculation is in the () of the RoundUp Function. RoundUp([Input1] / [Input2]) In my case Input 1 will be from table 2 and Input 2 will be from table 1, how can I set that up?

I've attached a sample database with instructions of what i'm trying to accomplish. If you can think of an easier way to accomplish it, please advise. My actual DB will use linked tables. Thank you EDIT: Looks like we were working on a reply about the same time, i'll check your sample...

Disclaimer: Nothing against your suggested function in post 16, however I started testing with Isla's code to see if I could even get it to work, so below is my config. I'm sure i'm doing something wrong as this is all new territory for me, but I added a Module titled RoundUp, but then read...

How do I incorporate the RoundUp function in an update query?

Thanks for the tips, i've now got the calculations working, however I am unable to loop through and update all the records on my subform. I am using the following code in the Tablet_Ratio After Update but it only runs if I select a record in the subform prior to updating the tablet ratio on the...

Makes sense seeing it put in play, however i'm not getting desired results. It appears as it is rounding per the laws of rounding, where >5 goes up, < 5 goes down, however I need anything over 0 to always round up, i.e. 1.0 stays at 1 1.1 rounds up to 2 1.4 rounds up to 2 2.2 rounds up to 3 2.5...

the problem is i wouldn't be able to guestimate the outcome so it would need to be dynamic Private Sub Participants_AfterUpdate() [CurrentTablets] = Participants / [Forms]![TabletCalculator]![Tablet Ratio] [CurrentChargers] = CurrentTablets/5 End Sub CurrentTablets and CurrentChargers...

could you tell me how to make it so the result is rounded up to the nearest whole number? Ex: I am getting 0.2, would like to round it up to 1 or if its 1.4, I would like to round it up to 2

Actually I just deleted the parent and subforms and recreated them and all is working as intended, like I said, its been one of those weeks so I can't say i'm surprised a new form I just made didn't work until I deleted it and started over, lol.... thanks again !!

I just tried to select a different facility and enter the information just as a test and got the following: A Problem occurred while <Database Name> was communicating with the OLE server or ActiveX Control. Close the OLE server and restart it outside of <Database Name>. Then try the original...

C&R didn't do anything and what do you mean by decompiling? I did a Debug > Compile Database with the same result as well.

For some reason I can't think straight today, its been one of those weeks. I need to be able to calculate some numbers based off of a couple entries on my current form and its parent form, but I am getting the following error and can't seem to figure out what i'm doing wrong, even though it...

I have several fields on my form that I want to ensure are locked every time a new record is selected, so the data can't accidentally be changed. I have code set in the On Current event to handle this. These fields can be unlocked/locked via a button to edit the field if necessary, so I am...

yup, that works. Thanks again !!

so can I assume that I can use HTML tags in the constraints? basing this thought off of the <br> in your suggestion. If that's the case DEFAULT '<b> Server: </b> <br><b> Clients: </b> ' should work??