Search results

We are a small Division of about 50 users of a much larger organisation. We have been happily using Access across our network by splitting the database, having the tables in a shared network area and installing the front end on every users PC on the C drive. None of our users have the full...

It's OK, I have cracked it! (had a road to Damascus moment). Would delete this thread if I could

Well I have managed to work out how to create the correct number of blank records using WHILE and WEND, but the incrementing date issue still has me stumped

I am writing a database to record the number of Health and Safety checks made in our building. There is a list of the checks to be done held in a table and at the beginning of each financial year the frequency of these checks is set. So, for example, for year 04/05 I may decide to do 5 emergency...

Hi Rich, where would I get this from please, I only seem to have the northwind one

Nice idea but unfortunately the report is 1800 pages long

I have a large report of a couple of hundred pages. What I want is the first page to print on headed paper, next page on plain, next page on headed etc. etc. As an old DataEase hand I could do this by embedding a print command in the actual document layout that the printer would recognise as a...

Thank you Pat, right once again!

I am trying to write a simple system where staff can apply for leave. On the table where the dates are recorded is a field to record the approval that is initially blank. The staff manager has a continuous form built around a query that looks for all the records where the approved field is null...

I might be asking too much here, but here goes. I have staff who use Access to record details about clients' accounting systems. They also often draw flowcharts of the system using Microsft visio. I would like to have a "CREATE DRAWING" button on the input form that would allow them to open a...

Don't know if this is a any help, but if I want just the current record to print on a report I put a button on the form and then have the on click event do this: 'first save the record to reflect any changes made DoCmd.RunCommand acCmdSaveRecord 'then preview only records that match the...

I have a table with client details, each client having a unique number. I want my users to be presented with a simple input form where they type a client number in (probably use a combo box). If the number already exists then I want the user to be taken to a form to modify the details, if it...

Sorry JON, missed the >= out when I typed. I have tried this but still get wrong data back, it gives the equivalent of putting in say "3" as opposed to the number 3

I am trying to work out the number of years since a client was contacted using the expression below in a query where [lastcontact] is a date field. contact: ((Date()-[lastcontact])/365) This works fine until I try to put a criteria on it. If I want to see all those that it has been 3 years or...

Me too! Yes please

Well, don't I feel like the proverbial horse's backside! Had a look at the table and the indicator field has a default value of 0. Changed the criteria from not isnull, to =-1 and it worked a treat Many thanks for the code however as even my original attempt wouldn't work with =-1. Lesson...

It's a single form. When I tried the code you suggest the requery seems to get the form stuck into a continuous calculation loop

I have a form that includes a yes/no tick box (field is called [dm_wo_ind] in the code below) that is completed when a case has been finished (this is done via an update query). If the tick box is completed, then I do not want some of the fields on the record to be subsequently enabled. I have...

"Why not just query the customer table". The customer table holds up to 7,000 customers names but not all may have placed an order