Search results

Hi all. Hopefully I'm not duplicating a topic here, but I haven't been able to find what I've been looking for elsewhere so here goes: I've built an HTML web form that sends an email to me upon submission with all the field inputs. I have previously found success using VBA in Outlook to parse...

Hi all. I have a boolean array, foundState(3), whose 4 elements correspond to 4 variables describing conditions that will dictate what action is taken upon closing a form. There are only 6 possible outcomes for the array, and they can be divided into just 4 cases: Case {T,T,T,T} Case...

On a data entry form bound to a single table, there is a subform displaying all the records in the source table. If the user accidentally adds a record that they didn't mean to add (or if I add a record to test the form's functionality), and then right-click and delete the record, "#Deleted"...

I've got a data entry form bound to one table. The form has four buttons: - Clear Fields - Cancel - Save and exit - Save and add another (which should save the user input to the subform/table, clear the input fields, and allow the user to add another record) I can't quite seem to get the "Save...

On a form (default view: Single), I have a bunch of bound controls that display one record at a time from tblMain. I have a bunch of unbound controls as well (buttons). If the user tabs through all the controls, reaches the last one (btnLast), and presses tab again, the focus is set to the...

Form Corrupt? OnLoad event not firing I have a form w/ subform. Both have event procedures tied to their respective OnCurrent events. What I'm trying to do is, when the main form loads, run a Public subprocedure that lives in the module for the main form. I've been able to create click events...

I'm trying to emulate a behaviour in Access that I see a lot on web forms: you click out of the active control (into blank space, not another control) and the form fields update appropriately. So I want my users to be able to click on the white space on a form I've built and have that trigger...

So I've got a form: - A set of unbound controls filters (using a dynamically-built WHERE statement) a subform in datatable view. - A set of bound controls displays the currently selected subform record; the two reflect one another. - A set of unbound checkboxes at the bottom allows the user to...

Ok, I've got a form (frmEdit) that allows users to search tblMain for records using a bunch of unbound controls and a dynamically created SQL statement. Search results are displayed in a subform (subMain), and the current record in the subform is displayed in a set of bound controls on frmEdit...

A few months ago I posted a question about how to get a form and subform to behave like a split form (because split forms suck). I'm very close, but am stumbling at the finish line. I've got an Access 2007 db with a form (frmEdit), on which there is a subform (subMain), whose record source is...

Hey all. Just wrapping up my first access programming project and am integrating some error handling code. Never worked with it before. Found this and this very helpful in getting me started. Question: I'm trying to sort out how to put multiple error handlers in one procedure. For example, I...

I've got a form (frmEdit) that allows users to (1) search tblMain, (2) view those results in a subform, and (3) view the current record in a set of bound controls. I want to add code for a button to run a query (in table view) based on the user's search. Since every search will be a little bit...

Noob question, probably, but some cursory searches failed to deliver what I'm sure is a pretty simple answer. QueryDef objects (http://msdn.microsoft.com/en-us/library/office/bb177500(v=office.12).aspx) have a couple properties I'm having a hard time understanding the difference between: Use...

I have a form (frmEdit) On that form is a subform (subMain) On that subform is a footer, and in that footer is a textbox (txtCounter) whose control source is: =Count(*) On frmEdit I have placed a textbox (txtCounterDisplay). I have created a subroutine (Private Sub CountRecords()) to control...

Can't add DAO reference. Even to brand new db. Hello all. Very confused right now. I have an existing db, and I need to add the DAO library reference to get it to work the way I want (see here for an explanation). I keep getting an error when I try to add the reference, though: "Name conflicts...

I've got an Access 2007 db with a form (frmEdit), on which there is a subform (subMain), whose record source is "SELECT * FROM tblMain;". frmEdit is intended to allow the use to filter the results and the fields (columns) displayed in subMain, and to allow editing of the entries displayed. This...

Hello! You can call me Syntax :) I'm a grammar Nazi with an understandable dislike for the connotation. Although depending on your political leanings you may not draw much of a distinction between nazism and socialism. But there is a significant difference! A little bit of embedded...