Search results

  1. missinglinq

    Copy previous record fields into new record form fields

    You can't enter this in the AfterUpdate event on the Event Tab in the Properties box...it has to be entered as VBA code, in the Form's code module...as simply Private Sub Product Line_AfterUpdate() Me.Product Line.DefaultValue = """" & Me.Product Line.Value & """" End Sub as I showed. Linq...
  2. missinglinq

    Copy previous record fields into new record form fields

    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...
  3. missinglinq

    scroll text in bar form caption

    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)>
  4. missinglinq

    Access: Set focus cursor after character in a text box

    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)>
  5. missinglinq

    question about froms

    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...
  6. missinglinq

    question about froms

    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...
  7. missinglinq

    Highlighting the contents of a textbox on entry.

    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, ".")) &...
  8. missinglinq

    Forms not able to insert new record

    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...
  9. missinglinq

    Write Conflict

    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)>
  10. missinglinq

    Button to kick everyone out of database

    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...
  11. missinglinq

    Me.Refresh causes error

    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...
  12. missinglinq

    Error 3197 in bound form / linked to SQL Server back end

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

    Message Box not returning focus to the right field.

    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...
  14. missinglinq

    Populate the name of the active control on focus in a form.

    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...
  15. missinglinq

    Sequential number generator that resets

    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...
  16. missinglinq

    spell checker

    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)>
  17. missinglinq

    Centering forms on any computer when maximized

    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)>
  18. missinglinq

    Duplicating Form and Subform records

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

    save button notification

    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)>
  20. missinglinq

    Conditional Visibility

    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)>
Back
Top Bottom