Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ProgEvalJAA

    Allow More Than One Form Per ID

    I need to change the design of a form from allowing only one from per customer id to multiple forms per customer id. My database specifics are as follows: 1. The data entry form has two components, a header and a subform linked to the main form based on customer id number. 2. All the fields...
  2. ProgEvalJAA

    Formatting Pivot Tables in Excel 2007

    I want to format a pivot table appropriately such that when I have two entries falling underneath the same group both lines say the group number. What I Have Now: Sum of Amount Group Name Total 1 Julie 5 2 Jon 10 Leo 9 3 Tim 5 4 Duane 8 Travis 7 How I would like the table to look...
  3. ProgEvalJAA

    Data Connections Between Access 2007 and Excel 2007

    Is there an easy way to use a data connection to connect an Excel 2007 workbook to an Access 2007 query? The query will then be separated into several different worksheets within the same Excel 2007 workbook. I want the data to be returned into Excel into a table-like format for each...
  4. ProgEvalJAA

    Counting/Totaling with Sub-Reports

    Thank you, dhookum. I created a totals query, turned it into a sbu-report and linked it to my main report using the region as the linked field. That seemed to do the trick for the groups totals.
  5. ProgEvalJAA

    Counting/Totaling with Sub-Reports

    I have 18 sub-reports, all linked to a master report using region as the linked field. The master report is grouped on region. The 12 regions are sorted in ascending order. Each sub-report provides a count of how many customers fall within any one region. Each region has its own pages due to...
  6. ProgEvalJAA

    Validation on Data Entry Form

    Thanks for all the help. This has all been helpful.
  7. ProgEvalJAA

    Validation on Data Entry Form

    AceMan, After going through some reference books and reviewing the line code by code, I have a question about the section pasted here. Is the Mid function being utilized for all three sets of my dual controls, or just the first one that lists CF1 Days or CF1 NA? For Each ctl In Me.Controls...
  8. ProgEvalJAA

    Validation on Data Entry Form

    1. Question 1 and Question 1 N/A are actually named: CF1 Days CF1 NA There are two possible boxes (fields) in which users can enter data. 2. Yes, there are actually 14 controls for the questions. I forgot about the three sets of controls (Questions 1, 10 and 11) when I started this thread...
  9. ProgEvalJAA

    Validation on Data Entry Form

    The statement lists my fields. The fields are question numbers. Completed = Not Null Three questions have two separate fields and cannot be combined into one field due to links to other programs, etc. The three questions are 1 and 1 N/A, 10 and 10 N/A, and 11 and 11 N/A. If one of the two...
  10. ProgEvalJAA

    Validation on Data Entry Form

    This additional information might help in forming an answer to my question. The Data Entry form needs to autopopulate that 12th field as "Y" if the following is true: IF 1 OR 1 NA is completed AND 2, 3, 4, 5, 6, 7, 8, and 9 are completed AND 10 OR 10 N/A is completed AND 11 OR 11...
  11. ProgEvalJAA

    Validation on Data Entry Form

    This is helpful, AceMan1; however, what if I want that 12th field to appear on a report and not prevent saving of records? The values in that 12th field (Y or N) are sent to a report that lists all customers. Users look for No indicators on the report to find customers for which they still...
  12. ProgEvalJAA

    Validation on Data Entry Form

    I have a data entry form with 12 fields. The first 11 fields are completed by the users. The last field asks the user if the entry is complete. What is the easiest method to use to automate the last field to populate Y for Yes if the first 11 fields are completed? Should I use a...
  13. ProgEvalJAA

    Compacting Access 2000/2003 databases

    28 Dec 09 14:28 I am having a problem with compacting the back end of an Access database. When I tried Compact and Repair, I receive an error that reads, "Could not find field 'Description." When I click on Help, I get "Could not find field <name> Error 3799. A column name that does not exist...
  14. ProgEvalJAA

    Compacting Access 2000/2003 Files

    Thank you so much! I'll move my question.
  15. ProgEvalJAA

    Compacting Access 2000/2003 Files

    I am having a problem with compacting the back end of an Access database. When I tried Compact and Repair, I receive an error that reads, "Could not find field 'Description." When I click on Help, I get "Could not find field <name> Error 3799. A column name that does not exist is being...
  16. ProgEvalJAA

    Error 2950 on Requery Method with Combo Box

    I finally discovered the problem. In reviewing the Property Sheet for the ComboBox for Staff Contact, I discovered the Other Tab (the tab right after the Event tab) was missing something. The name StaffContact needed to be filled in here, and it was blank. Once I did that, everything worked...
  17. ProgEvalJAA

    Error 2950 on Requery Method with Combo Box

    AceMan1, Let me try to explain things better. 1. I have a combo box for Staff Contact as follows: The label portion of the control is Employee Name. The unbound portion of the control, the part I am trying to refresh is set as follows: Control Source = StaffContact (comes from Main table)...
  18. ProgEvalJAA

    Error 2950 on Requery Method with Combo Box

    I am using Access 2007. Yes, I have queries as the RowSource(s) of my ComboBox and Form. They are two different queries.
  19. ProgEvalJAA

    Error 2950 on Requery Method with Combo Box

    I moved the macro to the GotFocus event, and I still received the same error.
  20. ProgEvalJAA

    Error 2950 on Requery Method with Combo Box

    My specific question is: What step(s) am I overlooking with the Requery Method that I receive an error? I have a form with a field labeled "Staff Contact." After a user inputs a new Staff Contact, saves the record and then moves to the next record, I want the requery method to refresh the list...

Part and Inventory Search

Back
Top