Recent content by SoxPats83

well, the thing is a lot of these unbound text boxes are referencing text boxes that are bound to a field that a user has inputted numbers. for example an unbound text box may be referencing a bound text box that has 1, 1, 2, 3, 0, 1 in it's records. the formula in the unbound text box is for a...

they are not bound. in regards to giving the text boxes meaningful names, i have other text boxes within the form that formulates other text boxes that have meaningful names and i am getting the same result.

i'm sorry, when i said every record, that is when i do it from a form, not report. typo on my part.

=[Text87]+[Text90]+[Text92] hope this helps

if i copy all fields and paster them into a form though this problem does not happen.... but i cannot do the sendobject macro from the report as it with send every record and i only won't the current record to be sent as the attachment.

I have and yes.

i know this is kind of a crazy scenario... sadly i have a deadline on this, so if anyone has any ideas, i would hugely appreciate it. happy to add to reputation...

Hi all, i have a report i am running with hundreds of text boxes in it with their sole purpose to calculate totals. i have all the formulas typed correctly and everything works great. the problem i have here is that when i am finished with the report and close out my DB, the next time i open it...

i appreciate the reply, but in yoru attached link, i fail to see where i would be able to create a combo box with all tables/queries listed in the drop down? i am sure it is all there, i am just missing it...

i have a unique one here. i would like to create a combo box on my main form that contains all of the tables and queries available in the DB so the user can change the recordsource. i have a particular form where the recordsource changes daily, and i would like to have this combo box so even...

i trye to type out the code in VBA in the on open event and get a message saying that i cannot add a value to this box. kinda odd...

sorry, i have the module in place and the second text box with the =fOSUserName() in place. problem is, how do i reference this to the original text box so not to compromise the control source??

maybe i am having a bad day, but i am still at a loss here...

an alternative i have come up for this is making the control a combobox and making the user input something into it. problem is if i import all of the tasks into the table (not knowing who will be doing which ones at that time) the reuired field in the table design view causes problems. what i...

Sorry, invalid expression in the table design view.