Search results

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.

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

That is what is happening. In the query the link is per record and the other subtable "visitors" is the many side of a one to many.