Search results for query: *

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?

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?

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?

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

Can a running sum field be created in a query? I need to be able to create a field which adds 1 on for each new value. Eg: 900001 900002 900003 900004 900005 Users need to be able to specify a starting number such as "900001" and specify how many records required. In the example above, "5"...

I am trying to use the DSum function in a query but having limited success. I want to calculate the total Cost of Sales (COS) for the most recent 3 completed periods. The query I am working with shows the COS for each period. Although the period is a text field, I have a corresponding month...

We have multiple users using a number of Access databases that are sitting on a central server on my site. We are having severe speed problems for our remote users - other sites hundreds of miles away. We do not have Access installed on the server. If we did, could this help to aleviate the...

Database is on a server in Matlock (Approx 15MB and growing). Accessing it from Scotland is disastarously slow. Both sites have a frame relay. Is there anything that can be done in the database to improve speed? Tried creating a data Access Page but we lose the drop-down options in the fields?!!

I can print selected record on a form using a macro but how can I print in landscape automatically.