Search results

got it to work. my problem was that I had the default value entered for the control box rather than entering the calculation in the VBA code. I have a command button setup to read: Private Sub recalc_Click() Controlname.Value = DSum("[field1]", "[table1]", "[table1].[criteriafield] = '" &...

thanks for the quick response - what does the Parent! refer to? is it the form where the calculated text box resides? if so, it's not working for me.

I have a form, within that form is a tabbed subform. within this tabbed subform is another subform (a table). The table is used for people to log information on a monthly basis. adjacent to this table are some text boxes with calculations in them tied to this table. I would like for these...

thanks for this - I tried these steps, and unfortunately, none yielded any different results. However, I found that by NOT changing the checkbox with the next release, everything flowed through nicely.

I don't think that I am trying to using WScript - perhaps could be related to some date formatting when the page loads? the order of my references are as follows: Visual Basic for Applications MSFT Access 14.0 Object Library OLE Automation MS Office 14.0 Access Database engine Object Library MS...

what's interesting now is that I made sure to check the Windows Script Host Object Model reference on the next release, and when they installed it, the errors returned. when they went in and UNCHECKED the Windows Script Host Object Model reference, then the error went away. still can't figure...

all code is running correctly, but it appears that users are no longer experiencing issues after enabling the Windows Script Host Object Model reference and waiting a few minutes. thanks for your responses though, VBAInet!

when you say running any code, I presume you mean a macro or query? there is a query that runs when the form loads (continuous), but that information always pulls before the dlookups calculate. no macros are running at the time. it installs accdb on the users PC

correct, each user has their own front end (they get an installer link which places an icon on their desktop and installs the frontend on their PC) i checked the references, but not with a fine tooth comb. I presume it is some reference, somewhere.... no other relevent code is running

I don't think I need to post the DB (plus, I believe it violates the code of conduct here). but the formula references the "date()" function - could that be causing the issue? I know that with Excel, if you use certain formulas that others do not have installed (such as edate for example)...

long time searcher, first time poster... i created a database and released it for my team (frontend/backend setup). however, most of the members on my team are getting #Name? or #Invalid on some dlookup formulas in unbound text boxes. However, on my version, I see the actual data shown. I...