Recent content by BruceJackson

You can refer to a form in the criteria line of a query: =Forms!frmForm!OrderNo Spot on! Thankyou Remou

How to activate a Query using the current Form Record as the criteria? EG: looking at order no: 012345 in the form and running a query to append this order and other related data into a different table without the need to type in the order no. Any ideas please?

I would like to be able to be able to include a pick list in a parameter query rather than having to enter the exact value from memory. Any ideas please?

Starting with Sage Line200 and Sage Enterprise: can anyone suggest any other ERP systems that are SQL based?

Is it easy to explain how to: "... distribute the FE via a Batch file. The user clicks on the batch file icon on their desktop, this copies the FE to their hardrive and opens the FE from their hardrive." I am assuming that the user runs the batch file every time they access the database and...

Hi Phil4tektips, I have several other databases, some with links to our Sage Line200 Database. Eg: Production Scheduling linked to Sage. Data prep for bespoke product import to Sage. Reporting databases linked to Sage. etc By splitting the database, I assume you mean having the tables in a...

We are based in Derbyshire where the Design Master is held on a server and we have users from another site in Scotland and 3 "out-on-the-road" laptop users. A split database is hopelessly slow over the network. The database is a Project Management database similar in functionality to Sales...

Hello Trevil Do you see any problems with the way I have dealt with this? 1. Created new dbs with new Module 1. 2. Imported queries, forms, macros from latest good copy of Design Master. 3. In latest good copy of Design Master, used make table queries to create copies of all tables excluding...

Need much more help please! I have taken a recent copy of Master and pasted into it's original position on server, then changed it's namr to what the Master was originally called but... Macros are working but not from forms. When I click on a Macro on a form, I get: "Invalid Data Format."...

I make a copy of the Design Master by right-click, copy and paste. The copy is named as type "Replica" and I am prevented from making changes. Is copy and paste the correct method of making a "copy"? Or are you saying that the copy of the design master can be restored when necessary to be the...

If I make a copy of the Design Master, it becomes a replica?

What is the best way of backing up a Synchronised Database to enable recovery when the Master Copy becomes corrupted.

Lost module in Design Master and Macros now not working. I can not see module 1 in the Modules tab and, although the Macros are still there, they are empty. Any sugesstions please?

I am very well Mr Man1 but I need a little more info on getting to FileSystemObject & CreateFolder Method

Need to be able to click a button on a form to automatically create a new sub-folder in a main folder on our network and name it as a field value in the Access form. Also needs to insert a hyperlink into a field on the form. Any ideas anyone? I have a button that goes into a network folder to...