Search results for query: *

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

I have a macro - M1 with a macro nested within it - M2. M2 runs an Append query. I want M2 to repeat an infinite no of times until a condition is met. The condition is a query field returning a specific value "0". How do I do this in M1 using the Repeat Expression box for the M2 macro? Many...

I have created a Macro to email a report and included it in Autoexec macro - can the message box where you allow the email to go ahead be disposed of? Ideally, I would like to enable the Access DBS to automatically email at a set time 5 days a week without the need to open the database. Any ideas?

Problem solved. I went into the "Password-Protected" ? database via the hyperlink in the other dbs and then exported each object into a newly created Access Application. I will not use hyperlinks to get from one Access dbs to another in future. Not sure why it had happened but I am sure that...

I have not set a password for any of these databases.

I have an Access database on our server that can be opened direct from the folder it sits in and by hyperlink from another Access Database. This has worked quite happily for many months. However, the database will now only open from the hyperlink in the other database. If I try to open it...