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...
View RepliesWhen 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.
View 1 Replies View RelatedHi everyone and many thanks in advance.
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.
Many thanks,
Dominick:confused:
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.
Is there some way to turn this off?
When I try to do a spell check in a Form by pressing F7 I receive this error:
Can't start the spelling checker because it isn't installed.
How do I get it installed?
Thanks!
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.
This is in Access2003 BTW.
I have 15 fields beginning with the word Comment. (i.e. comment, comment1, comment2 etc)
What Im trying to do is create a spellcheck command button that will only check these fields and only on the current record.
I've managed to find this piece of code to do the actual check:
With Me.FIELDNAME
.SetFocus
.SelStart = 0
.SelLength = Len(Me.FIELDNAME)
End With
DoCmd.RunCommand acCmdSpelling
Question is, how do I get this piece of code to loop through any field beginning with the word 'comment' and check their spelling?!
Any help would be much appreciated
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?
View 3 Replies View RelatedIf you look at the attachment in access settings it says it is set how to auto correct and "INDICATE SPELLING".
in my forms/tables/queries... it will not bring up spelling mistakes or the sort.
I am trying to make a checkbox with different graphics since the checkbox can not be resized. I thought I could stack images on top of each other and toggle between showing and hiding based on if the checkbox was checked. This actually works, but I wanted to hide my checkbox, so I hid it behind my images. This didn't work. So I brought it to the front and made it invisible. This didn't work either. What can I do? The checkbox is linked to the table, but I want the graphics to show thumbs up or down and not see the checkbox.
View 4 Replies View RelatedHow I can create a Multivalued Lookup however with an add values option?
View 8 Replies View RelatedI want to use information supplied to me by suppliers as spreadsheets to create a database that i can navigate through by selecting from drop down options.
Example;
Imagine a product being broken down by its features, such as a washing machine.
Here is a list of what i would need to sort on,
Manufacture
Model
Type
Size
Price
Colour...and so on
So, if a customer asked "what 8kg 1200rpm washing machines do you supply for under £300 and in black" i would like to able to find all that info by drilling down a few selections.
Windows 8.1, Access 2013, Microsoft Office 2007 , Access 2007 uninstalled When I try to open Options from File, I get the Windows Installer box open up, Preparing to install.......wait while windows configures Microsoft Office professional 2007. File Options was working before!
View 4 Replies View RelatedId like to create a search field on a form, with a similar function to the standard Access 'find and replace' function. Only id like it to be alot more simple than the Access find and replace form.What i have is a Asset DB for the IT assets in the company i work for. We have a lot of phones, printers, computers and about 120 Laptops. The laptops are quite often reconfigured and given to new users, so the laptop details dont change but the user and software config does. I need to keep track of what software is installed where, for licensing reasons.
What i have is a simple form with the laptop name, serial number, operating system, software, location etc etc. What i would like to be able to do is, type a laptop name into a Txt field, hit a search button, then have the fields of the form populated with the laptops current config and then be able to edit the details from inside the form. ive tried using a combo box but i have more than 20 fields that need filling, so anybody whos used the 'me.txtboxname.value = me.combobox.column (1)' may know that you can only use 20 columns.
The default Access 'Find and Replace' system works fine but i dont want users to have to use it. I also dont want them to have to navigate through records using record selectors.
I have a drop down list to select a committee, but my list is only showing half of the list. There's no scroll bar, and when I try typing in one of the others, it tells me it's not on the list and asks if I would like to edit the list. When I select edit the list, it shows all of them.
View 2 Replies View RelatedWhat I am trying to do is create a master table which references the every other table.But the primary key references another primary key.I can get the combo box to display all the options, buy shows options already selected for other records.in other words...
I have 4 reference IDs from table A.
(ID1, ID2, ID3, ID4)
Master_Table has a combobox to select between the IDs.
if record 1 has ID_1
Record 2's combobox will show all 4 IDs
If I only have 1 ID that can be put into record 4, it's combobox still
displays all 4 IDs.
What I want is: If ID3 is selected for record 1, it wont be displayed in the comboboxes for the other records.
I am new to MS Access. So I am making a database for an automobile warehouse. When a new car arrives at the warehouse, it is allocated a specific parking slot (using a combo box available on the 'New Arriving Car' form).
However, once a specific slot has been allotted, the end-user should not be able to allot the same parking slot to other arriving cars, until the original car has left the warehouse so that the parking slot becomes available once again. Currently, the parking slot combo box shows all parking slots whereas it is supposed to display only unoccupied parking slots. How can I enforce this? (Note that there is a separate form called 'Exiting Car', which is filled when a car is leaving the warehouse).
Fyi, each car is referred to by a unique 17 digit code - so this is the primary key. Also, there are 120 parking slots available in all, with the slot identifiers ranging from A1, A2...A12 to J1, J2..J12 (10 x 12 = 120).
I haven't done any testing yet on splitting the database I'm working on but a question came up today about networking.
This database is going to be used by a few equipment operators to record machine readings on the manufacturing floor. There is a wireless network and we are in the process of confirming that the wireless signal reaches all the areas. The users will be using ruggedized windows tablets to enter the data.
The BE of the split database will reside on a network drive to ensure everyone that needs it will have access and it will be regularly backed up. etc.
Since there is alot of heavy machinery, there may be some spots where connectivity will be weak or non-existent while they are entering their readings.
The question is how will the runtime FE handle it if connectivity is temporarily interrupted?
In Microsoft article 291264, it says "In a run-time application, the front-end and back-end databases must be stored in the same folder."Is that really true or am I misconstruing the article?I want to use runtime clients with a split back end on a share drive.
View 2 Replies View RelatedI have created a db in which the front end has been distributed around the office and opened in runtime. The basic function of the db is to track current projects and contact between ourselves and clients.
When we have update meetings we use the large screen TV to view the db but it only takes up one small corner of the screen and is near on impossible to read.
I would like to know if there is any way that the picture can be stretched to fit the screen that it is being displayed on? Or would I have to create a separate version for the large screen so that people can read?
I'm getting sick of Access 2013 constantly doing this. I convert a macro to VBA form the ribbon menu then it doesn't run!
I've uploaded a screenshot of the latest error to irk me. This ran perfectly well as a macro but since i converted it to vba. (cos somethings i can do easier in vba than in macros) it doesnt run.
Access 2010 on both Windows XP and Windows 7..I have an application which USED to use a postcode address utility that created an Activex. I have removed all references in vba to the utility but Access runtime gives an error 'cannot create Activex' on my clients PC's (both with Windows XP and Windows 7).On my own PC the error does not show with either full Access or simulated runtime. I have tried decompiling the database and even using the old trick of copying the modules code into Notebook and pasting back, but to no avail.
View 4 Replies View RelatedI have a Access front end connected to a MS SQL database using a ODBC connection which is working fine of course.
When I compile it as a runtime version and install it on the business computer I get an error with the ODBC connection (I can't remember exactly what pops up). On the business computer I have installed SQL Native Client and in the ODBC added a System DSN (which works).
I'm creating an item look-up form with 2 criteria that I wan't to auto-filter as the user types. I'm placing my code in the Change event of the textbox, and only calling the .text for the current textbox (.value or no property at all for the other). The filter works smoothly and as intended until it returns no results in my table, and then it pops me with the error. I've tried forcing focus to the textbox in different places throughout the code, but to no avail. If I use the .value or no property for the current textbox, I'm not getting the CURRENT text, but the old text before it was changed, so the filter doesn't work properly.
Private Sub txtVendor_Change()
Me.FilterOn = True
Me.Filter = _
"((strSearchVendor Like '*" & Me.txtVendor.Text & "*' AND strSearchItem LIKE '*" & Me.txtPartNum & "*'))"
Me.txtVendor.SelStart = Len(Me.txtVendor.Text)
End Sub
It usually pops the error on the last line "Len(Me.txtVendor.Text)", but I've had it do it on the Me.Filter line as well (only when debugging and messing with next statement placement).
My office recently purchased Microsoft Access for our secretary to keep track of our contacts. No other employee owns Access so we have to distribute the tables through Access Runtime. However, there seems to be a problem.
I save and publish a database using the Packaging Wizard. I then send the associated folder with the install program to a computer which has Access Runtime installed on it. But, when I install the file I created with Packaging Wizard it just opens an Access window that is completely blank. It's actually the same thing that occurs when I try to open an Access file on a computer that doesn't have Access or Runtime installed on it at all.