Search results

  1. C

    Spell Check in Acess - Disable the save

    Private Sub chsNotes_AfterUpdate() If Len(Me!chsNotes & "") > 0 Then DoCmd.RunCommand acCmdSpelling Else Exit Sub End If End Sub The Latter runs a spell check on a field. I noticed however that it also causes the record to be saved after clicking ignore or...
  2. C

    import 1NF to 2NF db

    Hello, I am not sure if this topic has been coverd in access-programmers forum but I'll ask any way. I have thousands of records stored in excel (1NF). I have a access db to improve the need to have so many records duplicated. Is their a way, via an action query (if so what one - update...
  3. C

    A better mouse trap?

    another minor loop hole Hiya, Soz for posting this thread if you have already seen the loop hole. When your tbproper was fixed by reseting it - Me.tbProperSave.Value = "Yes" DoCmd.RunCommand acCmdSaveRecord Me.tbProperSave.Value = "No" this worked fine on...
  4. C

    acClose form, Msg VBy/n

    great, thankyou :) it 70% of what i needed, im sure ill be ok with the rest :)
  5. C

    acClose form, Msg VBy/n

    Fixed Hi peps, soz,, i suda played around abit more, the follwing works fine... Private Sub Command47_Click() On Error GoTo Err_Command47_Click DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70 DoCmd.Close Exit_Command47_Click: Exit Sub Err_Command47_Click...
  6. C

    acClose form, Msg VBy/n

    Hi again, I am looking for a simple alternative to my problem... When you close a form in accees, the form saves auto. Is their a way to generate a bit of VBA where, on acform close , msg vb y/n, If no then exit and clear contents of form, do not save and do not pass go. If yes, carry on...
  7. C

    acClose form, Msg VBy/n

    Hi again, I am looking for a simple alternative to my problem... When you close a form in accees, the form saves auto. Is their a way to generate a bit of VBA where, on acform close , msg vb y/n, If no then exit and clear contents of form, do not save and do not pass go. If yes, carry on...
  8. C

    Sub Form Auto Save Disable && || clear subform field values

    Hi, I have a subform within a form. The subform only displays depending on a value in a field (combo box). Private Sub chsAct_AfterUpdate() If (Me.chsAct = "Appointment") Then frmAddApp.Visible = True Else frmAddApp.Visible = False End If End Sub This works fine, except, If i go back to the...
  9. C

    sub form scroll OR sub form resize?

    Hello, I have a bit of a wierd one. I have a chase form, where you enter the CONTACTS detail (select name from combo, data, notes, chase). I then inserted a sub form that shows all related chases to the CONTACT ID not the CHASE ID, so i get a nice list of all previous confos when typing in the...
  10. C

    onNotInList combo ->> open form x

    the error message i get is that the field cannot contain a null value, well y is it doing it on this one? the other combo boxes do not give me the same problem.... I should add that their i a relation ship here, but i have not completed the form or set it to add the record, so it still should...
  11. C

    onNotInList combo ->> open form x

    Sorry to bug you all again, but i have a little tweak i want to make to one of my forms. I have used a not in list event to call this vba -> Private Sub jobTitId_NotInList(NewData As String, Response As Integer) On Error GoTo jobTitId_NotInList_Err Dim intAnswer As Integer Dim strSQL...
  12. C

    combo box, make .visible when combo field selected

    thankyou :)
  13. C

    combo box, make .visible when combo field selected

    Nice and easy one for all those pro's out their. I have a form which has a hidden combo box. I want this combo box to only be displayed when 1 of 2 values in an other combo box are selected. So far i have made default for combo box to .visible = false, and in combo box one selected after...
  14. C

    Microsoft Web Browser http 404 error

    Hi, I have implemented access web browser into my database to display a companies website > Private Sub orgURL_AfterUpdate() On Error Resume Next ' If the user has entered an address (URL) in this control, ' attempt to navigate to the address. If Len(Me!orgURL) > 0 Then...
  15. C

    Converting case type

    Sorry i am not that good with VBA, How to i switch from the set vbUpperCase to accept one of the variables? Public Sub ConvertCaseType() vbUpperCase = 1 vbLowerCase = 2 vbProperCase = 3 If IsNull(Screen.ActiveControl) = False Then Screen.ActiveControl = StrConv(Screen.ActiveControl...
  16. C

    Converting case type

    hi peps, I have a function to convert case type to either upper, lower, or proper - Public Sub ConvertCaseType() If IsNull(Screen.ActiveControl) = False Then Screen.ActiveControl = StrConv(Screen.ActiveControl, vbUpperCase) End If End Sub Is it possible to put vbUppercase as a...
  17. C

    In subform, use a command button to open form

    yup, that worked thank you :)
  18. C

    visible if field is not NULL

    Hiya, i fixed my problem with using a openform button to display related results. But i have found a new problem. On the subform with a parent table, the command buttons are displayed for all sub records, this includs adding a [auto number] / auto record for new records. Is there a way so...
  19. C

    In subform, use a command button to open form

    'These variables are the mirror variables for the fields 'to be tracked in the Table. They are set every 'time a record is fetched, and reset after a history write. 'They are referenced in the BeforeUpdate or AfterUpdate 'procedures to determine if a field was changed. To do the above task...
  20. C

    In subform, use a command button to open form

    hi, Private Sub Command43_Click() On Error GoTo Err_Command43_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmAddCnt" DoCmd.OpenForm stDocName, , , stLinkCriteria Exit_Command43_Click: Exit Sub Err_Command43_Click: MsgBox Err.Description...
Back
Top Bottom