Recent content by Jaye7

I worked it out, I need to import the Orders table into my backend as a linked table then change it's name to AdminOrders and do the same for the other backend that I will be relinking to.

Currently I have a script which changes my linked tables from one location to another and it works well. The problem I have is that I have a table in one back end named Orders and I linked it into my other database and changed it's name from Orders to AdminOrders, as we already have a table...

Thanks, I was getting an overflow error when I tried to re-run it in another database, I will check the code out when I get back to work on Monday.

I found the following function on the net to calculate hours between 2 dates (EXCLUDING WEEKENDS). The problem I am having is that it is returning 44 hours between the following dates where it should be 20-21 hours. StartDate: 29/04/2016 2:54:53 PM EndDate: 2/05/2016 11:18:21 AM Looking at...

Sorry Cronk, that doesn't work either

Thanks arnelgp, I tried a similar script previously but it didn't work, the user and password dialog box appears with no value in the password.

Thanks for your reply, It does work if I import the form into the database but what I am trying to do is copy the form from an open database to around 12 other databases without having to open them all.

I am trying to run a macro in a password protected database, however the script doesn't actually enter the password in the password section so unless I manually key it in I can not open it. The password is correct. Sub Test1() Dim app As Access.Application 'Start a new MSAccess...

I am trying to copy a form from one database to another PASSWORD protected database. The following will open the database but I get an error as the file already exists. Runtime error 2007 - you already have a database object named frm_Utilities. I tried the Docmd.transfer method but it always...

Because I am going to delete numerous forms from up to a dozen different databases, when you have code you don't have to do things manually, I would have my car drive me to work if I could write code to make it do it.

I have the following script which works if the database is open, but if it's closed then I need my password. Dim objAcc As Access.Application Set objAcc = GetObject("X:\Test1.mdb") objAcc.DoCmd.DeleteObject acForm, "frm_Utilities"

I have been searching for a script to delete a form from another password protected database and I have found scripts to delete tables but not forms.

Thanks for your help, much appreciated

Hi jdraw I already have a script that lists all forms controls etc..., but I wanted to only list the loaded forms and subforms. I can use the current one I have and look through it for the subforms, but if someone could provide a script it would save time, as some forms may have up to 10...

I have the following script which lists loaded forms and the controls sources. What I would like is to list the loaded forms and there subforms control sources. Public Sub ListOpenFormControls() ' Read control source property of all controls in all forms. ' Note.. the debug window may not be...