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 =...
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...
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...
In my database, I have a public declaration which defines a location or place. This is normally restricted to one location and there is not often the need to change the location onse it is set. However, being only human, users might mispell their location and need to change it. I use this...
Ken
My table tblLocation is restricted to one location name. Hence, each branch or location will have their own database. Once entered, it should not need to be changed again. There may be up to 200 branches, but each database will stand alone and will only relate to the branch where it is at.
In my database I am creating, I have a form that open on startup, which contains a warning to users about breaches of confidentiality etc (frmStartup). There is a field in this form that contains the branch name of the company. If this is blank or contains "XXX" then a further form will popup...
In my database I enter data through a form. I want to be able to list items in the database using a query, and from this query I have created a Tabular Form which will display each record. These fields are protected and cannot be edited in this form.
From this tabular form, I have added a check...
Hap
Running Office XP and Windows XP.
I might have fixed it accidentally. I had an exit button on my menu form that I got rid of and it seems okay now. Shall experiment some more.
Thanks for your help.
pd
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.