Search results

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...

Hi JHB, I won't have access to the file for a couple of days, I will modify it and get back to you, thanks.

Hi, As explained in my first/original post, the change event will not work.

I can, but it doesn't help with the fact that the date they want is different so they select the date picker for tomorrow etc... and access still see's it as having focus until you manually tab off it, sendkeys to tab off don't work either, as it just refuses to see it as changed or to remove focus.

The back button is just a command button that when pressed closes the current form and opens another form. There is no error with the back button, even if I just type code like msgbox "hello" the focus stays on the date picker textbox until you tab off it or click the back button twice, but...

I have a textbox on a subform which is a date picker textbox. On the main form is a back button which takes you back to the previous form. When you manually enter a date into the date picker textbox on the subform you can click on the back button and it will take you back to the previous form...