Recent content by trackmedic

Thanks on that one. A guy named Julian the access man wrote it. I see him on here sometimes. I thought maybe he would pop in.

ive tried to get the original from the creator since we now own the rights. But i am unable to obtain them so far. All i have to make is a few data changes and one format change. thanks!

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:

Thanks I will Try. I am not to good with query info and such but i think i understand.

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

Where do I place this? In the query or in the date field on the report?

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.