Search results

Thanks Smig, That is a great improvement and will be very handy.

Thanks for you help. I didn't realize that the following should be in the referenced database. Public Sub OpenReferencedUI() DoCmd.OpenForm "Organizations" End SubAnd then in the current database just call the script and everything works from there. OpenReferencedUI

I referenced another database in the references and then when I first opened a form from the referenced database it opened, but once I closed the database and reopened I keep getting an error 2102 the form name is misspelled or doesn't exist, yet it clearly exists. I have removed the reference...

I have stopped the code and that is also why I sent the code to the form textbox to ensure that it was correct. I can copy the code directly from the form textbox into an existing shortcut or a new manually created shortcut and it works perfectly, but removing quotes etc.. and it will fail...

Thanks but it actually needs all of those quotes for the shortcut to actually work when you paste it into a manually created shortcut, that is what I based the TargetName on, the actual manual shortcut path that works.

TargetName is a string within the script and it doesn't work either. TargetName = """C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE""" & " " & """X:\FrontEnds\User Databases\TheBrain " & .Column(0, lngRow) & ".mdb""" & " /wrkgrp " & """X:\KLIKTUBE.mdw"""

I am trying to use the following script to create hundreds of shortcuts. However I am getting a runtime error 5, invalid procedure If I remove the TargetName from the line that errors and use "X:\Master Front Ends\TheBrain JT.mdb" it creates shortcuts, but obviously they would all have the...

Access 2007 and 2010 won't run in 2013, when you try to open the database it gives an error message saying something like "can not open a previous version"

Thanks for your reply. I would prefer to stay with 2010 but unfortunately my boss wants to update to 2013. We have some databases that were made in the 2007 version, which we have to update to 2013 as well. Around a dozen front ends and a dozen back ends. At least the back ends are easy...

Thanks for your help

My boss wants us to upgrade Access on our terminal server to Office 365, however it doesn't support the current version we are using which is 2010. Does anyone have any suggestions on an easy way to transition from 2010 to 365 (other than don't bother). I tried a similar exercise in converting...

Sorry for the late reply, unfortunately it doesn't help with this problem

I often move sub forms up and down within a form using something like. forms!MyMainForm!MySubform.form.top = 500However, I am having trouble moving a subform within a subform of a form. Forms!MyMainForm!!MySubform!MySubformSubForm.form.top = 500

The database is an .accdb

I added the themes buttons to my quick access toolbar but then they are greyed out so I can't do anything (the form is in design mode).

We are using 2010 unfortunately.

Is there a way to permanently set the alternate row color in access, so that whenever you create a form it will always be what I want. I know that I can make a template and always use the template, but I would prefer to just change the access settings if that is an option. I checked the access...

Thanks for replying. I don't like having to do anything manually, I would write code for my car to drive me to work if I could as I don't see the point of having to perform meaningless tasks if there is a smarter way.

Thanks for replying. I am looking for code to do this though so that it is automated. The relationships are causing a problem, maybe I need a script to simply make copies of the linked tables and then delete the linked tables. But possibly I will still have the same problem when deleting...

I have the following script that either converts a single linked table to a local table or ALL linked tables to local tables, however I am getting the following 2 error messages on several tables for the ALL tables script. error 3709, the search key was not found in any record Error 3300...