Recent content by pd06498

Thanks Jeff Worked well...

I am trying to use the below code to count the number of files in a year, so that each time I add a new file (by adding the reported date) the database will allocate the next number in sequence. Private Sub ReceiveDate_AfterUpdate() Me.YearID = DatePart("yyyy", [ReceiveDate]) Me!LocalFileID =...

Thanks ChaZ Works like a charm. Dave

I've been experimenting with queries to return data on a weekly basis, using datepart and :First Full Week". I now have results that show data entered on 1st to 4th Jan 04 as week 53, then following on to week 1. What I was wondering is, what happens when I get to the end of the year and end...

ineuw Thanks for your reply. I may not have explained my situation well enough. When I navigate from main form to main form, I would like whichever tabbed subform on the main form that has focus, to maintain that focus but to reflect the relevant details of each employee. If I have tabs...

In the database I have created, I have a main form which contains some employee information. I also have, under this part, a tabbed form(s) that contains other information from the main table on several tabs, and some subforms on others. I have also created some of my own navigation buttons, to...

Yeah, but difficult to find anything that might help because I am not entirely sure what I need to do. Quite new at this, although have been palying around with my current DB for several months and am getting frustrated...

Thanks Stephen I have a Form that I enter the date and details of people handing over and receiving. Then, I go to another form that lets me progress through the dates and shows the subform records relevant for that date. I want the subform to show all the current unused and in-use records when...

In the database I am trying to put together, I have a series of records containing information on accountable records. I am trying to create, from these, a form showing the handing over of these records to another person. This form, as well as containing details about who is handing over the...

Bill Auditors check hard copies as well as the list of books on hand, which until now, has been recorded in a book. As new books are received at my workplace, they (or rather their information) is entered into the database. Information includes: * Type of book (what it is for) * Date Received...

Richard The books are provided to us by our agency for use, and we have to record them, including the start/end date of each book and the serial numbers in each book (or rather the range within the book). During inspections, the auditor merely signs off to say that he has inspected ALL books...

Richard Thanks for the reply. The inspection serial number is used when an audit is done to indicate where the book was used to when it was inspected. This is later used in forms that are signed of by the auditors. Audits are usually done each quarter or thereabouts. If a book is unused or...

In the database I am working on, I have a form that records the serial numbers of pages or forms in a book. For instance, a book might have pages 001201 to 001300. These numbers are unique and no two similar types of books or forms will have the same series of numbers. I also have a start and...

Edski I managed to fix the problem. A case of to much code in the wrong place. Thanks for your advice as it led me to identifying the problem...

I have created my database in Access 2000. In my database I have a form in which I have made my own navigate buttons. These work fine. When I load the form it goes to a new record, however I can navigate back from there to view old records. However, I want to convert the database to an MDE...