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...
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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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)...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.