Search results

I have a combo box [Submitter] that I have a VBA event procedure that updates an unbound text box [EXT] with a value from a different column. What I've noticed is that when I close the form and reopen, the updated text box goes blank again. Is there a way to make sure that the text box...

I am trying to create some code for a button in a report that will follow a hyperlink to a specific file. The problem I'm having is that the files that are at the end of the hyperlink can have various extensions (*.doc, *.docx, *.pdf, etc.) I'd like to be able to put a wildcard in the code to...

I'm not sure if this is the right forum. If not let me know and I'll move the thread. Table 1 Date Measurement A Measurement B Measurement C Table 2 Table 1 ID Link Data 1 Tables are linked 1-to-many from table 1 to table 2 by ID. I would like to average the Data1 data per Table1 ID and...

I need some help. I have a form that feeds information to a query which in turn sets up a report. For clarity i will list out in basic terms what I have Input Form - Check Box to activate/De-activate a text field [chk-active] - Text field for a parameter [txt-Parameter] the query has a...

Background: - Query with a form to drive certain criteria - The driving form has check boxes to create a Yes/No environment for which criteria a user can search from. - two of the three parameters work fine with this formula. - The formula sets up whether or not the check box is checked (0/1)...

I have 4 tables that cascade through 1-to-many relationships. I would like to build a form, not in datasheet view, that cascades through the different sub-forms and updates all the related tables. So far I've wanted to use tabs on a form for each sub-form, but only the top level table and the...

Hello all, I'm Justin. I'm not necessarily new to Access, but in the new job that i have, Access plays a big role in everyday work. I'm an engineer in the US (Ohio). I'm hoping the forums and other users can help me with some of the more vexing issues I've been facing when creating new...