Search results

I am chasing a quick solution to what I am sure is a simple thing. In my database I have a table of items that have to be held for different periods of time (one item type kept for 5 years, another for 3 etc). In another table, linked to the first through the item type, I have dates entered...

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 form I have created, I have a combo from where I select an employee. Once this is selected, the subform in the form should show the list of training, and the dates the employee completed each. (The training list is only 3 records long and is the same for each employee, just the dates are...

This is probably quite simple, but I cannot seem to get a grasp of it. I have a form set up with two tabs on it. The first tabbed form lists all the employees in the database and is set as a continuous form. I have a select button for each employee in the list that I want to be able to click on...

I have a subform which is a continuous form. Each record contains 3 fields. In one of the fields, I have conditional formatting which changes the back colour of that field if the date in the field is within 30 days of the current date, and again to another colour if the date in the field has...

I have looked at similar problems on this forum, but cannot make sense from any of it, so am looking for a simple solution that even I can follow. In my database, I have a form which shows an employees details, including their Employee Number, name etc. In this form I want to put a subform...

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

I am creating a database and am totally up against a brick wall. Would some kind soul be good enough to have a look at what I am trying to do and give me some help. I would rather forward entire DB to an individual and explain the situation as I think it is quite complex. It involves queries...

In my database I have a form (frmHandover) which is bound to a table. This form has text box fields including a field for EmployeeNo. I also have an unbound text box on this form into which I want to have the employees name etc added, depending on what is in the employeeNo field. The employee...

I am putting together a database to record staff performance appraisals. I am a little stumped as to the best way to go about setting the following part up, and was wondering if someone could give me some ideas. I have a main table which records each employees details. I also have a table that...

Hi all I'm not sure if this is the correct area for this question but I think it is. My DB stores records relating to accountable books, which are all stored with the serial numbers etc (like ledger books with pages that have serial numbers). Each book contains a series of numbers that is...

I have created a database that I have converted into an MDE file so as to ensure my users don't fiddle with the makeup of the database. Is there a simple way to extract or export all the data stored in this database to another database? :confused:

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

Hi In my database, I have a couple of forms to enter data. If I open one of these forms then close it again without entering anything, no new record is saved. However, if I enter data into the first field, tab to the next, then decide not to enter the date and delete all fields and close the...

In my form I have made, I have added a label which becomes visible when records are updated. It works a bit like a message box but is part of the form and only becomes visible once the update is done. Is there a way that I can put a time on this label so it is only visible for say 10 seconds? I...

I have a table in my database set up so the user cannot enter duplicate records. When I test the associated form and try to enter duplicate records, I get a message after clicking the next or new record button that I cannot go to the record. This, I assume, is Access' error message for this...

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