Search results

A simple question... i think I have a whole string of queries that I need to run in order. So I created a macro that does just that. OpenQuery, OpenQuery, blah, blah When I run it I get a screen full of windows, so then I had to insert a load of Close commands after each OpenQuery. Was...

I have a database for credit collection. The main table is a list of invoices - invoice number, value, date, etc From that I produce an aging report, which for each customer gives a balance (sum of invoices), and then 5 aging columns (0-30 days, 31-60, etc) To do this I have 5 queries, one...

My database instructions continue... "before running the next 4 queries, go into design view and change the date in the criterias as appropriate" the queries generate an ageing of debtors for example the criteria are currently: query1 ">#31-Dec-03#" query2 ">#30-Nov-03# And <#01-Jan-04#"...

hey, im getting to like Access :) thank you

Simple macro (i hope) I have inherited a user-unfriendly database and am trying to make it easier to use and more robust Included in the instructions is the following: 1. open table xyz and delete all the records 2. run query update1 (its an append query that writes to xyz) 3. run query...

i presumably need to refresh the query each time the form changes any records

awesome so here are the follow-up questions :p 1. the customer table is in alphabetical order. when a new customer is added i want the table to re-sorted to keep the order correct. im guessing its a simple piece of code... 2. id rather ditch the record navigation buttons completely and...

Apologies for the low level of this query, but im just starting out! I have a table of customer details - customer ID, customer name, address, telephone, email, etc The customer ID is the primary key and is non sequential I am creating a form to update customer details, currently it is all...