Hi I have sendkey "{f7}" on loss focus. this works great as a spell check but then I get the mesage box that spell check is complete. How do I stop this box from occuring?
We need to enter the string INCL as a data value in one of our tables. When we try to exit the field, Access keeps changing it to INCLUDE. This occurs whether the value is entered via a form or directly in the table. I assume it is doing some type of autocorrect based on th spelling. There is no VBA code associated with this field.
How do you make the spell checker not cycle through all your records when you run it? As it is right now, when a user tries to spell check their entry into the summary block of my form it automatically starts with the first record in the database and goes from there.
I have a subform in datasheet view. I would like to put a button on the mainfor that checks all the subform records for spelling mistakes. Is this possible?
I have a Access 2010 database running in runtime. What options do I have for spell check? I can bind to a 2010 Word spell check (if it is installed), but could I do a late bind to utilise any other office spell check? Tried to use a .net spell checker dll and get access to call out the text and get returned the errors? Not sure what options I have really...
I have configured my Access 2007 DB/app to hide the default ribbons and Options settings so that end-users cannot change the config or perform tasks that would jeopardize the integrity of the data. One of the other requirements on this project is to allow the end-user to launch the Spell Check feature.
It was simple enough to launch Spell Check from a button on a form. The problem lies in that the Spell Check feature has an "Options" button that serves as a point of entry to the Access Options that I'm trying to prevent the user from seeing.
Can anyone tell me how to hide or disable the Options button in Spell Check? I fear that this is not possible and I will have to choose between Spell Check and ensuring data integrity.
When distributing a program using 2010 runtime, I find that the spell check doesn't work. Is there a spell-check .dll or is there anyway I can get a spell checker?I have several memo fields with long report-type data entry which is being keyed by mutants. Spell checking is essential to get an intelligible report.
I have run into an issue with a basic DLookup. The database has grown in size and now we could have multiple entries, but I want it to return a certain one. So the information could be in it three times. Of course DLookup stops after the first one. How do I get it to loop to check the entire table? Someone mentioned to me to use a recordset, but how to write that as I have never used it before. Below is what I was using until this new request came up.
<code> Private Sub txtloan1_AfterUpdate() If IsNull(DLookup("[loan1]", _ "settlement", _ "[loan1]=""" & Me.txtloan1.Text & """ AND [status] = 'Open'")) = False Then Cancel = True MsgBox "Test", vbOKOnly, "Warning" End If End Sub </code>
This was also executing after the user entered the information within a text field. I did not want them to enter all the data and then have it come back as a duplicate.
I have a subform for which I want to loop through all the records and then copy one of the fields for each row into another sub form.
I came up with the bellow code but i get an error when I run it.
The error is an "error 438".
Code is at follows and I am copying the field called price:
Do Until Forms![Roll Out - Site Form]![Roll Out - Sign items pick list].EOF [Roll Out - Sign items added].Form![Price] = [Roll Out - Sign items pick list].Form![Price] Forms![Roll Out - Site Form]![Roll Out - Sign items pick list].MoveNext Loop
the below code works fine if i run a crosstab on a whole table however if i pass criteria to the crosstab e.g between [forms]![form]![txtstartdate] and [forms]![form]![enddate] it fails and returns null for every field? even though if set docmd.runquery "qryReductionByPhysician_Crosstab" this opens with the relevant data?
Code: Set db = CurrentDb Set qdf = db.QueryDefs("qryReductionByPhysician_Crosstab") indexx = 0
Hi firstly I want to say I am not a programmer or anything like that, I know enough about Access to get me by with simple things but after that i get a little stuck so please dont baffle me with loads of technical coding terms :D
Ok..I have a database with a form where the users enter a subject and description. I have a spell checker running on these 2 fields which works fine up to a certain point. If the users goes in, adds a new record, tabs off the field, the spell checker runs, etc then it works fine. If the user then creates a new record and it picks up a spelling mistake in the new record it jumps back to the previous record that was created and spell checks that again.
If you close the form and open it again before creating the second record it is fine. Could anyone possible shed any light on the situation? Below is the code that I am using (found it on the internet somewhere)
Private Sub Description_AfterUpdate() 'If the textbox contains data run the 'Spell Checker after data is entered. If Len(Me!Description & "") > 0 Then DoCmd.RunCommand acCmdSpelling Else Exit Sub End If
End Sub
Private Sub Description_BeforeUpdate(Cancel As Integer)
End Sub
Private Sub Subject_AfterUpdate() 'If the textbox contains data run the 'Spell Checker after data is entered. If Len(Me!Subject & "") > 0 Then DoCmd.RunCommand acCmdSpelling Else Exit Sub End If End Sub
I'm trying to get a spell check to work on a text box on a form. i've got it popping the spell check window after the box has been updated but i'd prefer it to just highlight the errors in red, rather than pop the spell check box. another problem i'm having is when it's finished spell checking the box it moves the form back to the first record. this is the code i'm using.
Code:
Private Sub txt_notes_AfterUpdate() If Len(Me!txt_notes & "") > 0 Then DoCmd.SetWarnings False DoCmd.RunCommand acCmdSpelling DoCmd.SetWarnings True Else Exit Sub End If End Sub
I'm new to this forum and already I've got a question.
I'm made a form and a subform. I placed a field called 'status' in the form and in the subform I placed a field called status_subform.
If I've changes all the status_subform into a certain value I would like the status in the form to be updated. I tried a lot of things with recordsets. I can find the number of recordsets, but I can't scroll through the recordsets, can anybody help me?
i managed to get checking for duplicate record by ONE field ie member_no
code :
If DCount("*", "runner", "member_no = " & Me.member_no) > 1 Then MsgBox " This member is already exist!" & vbCrLf Me.c_memberid.SetFocus Else DoCmd.CancelEvent End If
how i want to get checking duplicate record by TWO fields ie member_no and run_no ?
I have a repair database which I'm working on. On the main WIP form there is a subform stating the faults which have been logged against that unit. The unit can be scrapped at any time by hitting the SCRAP button, but if the unit has had it's faults successfully repaired, then it can then be FINALISED which means it can be shipped to the customer.
I need to be able to check the records in the subform, to look for faults which have not been repaired. When they are repaired, the text "PASS" will be present in the TEST_RESULT field. I want to be able to check the TEST_RESULT field for each fault to ensure they are all a PASS before I allow the unit to be FINALISED. Any ideas how I can do this? Or am I taking the wrong approach?
I have a form with datasheet view and I need to make user that user fills in all fields before he moves on to the next row. how to catch the moment of moving to another row?
I tried to check if all required fields have been filled before saving the record using the following code.
Private Sub txtReportNo_BeforeUpdate(Cancel As Integer) If IsNull(Me.cboMainCat) Then Cancel = True MsgBox ("Please enter Data for Main Cat") Me.cboMainCat.SetFocus End If Repeat above code for all required controls here. End Sub
It did not work with following error code.
Run-time error 2108
You must save the field before you execute the GoToControl action, the GoToControl method, or the SetFocus method.
The error message contradicts my original intention that prevents from saving without all required fields have been filled. Is there any way to get rid of this error message?
In addition, under the value of certain field, I need to check additional fields under that scenario. Is any additional code required to add in for that purpose?
I am trying to use a check box to either grey out certain text field(s). For example If the box is checked true then certain fields would become available to input data. If the box is not checked it stays grayed out.
Allen Browne has an page explaining how to set up a database relationship of many to many using a connection table at the following link
[URL] .....
I can set up what he has done easily, but I want to be able to show the information much like the matrix he shows at the top of the page and also include in the query or form "sports" that no one has checked.
