Search results for query: *

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

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

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

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

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

Sometimes when I try to open the database I am working on, it starts to open by creating a (I think) temp file (the Access Icon with the lock on it) but that is as far as it goes. Once this happens I cannot get the database open without rebooting the computer and trying again. Then it loads. It...

I have a database and a form into which I input data. I have an unbound field which is a calculated future date base on the startdate field and the tenure field (in other words I need a date 2,3 or more years [determined by the tenure field] on from the startdate. Now I have the formula (using...

I have a database that, when it contains data, works fine. However, when the main form is first loaded to enter the very first record, it produces an error "Run Time Error 94 - Invalid Use of Null" I have a check box in the form that when checked means that record is completed and...

I want to populate a field from a date, to show a future year in anoter field on a form. I then want to be able to use this field as the basis for searches. I am using the formula =DatePart("yyyy",[DateTo]) + ([Years]+1) DateTo is the date I enter and I want to change this to the...

Would someone with more knowledge than I have a look at this code and see if they can see why it is not working. I have set up a form to search with 5 fields and the results of this are supposed to populate a list box on the same form. When I press the search button, nothing happens. Fields...

I'm not sure if this is the right forum, but cannot find information anywhere else. I have a form that has a number of columns diaplaying date from selected records. Column one is for the item name, which can sometimes be longer than the colum for that field. Is there any way I can word wrap...

I have a database in which I would like to enter the name of a location or particular office in a form that pops up on the first use or if no data/text has previously been entered. Once this is done, this form will populate the menu/startup form permanantly, and will not reappear in future when...

This question has probably already been answered but I can't find it so... I have a database with several tables and associated forms. In the main form, I enter most data and when I get to a field that has data from another table, I select from a list box. I would like to be able to search for...

I have a form that has check boxes indicating if a task is completed. I also have fields on the same form to input the date these tasks were completed. I want to make the user enter a date if the check box is true, otherwise leave blank and tab past date field to the next field.