Search results

I open a second database from my first one using the following code Private Sub Command14_Click() On Error GoTo Err_command14_Click DoCmd.Close acForm, "client action amended", acSaveYes Application.FollowHyperlink DLookup("[Link]", "links", "[linkname] = 'DebtProjector'")...

I have attached the link to the temporary site. It's probably easier to see than explain. When you open the site click on one of the nav buttons on the left. Instead of just opening that page it opens a new window with the website in it. All navigation then works OK. When you close it you close...

I have a new web project I am working on which I have built using Frontpage 2003. When I preview a page it opens the page in my browser window OK but when I then click on a nav button it opens the new page in another incidence of the Website all other pages then open normally in the second site...

I have developed a Debt Management program for work but I am stuck on a feature that we need to add to it. Basically I have a table which holds "planned future transactions". These are ad hoc transactions that need to be added from time to time to the clients budget. For example the client...

Solution Found I would like to thank The Doc Man and all others that tried to help with this problem. Turns out the problem was not related to Workgroups etc. it was caused by by something within the Office program loaded on the individual PC's. In each instance the client had a "hybrid"...

Hi Doc Man Further to my last message. The Database I am having the problems with is opened by clicking a button in my main database which runs the following code Private Sub Command14_Click() On Error GoTo Err_command14_Click 'MsgBox "Now opening the MAP Planner Program", vbOKOnly, "MAP...

Thanks Doc Man. Thats great having those steps as I can just make a new copy for these clients with those instructions and hopefully fix the problem. I appreciate your patience. Cheers Peter

I have not intentionally set any workgroup permissions for this database and just used the default settings as the program is mainly being used by single use Agents. Most of our Clients are not having this problem. I am more than happy to reload the database on the ones that are having the...

Thanks Doc Man. I compared Workgroup Admin settings on the Client PC and compared them to my PC where the database had been built. My System.MDW address is c:\Program Files\Common Files\System\System.MDW and on the Client PC it is c:\Documents & Settings\clientsrealname\Application...

I have a project that is made up of one main database supplying data to two other databases. Normally it works fine. I have installed it on some PC's belonging to our companies agents and in most cases it works fine as well. However, in some cases when one of the smaller databases is opened...

I know this is a little late for the original query but I found this answer on the MS site that may help others in the future with this problem. The fix involves a change to a registry key http://support.microsoft.com/?kbid=829072

Can anyone offer any answers to the above questions please?

I have a rather large project that has been developed in Access 2000. Generally all my distributions have been to PC's with Access available. However, I do find that there are a few that don't. Obviously this is where Run time would be useful. Having never used it I have a few questions if...

I use Excel to display some results from my database "Debt ProjectorXLS" the code below without the red text was used successfully to open the Workbook. However, I have some cells in the workbook that reference another workbook which wont update unless the other workbook "ProgressReportXL" is...

Thanks Neil. I found I should have using an append query for the task. Changing to that rectified the problem.

Appreciate some help on a update query if possible. In this query I wish to total two sets of figures in about five seperate queries and then export them to another DB. the Dsum function is fine and will produce a result but that result needs to pick up the record ID (called PlanID) which is the...

Thanks GBAT it sounds like you may have hit the nail on the head. I didn't think the & would be a culprit as it was contained within the name. I will change names and see what happens. Thanks heaps

I have used a version of the following piece of code several times to export some data into a subsiduary database and it works fine. I changed it to the following and I keep receiving SYNTAX errors. I have been over it with a fine tooth comb and can't see where the problem lies. The only...

Wow, it's never as simple as you think. Thanks for the response that piece of code will come in very handy. Merry Christmas

Just a quickie- i hope. :rolleyes: I am in the process of trying to merge two large databases. I have four tables that really should be one to work in the new DB. I just need to be able to print a list of fields in each table so that I can work on the new combined structure before making the...