Search results

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

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

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

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

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

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

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

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

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

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

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

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

Hi, I have a chase system that i want to integreat into my db. On the chase form you put in fields, on the combo fields i want a action performd. So after update IF ME.combo Value == value1 do this. By this i want it to open up the form according to the value selected (Would a subform be good...

hi, Sorry if this thread seems to "layman" for you but i am new to vba and access. OK here is my newest inconvience. I have built a custom log in form i access, The user names and passwords are stored in a table. When one of the user names selected and password is true they are able to see...

Hi, sorry but i have a new issue. Ok, here it goes. I have a check box on my form that "black lists" that related record. I wish to warn the user that when they click/after update the check box, they will no longer be able to work with this contact unless an administrator unblocks the record...

Hi, sorry but i have a new issue. Ok, here it goes. I have a check box on my form that "black lists" that related record. I wish to warn the user that when they click/after update the check box, they will no longer be able to work with this contact unless an administrator unblocks the record...

Hi, I have a form with several yes/no boxes (set up as TRUE or FALSE in the table). I want to place a command button, that if i click it, all the check boxes i want to be populated with the value of TRUE, populates them. I was attempting to do this through the expression builder. Would doing...

Hi peps, Sorry to post this thread if it has already been answerd, but i have not been able to work out what i need through general forum searching and google searching. Ok, here is my problem. I am designing my data base to include a chase system (phone call log if you will). I built a log...