Results 1 to 6 of 6
  1. #1
    jonesy29847 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Detroit area
    Posts
    43

    Tabbed forms


    I have a data base with several forms that I have designed, I want to convert the to tabbed forms, and I am having a great deal of difficulty.

    The forms use different tables, sometimes I want information from one table displayed on one or two forms but not all.

    Thanks in advance for your help.

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529

  3. #3
    jonesy29847 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Detroit area
    Posts
    43
    When I try that method I lose the inputs to my query, and thus my report. I need to pass values to the queries, and I don't understand how to make that happen.

    I tried using TempVars, but no luck yet.

  4. #4
    jonesy29847 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Detroit area
    Posts
    43
    OK, I am working this through, not completely solved, but I am getting there, thanks for help.

  5. #5
    jonesy29847 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Mar 2010
    Location
    Detroit area
    Posts
    43
    I am getting values from TempVars, but the interesting thing is the Query fails when I qualify the the date, even when hard coded. The SQL is below.

    Code:
    SELECT Task.Holiday, PrimaryCustomer.Approver, BillingInfo.DTSaturday, BillingInfo.OTAfter50Hrs, BillingInfo.OTAfter40Hrs, Task.JobNo, Task.Task, Task.TaskDate, Task.Description, Task.Start, Task.Stop, Task.Lunch, Format(Abs([Start]-[Stop])*24,"0.0") AS Expr1, Task.ContractorEmployee, Task.Travel, [Contractor/Employee].EmpName, Round(IIf([Lunch],0.0208333*24,0),1) AS TimeForLunch, ([Stop]-[Start]-[TimeForLunch]) AS [Time], Round(Abs(([Start]-[Stop])*24)-[TimeForLunch],1) AS Billable, ([STRate]) AS ST, ([OTRate]) AS OT, ([DTRate]) AS DT, PrimaryCustomer.CustName, PrimaryCustomer.StreetAddress, PrimaryCustomer.City, PrimaryCustomer.StateProvince, PrimaryCustomer.ZipPostalCode, PrimaryCustomer.PONumber, PrimaryCustomer.CustJobNumber, SecondaryCustomer.CustName, SecondaryCustomer.CustJobNumber, PrimaryCustomer.Terms
    FROM [Contractor/Employee] INNER JOIN ((((Task INNER JOIN BillingInfo ON Task.JobNo = BillingInfo.JobNo) INNER JOIN PrimaryCustomer ON BillingInfo.JobNo = PrimaryCustomer.JobNo) INNER JOIN SecondaryCustomer ON PrimaryCustomer.JobNo = SecondaryCustomer.JobNo) INNER JOIN EndCustomer ON SecondaryCustomer.JobNo = EndCustomer.JobNo) ON [Contractor/Employee].ID = Task.ContractorEmployee
    WHERE (((Task.JobNo)=[Tempvars]![queryJobNo]) 
    
    AND ((Task.TaskDate) Between #2/7/2011# And #2/8/2011#) AND ((Task.ContractorEmployee)=[TempVars]![queryEmpNo]));

  6. #6
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    When I try that method I lose the inputs to my query, and thus my report. I need to pass values to the queries, and I don't understand how to make that happen.

    I tried using TempVars, but no luck yet.
    Does this help you?

    http://www.datapigtechnologies.com/f...earchform.html

    Alan

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Tabbed form
    By leftylee in forum Forms
    Replies: 6
    Last Post: 03-14-2011, 12:45 AM
  2. Tabbed Form & Printing...
    By nchesebro in forum Forms
    Replies: 3
    Last Post: 12-20-2010, 03:03 PM
  3. 2007 forms with tabbed interface option
    By Syswizard in forum Forms
    Replies: 4
    Last Post: 12-06-2010, 12:31 PM
  4. tabbed forms .. QUICK question!
    By kroenc17 in forum Forms
    Replies: 2
    Last Post: 12-01-2010, 08:38 AM
  5. Tabbed Sub Form
    By Vikki in forum Access
    Replies: 1
    Last Post: 02-10-2010, 10:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums