Search results
-
T
Runtime errors after office 365 version update
It was in this bit of code that produced the 94 error, but only on the new build. Does not occur on the old built, or any previous version... Dim holder As String Dim n As Integer Dim length As Integer Dim temp As String holder = Me![Dam] If holder Like "*(*" Then length =... -
T
Runtime errors after office 365 version update
Yeah, I can do the exact same thing in the old build and the error is not flagged. The 94 runtime error occurs when leaving a space to start a field and then leaving the rest blank and exiting the field. But only occurs in the new build version, as I tested it to see!! -
T
Runtime errors after office 365 version update
Suddenly getting some runtimes errors on a couple of access applications that have been in use for a long time with no issue. They have only started appearing after updating to office 365 Version 2305 (Build 16501.20196) from Version 2304 (Build 16327.20248) Runtime error 94 and 3024. The... -
T
autocomplete on my forms stopped working
These are not ticked, but then they never have been in years of using this database and it has all worked fine. Thanks -
T
autocomplete on my forms stopped working
I really need help! Been forced to update to Windows 10 1903 build yesterday and my forms in access no longer work as they should. I copy and paste a lot of data into fields with look up tables and previously the fields would autocomplete when pasting half the word in (i do this to check if... -
T
help with duplicates query
In the end I came up with the following in a simple select query. Seems to work nicely and allows me to delete... SELECT [Horse Sub Table].[Horse Name], [Horse Sub Table].suffix, [Horse Sub Table].yob, [Horse Sub Table].age, [Horse Sub Table].[Sire ref] FROM [Horse Sub Table] WHERE ((([Horse... -
T
help with duplicates query
Is there then a way to allow records to be deleted from those returned results? Option is greyed out, I guess because of the join between query and table to produce the desired data? -
T
help with duplicates query
Could someone please help me with the following? I have a horse pedigree database where some data has been duplicated. I can currently find and list the duplicate rows matching one criteria with the below (I want the individual rows listed rather than just a 'number of duplicates' column as...