Search results

I know its been asked before. But, im asking again to see if it can be done. Im at my wits end with this one.

I have a query built that gives me info per employee. I built a question into the criteria that ask for the employees name. When a person types the name results are given. If the person mispells the name, results are not given. I have everyones name on a seperate table. How do i create a pull...

Hello, I have a 101 page word report that i would like to add into a access report. I have an access table where numbers are entered and i would like these numbers to be placed in certian areas of the report. How could i add this report with the same page breaks format etc..? As always, thanks...

Good evening, How can i convert a .mde back to a .mdb? I need to change some material on our program and have lost the .mdbs!!!!!:banghead:

I have used the wizard to set up a button that copies a previous record to a new record. In the record, thier is a subform with employee #'s. I would like this to copy over as well. Thanks in advance for any help! Andre':)

Hello, I have a query that retrieves data by the latest date for the entries made for the year 2012. I need to include for the year 2011 also. Example. If I have 10 work sites and I visited each worksite in 2011 and only three worksites in 2012 I would like the query to show the last date of...

We are building a database to keep track of safety observations. Everyday, excel files will be emailed to me with observation material (20 items). I would like access to automatically ping my email, see the excel file and add to, not overwrite data in a table. This would save tons of data...

Ok, Forms are used to enter data in a table. I have a database that keeps track of manuals on boats. Once a manual is removed, i want the record to be taken off of the table and go to a table of "removed forms". Basically I do not want to see this record but I do not want it deleted. Thanks...

I have a report that shows the dates of employee visits. I would like to filter this to show only the last date an employee visited. example: Instead of John doe 01/01/2010 John doe 01/02/2010 John doe 01/03/2010 I would like the report to show John Doe 01/03/2010 As usual, thanks in...

I have a query which combines data from two tabes (main tabe and sub table) In the main table I have a field named "boat" in the sub table, I have a check box showing if the boat did a drill for a quarter of a year. If my boat named alice did a drill for the first three quarters, I want the...

I have placed the following criteria in a query field (([Total Worked]+[Total Rest])/24) this query mixes two tables. in both tables, I have the "Total Worked" fields. How do I write the above criterial pulling "total Worked" from table two and not from table one? Thanks in advance.

I have a table with the following fields Total Hours Total Hours worked Total Hours Rest I would like to automatically populate the Total Hours field by adding the other two field together. I can do it on a form with the following formula in an unbound field but it does not carry over to the...

Hi, I would like to place an unbound box on a form to show the words "Time Violation" if the following is true between two fields on the form. if "total hours worked" > "total hours rest" Can someone help me with the syntax for this? As always, thanks in advance!:D

I have been trying to figure out a formula to determine if an item is expired. i would like to compare the "maindate" to an "expiration date" i would like this to show up 60 days before the expiration date expires. for example if the expiration is 11-30-2010 i I would like a warning to appear...

Hello, I have a report that pulls from a query. This query has info from a form and subform. I have recently been asked to add another field from another subform. How do I show two subforms on one report? Thanks in advance

:eek:I have a query built off of a table and subtable. the report that is generated worked fine until I added another field from another subtable. The new field shows "visitors" there can be up to four visitors at a time recording info. Now, the query shows four identical entries for...

Hello GURU's, I have a report that displays information on visitors to a work site. The report sorts by the "visitor" field of a query. My boss now wants me to add 3 more visitor fields. How would I (in a query or report) allow the "visitor", "Visitor_1"... fields to work on my report...

I placed a button on my form to copy the previous record. It works but does not copy the subform info. Is there a way to copy the previous record plus subform at the same time with one click and place in a new form? Thanks in advance GURU's:eek:

I would like to clear a check box on a form. i have a check box that is activated manually when I have an "action item" on my form. when an employee clears an "action item" a date is entered in the date cleared box. I would like the check box to automatically clear when a date is entered in...

:cool::cool:I have a query that shows me my crewmembers training records. thanks to Tiro Cupidus and Khawmar for the help on that! This query displays the dates that the training was done and using an iif statement, shows me the trainings with no dates resulting in a "Not Performed" statement...