Search results

  1. missinglinq

    Copy To next record

    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 YourControlName_AfterUpdate()...
  2. missinglinq

    error 3129

    Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. Linq ;0)>
  3. missinglinq

    Solved Displaying the data format

    In the Format Property for a given Control you can do it like websites sometimes do, using a Format of @;"Please enter date in mm/dd/yyyy format" or simply @;"mm/dd/yyyy" This will appear in the Control until a value is entered. Linq ;0)>
  4. missinglinq

    After Update

    So clear the patient name after the code form printing the label: Me.Patient = Null Linq ;0)> (Retired Male Nurse)
  5. missinglinq

    SelLength not working

    Do you not have to set Focus to the Subform Control itself...then to the Control on the Subform? Me.NameOfSubFormControl.SetFocus Me. NameOfSubFormControl.Form.ControlName.SetFocus Linq ;0)>
  6. missinglinq

    Check Box / Enter date

    I don't quite get this: You want to add a month to the day after the day you're checking the MTM Checkbox? Or was tat a mistype? The error you're getting is because Mike's was apparently having a bad day...the code should have been If Me.MTM=-1 then Me.EndDate = DateAdd("m",1, Me.EndDate)...
  7. missinglinq

    Event Buttons Not Working All of a Sudden

    You subject line is 'Event Buttons Not Working All of a Sudden;' is that correct...all buttons have stopped working...or just the one button? Linq ;0)>
  8. missinglinq

    Check Box / Enter date

    Anything but that 'lite' slop! Had to drink that as a youth (from age 18 to 21) and hate it! Linq ;0)>
  9. missinglinq

    Exceeding Limits via Code?

    The difference between data entered thru the keyboard, and that entered thru code, is not in this instance, unique...for Memo Fields (Long Text, I believe, in later versions) can have up to 65,535 characters, or there about, when typed in...but when entered thru code is only limited by the...
  10. missinglinq

    Exceeding Limits via Code?

    Sadly...not to American taxpayers! :banghead: Linq ;0)>
  11. missinglinq

    Error 2462 - Resizeform Module

    Is not one of the limitations of Access Runtime that it doesn't allow design changes...and is that not the point of the FormResize hack...to resize the Forms? Linq ;0)>
  12. missinglinq

    Before Update/Close

    BTW...the If Me.Dirty = True Then...End If is useless in the Form_BeforeUpdate event. If the Form isn't Dirty, the Form_BeforeUpdate event will not fire! Linq ;0)>
  13. missinglinq

    ActiveX OLE error

    Was the error something like this: "A problem occurred while Microsoft Access was communicating with the OLE Server or ActiveX Control." This type of error, usually but not associated with opening a Form, is apparently caused by all kinds of things, and, to the best of my knowledge, it is...
  14. missinglinq

    Form Before Update Cancel Event doesn't work

    Nothing! You're right...trying to do too many things at once! Corrected above! Good catch! Linq ;0)>
  15. missinglinq

    only numbers function

    That's true...but I'm getting old and forgetful...and I like making things as self explanatory as possible! Linq ;0)>
  16. missinglinq

    only numbers function

    That's true...but the provided code uses the KeyDown event. Glad we could help, amir0914! Good luck with your project! Linq ;0)>
  17. missinglinq

    only numbers function

    Here's a hack from the vaults that's the kind of thing that theDBguy suggested...(Replaceing YourTextBoxName with the actual name of your Control.) Private Sub YourTextBoxName_KeyDown(KeyCode As Integer, Shift As Integer) Select Case KeyCode Case 48 To 57 'Do nothing: Numerical...
  18. missinglinq

    Function for auto dropdown for all combobox

    Because in Design View he can select all 20 Comboboxes at once...go to the OnGotFocus Property...and enter =ShowDropDown() once...as opposed to having to create 20 events, one at a time...explicitly, naming each Combobox, i.e. Me.Combo1.Dropdown, Me.Combo2.Dropdown, Me.Combo3.Dropdown etc...
  19. missinglinq

    Avoiding #Deleted

    I agree, of course! Preventing an error, rather than covering it up, is always, well at least always, the way to go! I just wondered if anyone knew of any other reason for #Deleted to show except when a Record had actually been deleted. Linq ;0)>
  20. missinglinq

    Avoiding #Deleted

    Actually...the OP says nothing about Deleting a Record! Does #Deleted really show if data is simply 'unavailable?' Or is this a sign of corruption? Linq ;0)>
Back
Top Bottom