Search results for query: *

I know this is how to reference a control in an active parent form. Forms([Screen].[ActiveForm].[Name])!txtFirstName.Visible = False But how do I reference a control in an subform of that active parent form? TIA

I have a query question. I have a table with Patient Name, Date of Visit, and Flu, MMR & Polio vaccinations. The flu vaccine is good for 1 year only. MMR vaccine is good for 2 years. Polio is good for 3 years. How do I create a query to show example#2? example#1 Here's what I have.... ID...

I have a Form1 with a command button that opens Form2. Form2 displays the record count in the form footer. Then I have a code that copies the record count on Form2 back to a textbox in Form1. My problem is, Access copies the record count right away before the Form2 even calculates the record...

I am using this Change SQL property of saved query (DAO) function by Mr. dhookom (faq701-7433) on my form. However the new strSQL won't load until after I reopen the form the second time around. Any idea why it isn't loading the first time? Or is there a work around on this? I am using Access...

I have a query. In one of the fields I have this expression… Expr1: IIf(InStr([FieldName],"(")=0,[ FieldName],Left([FieldName],InStr([FieldName],"(")-1)) Then on the criteria, I have… Like [Forms]![FormName]![txtFieldName] But when I run it I get an error “Data type mismatch in criteria...

I need to run a report based on the selected year on the form. I have 5 tables with different years worth of data; (I know this is a bad idea but this is what my manager wants) tblYear2011 tblYear2012 tblYear2013 tblYear2014 tblYear2015 I also have a form with combobox where a user can...

I have created an access database in a shared drive so that employees can enter their production data, and the bosses to view the report. One of the employee drag and drop this access file to his folder on his computer creating a duplicate database. He has entered over a thousand new record on...

I have a query that filters the years based on a form input. Here is how the filter looks like: WHERE (((Format([Request Date],"yyyy"))=[Forms]![frmStatus]![txtStatusYear])); When I click Run... The query runs fine. The union query runs fine. However, the crosstab query gives me an error. It...

I need to create a report that shows the monthly total per column. For example, these are the records from a table: ID Payment Date Payment Method Coupon Mailed Date Responded Turnaround Time 1 02/01/2014 Cash 03/01/2014 05/12/2014 73 2 02/15/2014 Credit 02/25/2014 03/01/2014 5 3...

I have a table with 3 columns, ID, LogIn and LogOut. How do I create a querry with 3 columns grouped weekly with Login totals and Logout totals for that week. Example: DateTable ID LogIn LogOut 1 01/01/2014 01/01/2014 2 01/10/2014 01/27/2014 3 01/10/2014 01/30/2014 4 01/13/2014 01/23/2014 5...

Hello! As the title said, I need help on how to get the first and last word from a field. For example, a field contains a contact name "Mr. John Lennon". From a textbox, how to I make it show "Mr. Lennon" only? Thanks in advance.

I have 2 tables, tblEmployees and tblManagers I have a main form which contains Employees name & info and a subform with Managers name & info. From time to time employees get switched around from different managers. So from the subform I have a combobox that I can select the managers name and...

Hello! Here's what I have... I have a form with all the client's info (address, telephone, etc) and a subform which contains contract number, approval date, termination date, etc in a continuous form view. I want Access to automatically send an email whenever a user adds or deletes a record in...

How do you copy all previous records of a subform to a new record? I need to create in inventory database of our laboratory equipment. It should list all equipments we have every 3 months. I was thinking, I'm going to create the first table for the entry date or the date of the inventory, and...

I have a table with CustomerName, YearSampled, and TestResult fields. How do I create a query that shows 2009 vs 2010 TestResults per Customer? I am planning to create a report that shows 3 columns, CustomerName, 2009 TestResult & 2010 TestResult. Thank you in advance.

How do you get a percentage of an item compare to another item on the same table? Example: I have a table of pizza ingredients with ingredients and gallon fields.         Ingredients    Gallon         cheese             10         pizza sauce     25         mushroom        5 How can I...

  I have a button on my form that sends & attaches a report to an email. How do I create a log (with automatic entry) of when an email was sent, and if possible to whom it was sent. Please help, thanks.

Is it possible to create vertical records on details area? What I mean is, instead of new records appearing under the previous records, it would show on the right side of the previous records. Instead of in rows, it should be in columns. If so, kindly show me how please ;) TIA

I have a #Error on every fields of my record. When I try to delete the record it says "Invalid argument". How do I delete this particular record?

I have a table with Patient's Name, Year Visited, Check-up, Laboratory, X-ray, Dental & Vision columns. Check-up, Laboratory & X-ray exams are done every year. Dental and Vision exams are done every three years. I want to create a report where it will tell the user which test are not done...