Databases
StackOverflow2013
Postsdbo
POMS-Access (Forms): allow user to enter invalid data in a bound, typed TextBox, with intent of correcting it programmatically. How?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMS-Access (Forms): allow user to enter invalid data in a bound, typed TextBox, with intent of correcting it programmatically. How?
    primarykey
    data
    text
    <p>I am in the habit of typing date/times in a YYYYMMDDHHmmss format without separators, e.g. "20110807050000" and I want to rig my "date" TextBoxes in an Access form to allow me to enter dates this way.</p> <p>The TextBoxes in question are databound to Table fields that are of Date/Time type.</p> <p>The way I have chosen to approach this is just to parse what I type and if I can get a valid date-time out of it, stick it back in the text box. The parsing etc. is complete and ready to go but I am stuck figuring out how to wire it into the form.</p> <p>Normally (I think .. access/VBA is a bit rusty ..) I would use "BeforeUpdate" event of a control to handle this kind of thing but the problem here is the Form is triggering its default validation error 2113 "the value you entered isn't valid for this field" before it even gets around to running the Control-level events.</p> <p>Then when I tried parsing/updating the TextBox in the Form_Error procedure, i get a 2115 error "The macro or function set to the BeforeUpdate or ValidationRule property of this field is preventing [...] saving the data in the field." In the Control.BeforeUpdate scenario, I think you can use the "Cancel" flag to get around this sort of hang-up, but Form.OnError event doesn't have anything like that (at least "Response" doesn't seem to be doing the trick.)</p> <p>edit-just to be complete: I also occasionally might <em>want</em> to use traditional "MM/DD/YY HH:mm:ss [AM/PM]" (or similar) form, and also that I already have parsing in place for pasting dates off the clipboard in another "common" format (the one used in Windows Explorer's Properties dialog), and would like this capability to remain, and remain extendable.</p> <p>Kinda stumped. Figured I would ask around a bit before resorting to some really invasive/ugly hack to get this working.</p> <p>Thanks for reading! Any suggestions/solutions are appreciated!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USYes-it-has-overflowed
    1. USYes-it-has-overflowed
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMS-Access (Forms): allow user to enter invalid data in a bound, typed TextBox, with intent of correcting it programmatically. How?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POMS-Access (Forms): allow user to enter invalid data in a bound, typed TextBox, with intent of correcting it programmatically. How?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou can't do what you want to do with a bound textbox, because one of the main "features" of the data binding is that it validates the data for you. You'll have to use an unbound textbox for this.
      singulars
      1. POMS-Access (Forms): allow user to enter invalid data in a bound, typed TextBox, with intent of correcting it programmatically. How?
      1. USDavid-W-Fenton
    2. CO@David TY! No way, huh? Well, moving onward ... I suppose there are enough tutorials to be found about doing this sort of juggling - e.g. something nasty like adding an additional locked, databound TB and updating it via code, while user activity takes place in an unbound TB. I will post back with what I come up with, but in the meantime, if anyone has any "hot" links on the subject...
      singulars
      1. POMS-Access (Forms): allow user to enter invalid data in a bound, typed TextBox, with intent of correcting it programmatically. How?
      1. USYes-it-has-overflowed
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload