Search results

As theDBguy said, you can use the AfterUpdate event of the Control holding your data to set the DefaultValue for the Field. From that time forward, until you either manually change the data or close your form, the data will be entered automatically in each New Record. Private Sub...

Stephen Labans, as is frequently the case for matters complicated, has a hack for doing this that requires little in the way of resources, he says...and you can always take him at his word: http://www.lebans.com/hscroller.htm Linq ;0)>

See if this suits your needs: Private Sub txt_Name_Click() Me.txt_Name.SelStart = 3 End Sub Private Sub txt_Name_Enter() Me.txt_Name.SelStart = 3 End Sub Linq ;0)>

That's your problem! You can't have the Checklist Form as a Subform if it's not related to the Assets Form! You need to have the Checklist Table related to the Assets Table! You need to Add a new Field (AssetID) to the BuildChecklist Table. Now...in Form Design View Select the Checklist Form...

Like Pat, I don't see a Table that looks appropriate for your Deployment Checklist...but, going by it sounds as if you don't have a Field that is common to the assets Table and the checklist Table...something needed to make the checklist items only be associated with a given asset. It sounds...

Never run into this before but you are indeed correct! Only workaround I could come up with (it's been a very long day and I going to La La Land soon) is to assign the field as Text then use this txtCurrency.SelStart = 0 txtCurrency.SelLength = Left(txtCurrency, InStr(txtCurrency, ".")) &...

When validating multiple fields, you have to Exit the Sub each time a validation fails, giving the user a chance to correct errant Control, before moving on to the next validation check...otherwise the code simply 'drops thru' to the next check! Also, your Comboboxs are all Bound (have Control...

Is this app being used in a multi-user environment? Is it split into a Front End/Back End configuration...with Tables in the Back End and everything else in the Front End? If so, does each user have a copy of the Front End on their PC? Linq ;0)>

Not directly related to your question...but the above statement is kind of worrisome. This is a multi-environment database...so I have to ask...is the database split into a Front End, holding everything except the data...with a copy of it on each user's PC...and the Back End, holding the...

Have no idea why Access would balk and give that kind of error with Me.Refresh That error usually pops when you try to use Me. in the Control Source Property of a Control. If your concern is having a calculated field be re-calculated, when one of the component fields is changed, you really...

Do the Tables tied to the errant Forms both have Primary Keys? Linq ;0)>

There are a number of ways to approach this, all variations of Paul's suggested method, such as Private Sub Form_BeforeUpdate(Cancel As Integer) If Nz(Me.Control1,"") = "" Then MsgBox "Control1 Must Not Be Left Blank!" Cancel = True Control1.SetFocus Exit Sub End If If...

You could display each Control's name (or anything else you'd like) in the Control itself, when the Record loads, by, in each Control's Format Property, simply entering the name, or whatever, like this @;"Your Prompt Goes Here" The name or prompt will disappear when Control is...

Actually, in a multi-user environment, the number is usually committed at the last possible moment (i.e in the Form_BeforeUpdate event) to avoid duplication. Committing the Record as soon as it is created is only needed if it is mandatory that the number be visible to the user before the entire...

Just to be clear...is your complaint that Focus moves to the next Textbox on the Form...or that it moves to the next Textbox and tries to SpellCheck that Control as well? Linq ;0)>

When you open a Standard Module, it'll already have an Option Statement at the very top of it...simply go to the very top of the module (above the code you pasted in) and delete this. Linq ;0)>

Allen Browne has a well-written tutorial on this very subject found here: http://allenbrowne.com/ser-57.html Linq ;0)>

First, you complain that it is not displaying a new record...then you complain that it is displaying a new Record...which do you want? If you want it to move to a new Record...you need to tell Access to go to a new Record: DoCmd.GoToRecord , , acNewRec Linq ;0)>

I'd follow up on that! IT departments have a habit of 'updating' systems over the weekend when usage is lower/non-existent. Does any code run? Linq ;0)>

First...this kind of code needs to be in both the AfterUpdate event, as shown...and in the OnCurrent event. Next...what kind of Form is this...Single, Continuous or Datasheet? Lastly...if, as the last line of the above, you add Msgbox Me.txtRootCause what results do you get? Linq ;0)>